Public con As New ADODB.Connection
Public rs As New ADODB.RecordsetconStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\info.mdb" + ";Persist Security Info=False"
con.Open conStrrs.CursorLocation = adUseClient
dgStr = "Select * From [NP_Magzine]"
rs.Open dgStr, con, 3, 3Set dg.DataSource = rs
For i = 0 To 1
dg.Columns(i).DataField = rs.Fields(i).Name
Next i注:DataGrid控件名称为dg上述代码运行后,DataGrid能显示数据库相应记录条数的空白行,但无内容。尝试用TextBox文本框和rs绑定,能正常显示数据请各位朋友帮忙,谢谢!
Public rs As New ADODB.RecordsetconStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path & "\info.mdb" + ";Persist Security Info=False"
con.Open conStrrs.CursorLocation = adUseClient
dgStr = "Select * From [NP_Magzine]"
rs.Open dgStr, con, 3, 3Set dg.DataSource = rs
For i = 0 To 1
dg.Columns(i).DataField = rs.Fields(i).Name
Next i注:DataGrid控件名称为dg上述代码运行后,DataGrid能显示数据库相应记录条数的空白行,但无内容。尝试用TextBox文本框和rs绑定,能正常显示数据请各位朋友帮忙,谢谢!
For i = 0 To 1
dg.Columns(i).DataField = rs.Fields(i).Name
Next i
dg.Columns(i).DataField = rs.Fields(i).Name
Next i顺序倒过来。试试看For i = 0 To 1
dg.Columns(i).DataField = rs.Fields(i).Name
Next iSet dg.DataSource = rs