vb.net连接access数据库可以连上.但不能按照条件查询的.高手解决一下!
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con As OleDb.OleDbConnection
Dim cstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\小练习.mdb"
Dim sql As String = "select sales.bh,sales.xm,sales.gj,sales.zje from sales where sales.bh='23000001'"
Dim sales As DataSet = New DataSet
Dim cmd As OleDb.OleDbCommand
con = New OleDb.OleDbConnection(cstring)
If di1 = "" And di2 = "" Then
MessageBox.Show("请输入正确信息")
Else
con.Open()
cmd = New OleDb.OleDbCommand(sql, con)
cmd.ExecuteNonQuery()
cmd.CommandText() = sql
con.Close()
End If
End Sub