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