strsql = "select * from product " Set Con = CreateObject("ADODB.Connection") '使用数据源来连接数据库 Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\product.mdb;" & ";Persist Security Info=False" Dim rs As New ADODB.Recordset Set rs = Con.Execute(strsql) Dim flag As Integer
或者
Dim adoPrimaryRS As New ADODB.RecordSet
-------------------PROJECT EXPLOROR里有没有missing....? 去掉,重新引用
1.我的VB6.0为什么不能使用NEW 关键字
Set adoPrimaryRS = New Recordset
提示是"invalid use of New keyword
2.PROJECT EXPLOROR下去没显示引用
可以解決很多這種問題.
strsql = "select huohao, mingcheng, pingpai, yangshi, leixing," _
& " yanse, cailiao, chicun1, chicun2," _
& "changdi, tupian, jiage, shuliang, shangshiri," _
& " faburi, jieshao, xiedi " _
& " from product "
strsql = "select * from product "
Set Con = CreateObject("ADODB.Connection")
'使用数据源来连接数据库
Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\product.mdb;" & ";Persist Security Info=False" Dim rs As New ADODB.Recordset
Set rs = Con.Execute(strsql)
Dim flag As Integer
Set DataGrid1.DataSource = rs这样一直绑不上去....又不知道咋了