Dim cnn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rst As New ADODB.Recordset
...
cnn.Open "..."
cmd.Name = "yourCommandName"
cmd.ActiveConnection = cnn
...
'Your command name, any parameters, and an optional Recordset.
cnn.yourCommandName "parameter", rst
Set datagrid1.Darasource=rst
Datagrid1.Refresh
Private Sub Form_Load()
Dim x As New Collection
Dim adoRecordset As New ADODB.Recordset
Dim i As Integer
For i = 0 To 59 'fill collection
x.Add String(i \ 5 + 1, Chr(i Mod 5 + 65))
Next
For i = 0 To 5 '为Recordset六个字段,即为 DataGrid 添加六列
adoRecordset.Fields.Append "n * " & i + 1, adVariant, , adFldMayBeNull + adFldIsNullable + adFldUpdatable
Next i
adoRecordset.Open
For j = 0 To 9
adoRecordset.AddNew '加十条记录,即为 DataGrid 添加十空行
Next j
Set DataGrid1.DataSource = adoRecordset '绑定 DataGrid 的数据源
adoRecordset.MoveFirst
'fill datagrid
For i = 0 To 5
For j = 0 To 9
DataGrid1.Row = j
DataGrid1.Col = i
DataGrid1.Text = x(j * 5 + i + 1)
Next
Next
End Sub