利用DAO访问数据库,自己写的:dim db as database
dim rs as recordset
set db=opendatabase("e:\产品关系表.mdb")
set rs=db.openrecordset("select * from 货物表")
set datagrid1.datasource=rs 设置MSflexgrid的数据源这条语句报错。是哪里错了
dim rs as recordset
set db=opendatabase("e:\产品关系表.mdb")
set rs=db.openrecordset("select * from 货物表")
set datagrid1.datasource=rs 设置MSflexgrid的数据源这条语句报错。是哪里错了
set datagrid1.datasource=rs ????????
用这个连接吧,,
Dim dbstr As String
dbstr = App.Path
If Right(App.Path, 1) <> "\" Then dbstr = App.Path & "\"
dbstr = dbstr & "zhigeng.mdb"
Set db = New ADODB.Connection
db.Open "provider=microsoft.jet.oledb.3.51;" & "data source=" & dbstr
Set adorst = New ADODB.Recordset
set MSflexgrid.datasource=adorst
Dim strConn As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerName"
pubConn.Open strConn rsTable.CursorLocation = adUseClient
strSQL = "select * from TableName"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rsTableEnd Sub
dim db as DAO.Database
dim rst as DAO.RecordSet
.
.
.
你要用支持DAO的网格控件即可(老的)。
dim db as DAO.Database
dim rst as DAO.RecordSet
ADO 和 Adodc 、DataGrid 控件配合使用;好像 DataGrid 不支持 DAO 和 Data 吧!
但是,DataGrid 和 MSHflexgrid 的数据源支持在代码中指定,也可在设计环境中的属性页事先指定!