var ReturnRecordSet:_Recordset;ReturnRecordSet:=ADOStoredProc1.Recordset; ADOQuery1.Recordset:=ReturnRecordSet;ReturnRecordSet:=ReturnRecordSet.NextRecordset(RecordsAffected); ADOQuery2.Recordset:=ReturnRecordSet;Grid1->DataSource->DS1->ADOQuery1 Grid2->DataSource->DS2->ADOQuery2
select * from table1
select * from table2
GO这样就存储过程就是返回了2个记录集,在Delphi写的客户端用 adostoreproc.nextrecordset()就得到2个记录集。
楼上的。我是要直接绑定到GRID可以吗。我现在只能绑第一个数据集
ADOQuery1.Recordset:=ReturnRecordSet;ReturnRecordSet:=ReturnRecordSet.NextRecordset(RecordsAffected);
ADOQuery2.Recordset:=ReturnRecordSet;Grid1->DataSource->DS1->ADOQuery1
Grid2->DataSource->DS2->ADOQuery2