VB+ACCESS如何做条件查询啊
各位大神，现在问个问题，VB+ACCESS如何做条件查询啊
例如，我在这里textbox.text这里的值为A，执行查询以后，就在datagridview里面显示相应的查询结果啊！
VB DataGridView
[解决办法]
...
sql = "select * from table where xxx = '" + textBox.Text + "'";
...
[解决办法]
sql 语句会写吧，写好了之后，用我下面这个函数生成一个DataTable
再将你的DataGridview1.dataSourse=GetTableFromSql(你的sql语句),就可以显示了
''' <summary>
''' 根据sql语句返回一个DataTabel
''' </summary>
''' <param name="str_sql"></param>
''' <returns></returns>
''' <remarks></remarks>
Public Shared Function GetTableFromSql(ByVal str_sql As String) As DataTable
Dim dt As New DataTable
Try
Using conn As New OleDb.OleDbConnection(g_str_DbConStr)
conn.Open()
Using comm As New OleDb.OleDbCommand
comm.Connection = conn
comm.CommandText = str_sql
Dim da As New OleDb.OleDbDataAdapter()
da.SelectCommand = comm
da.Fill(dt)
End Using
End Using
Catch ex2 As Exception
MsgBox(ex2.ToString())
End Try
Return dt
End Function
