'首先引用Microsoft Activex Data Objects 2.x Library Dim objcon As New ADODB.Connection Dim objrs As New ADODB.Recordset objcon.Open "Provider=sqloledb.1;user id=sa;password=密码;Initial Catalog=数据库名;Data Source=" objrs.Open "存储过程 ", objcon, 3, 1 '再部件中添加DataGrid控件 Set DataGrid1.DataSource = objrs
Dim objcon As New ADODB.Connection
Dim objrs As New ADODB.Recordset
objcon.Open "Provider=sqloledb.1;user id=sa;password=密码;Initial Catalog=数据库名;Data Source="
objrs.Open "存储过程 ", objcon, 3, 1
'再部件中添加DataGrid控件
Set DataGrid1.DataSource = objrs