Microsoft DataGrid Control 6.0可以使用Access2000数据库,你必须再添加一个Microsoft ADO Data Control 6.0控件并将两者绑定。 如果不用Microsoft ADO Data Control 6.0控件,也可以在程序中写代码实现,例如: '需引用Microsoft ActiveX Data Objects 2.7 Library Dim mConn As New ADODB.Connection Dim mRs As New ADODB.Recordset mConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\tempDB.mdb;" mConn.CursorLocation = adUseClient mConn.Open mRs.Open "select * from tempTable", mConn Set DataGrid1.DataSource = mRs
如果不用Microsoft ADO Data Control 6.0控件,也可以在程序中写代码实现,例如:
'需引用Microsoft ActiveX Data Objects 2.7 Library
Dim mConn As New ADODB.Connection
Dim mRs As New ADODB.Recordset
mConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\tempDB.mdb;"
mConn.CursorLocation = adUseClient
mConn.Open
mRs.Open "select * from tempTable", mConn
Set DataGrid1.DataSource = mRs