注册 登录
编程论坛 VB6论坛

求助~如何将数据显示在 DataGrid 上

admin73896 发布于 2014-06-05 11:22, 459 次点击
Private Sub Form_Load()
Dim conn As ADODB.Connection
Dim rs As New ADODB.Recordset
Dim Connstr As String
Dim Mdbpath As String
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
Connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\D:\VB数据\db1.mdb"
conn.Open
rs.CursorLocation = adUseClient
rs.Open "select 档案编号,姓名 from 车辆档案表", conn, adOpenStatic, adLockOptimistic
Set DataGrid1.DataSource = rs
End Sub
1 回复
#2
alike1232014-06-05 14:42
先加一个控件adodc
strSQL="select 档案编号,姓名 from 车辆档案表"
Adodc1.ConnectionString = cn.ConnectionString
Adodc1.RecordSource = strSQL
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
1