I have a datagridview and i want it to display the results from a query. How would i go about doing this. Here is my code so far:


Code:
        Dim searchStr As String = S_date_menuItem.Text.Remove(0, S_date_menuItem.Text.IndexOf("'") + 1)
        searchStr = searchStr.TrimEnd("'")

        adapter = New OleDb.OleDbDataAdapter("select * from account where Date= @Date", acctconstr)
        adapter.SelectCommand.Parameters.AddWithValue("@Date", searchStr)
that is my query but i don't know how to get my datagrid to display the results.