现有一个存储过程,如:
CREATE proc temp
@bookid varchar(3)
as
select *
from booksinfo
where bookid=@bookid
GO
用Command调用后怎么把记录集给MSHFlexGrid?
如果返回的是两个记录集又该怎么把它都显示出来,哪怕是用两个MSHFlexGrid也行。
...全文
1668打赏收藏
怎样把Command返回的记录集给MSHFlexGrid
现有一个存储过程,如: CREATE proc temp @bookid varchar(3) as select * from booksinfo where bookid=@bookid GO 用Command调用后怎么把记录集给MSHFlexGrid? 如果返回的是两个记录集又该怎么把它都显示出来,哪怕是用两个MSHFlexGrid也行。
用ADO
dim cn as new adodb.connection,rs as new adodb.recordset
cn.open "连接数据库字符串......"
Set rs = cn.Execute("exec temp 参数", , adCmdStoredProc)
Set MSHFlexGrid1.DataSource = rs