I would like to bind a DataGridView
to the results of a query generated as text at runtime.
How can I send a query as text to Microsoft Access and bind the results to the DataGridView?
When the user clicks the button (ok_btn
), I want the contents of the textbox (query_txt.Text
) sent to Microsoft Access, then I want the results of the query shown in my DataGridView (results_grid
).
Simple one-row queries are fine for now: (SELECT "a";
, SELECT "a", "b";
, SELECT now();
)
NOTE: C# accepted, VB.NET preferred