大神指点:VB.net查询数据库的代码出错,希望指点
vb.net吧
全部回复
仅看楼主
level 2
876800912 楼主
代码:
Dim r As String
Dim b As String
Dim l As String
r = RX.Text
b = BJ.Text
l = LJ.Text
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=product.mdb"
Dim objConn As New OleDb.OleDbConnection(strConn)
Dim objAdap As New OleDb.OleDbDataAdapter()
Dim objDSet As New DataSet
objConn.Open()
Dim strSql = "Select*from product where 绕线组 LIKE r"
objAdap.SelectCommand = New OleDb.OleDbCommand(strSql, objConn)
objConn.Close()
objAdap.Fill(objDSet, "product")
通过筛选数据,得到满足条件的表,
2014年05月29日 13点05分 1
1