Bind DataGridView To Results of Access SQL Query String

Question

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

David · Accepted Answer · 2016-08-09 20:45:38Z

8

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0;User Id=;Password=;Data Source=" + fileName);
conn.Open();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query_txt.Text, conn);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
dataGridView.DataSource = ds.Tables[0];
conn.Close();

Note: query_txt.Text is the Query that you want to run. fileName is the path to where your file is stored.

edited Aug 9, 2016 at 20:45

David

5,0414 gold badges38 silver badges63 bronze badges

answered Sep 15, 2010 at 13:35

watbywbarif

7,1178 gold badges55 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steven Over a year ago

After updating my Access 2007 connection string with Provider = Microsoft.ACE.OLEDB.12.0. It worked perfectly!

Collectives™ on Stack Overflow

Bind DataGridView To Results of Access SQL Query String

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related