UC知道vb中的数据库查询问题
来源：百度知道 编辑：UC知道 时间：2024/05/24 01:42:18
在运行下面的代码后，会出现from语句错误的提示，请高手指点一二。Private Sub Form_Load()
Dim i As Integer
Adodc1.RecordSource = "select * from 库存表"
Adodc1.Refresh
cmbfield.Clear
For i = 0 To Adodc1.Recordset.Fields.Count - 1
cmbfield.AddItem Adodc1.Recordset.Fields(i).Name
Next i
cmbfield.Text = cmbfield.List(0)
End Sub
Dim i As Integer
Adodc1.RecordSource = "select * from 库存表"
Adodc1.Refresh
cmbfield.Clear
For i = 0 To Adodc1.Recordset.Fields.Count - 1
cmbfield.AddItem Adodc1.Recordset.Fields(i).Name
Next i
cmbfield.Text = cmbfield.List(0)
End Sub
加上“Adodc1.commandType = adCmdText”试试！！
Adodc1.RecordSource = "select * from 库存表"
Adodc1.CommandType = adCmdText
Adodc1.Refresh
adodc1.recordsource="select * from 库存表"
试一下看看行吗
检查一下ADODC1的连接字符串看有没有问题，或看你的表名写错没有