Select Query sql C# how to output the results to a DataGrid

Question

How do I output results from a refined query to a datagrid view called "customerDataGridView"?

string strCon = Properties.Settings.Default.PID2dbConnectionString;

using (OleDbConnection conn = new OleDbConnection(strCon)) {
   conn.Open();
   string strSql = "SELECT  * FROM customer WHERE City =Belfast";
   OleDbDataAdapter adapter = new OleDbDataAdapter(new OleDbCommand(strSql, conn));
}

Thanks for any help!

sgeddes · Accepted Answer · 2013-01-13 02:42:54Z

2

Try something like this for ASP.Net:

DataSet ds = new DataSet();
OleDbDataAdapter oledbAdapter = New OleDbDataAdapter(strSql, connection);
oledbAdapter.Fill(ds);
customerDataGridView.DataSource = ds.Tables(0);
customerDataGridView.DataBind();

Or something like this for WinForms:

DataSet ds = new DataSet();
OleDbDataAdapter oledbAdapter = New OleDbDataAdapter(strSql, connection);
oledbAdapter.Fill(ds);
customerDataGridView.DataSource = ds.Tables(0);

Good luck.

edited Jan 13, 2013 at 2:42

answered Jan 13, 2013 at 2:18

sgeddes

62.9k7 gold badges67 silver badges85 bronze badges

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

4 Comments

Bunion Over a year ago

under ".databind();" and "ds.Tables(0);" i get an eror saying "Error 1 'System.Windows.Forms.DataGridView' does not contain a definition for 'Databind' and no extension method 'Databind' accepting a first argument of type 'System.Windows.Forms.DataGridView' could be found (are you missing a using directive or an assembly reference?) "

Bunion Over a year ago

i dont seem to have anything like that, the closest thing to DataBind i have is DataBindings, maby im missing a libary?

sgeddes Over a year ago

Are you using WinForms? If so, check this link out: msdn.microsoft.com/en-us/library/fbk67b6z.aspx

Bunion Over a year ago

yes, sorry i didnt mention it in the orginal post. ok thanks il check it out

rs. · Accepted Answer · 2013-01-13 02:38:47Z

0

Try this

DataSet ds = new DataSet();
OleDbDataAdapter oda = New OleDbDataAdapter(strSql, conn);
oda.Fill(ds);
customerDataGridView.DataSource = ds.Tables(0);

For winform control you don't need DataBind()

answered Jan 13, 2013 at 2:38

rs.

27.6k13 gold badges71 silver badges93 bronze badges

Comments

Laila · Accepted Answer · 2013-01-13 04:59:26Z

0

Try the following after your code:

DataTable table = new DataTable();
adapter.Fill(table);
customerDataGridView.AutoGenerateColumns = True
customerDataGridView.Datasource = table;

edited Jan 13, 2013 at 4:59

answered Jan 13, 2013 at 2:19

Laila

4371 gold badge3 silver badges14 bronze badges

2 Comments

Bunion Over a year ago

under ".databind();" i get an eror saying "Error 1 'System.Windows.Forms.DataGridView' does not contain a definition for 'Databind' and no extension method 'Databind' accepting a first argument of type 'System.Windows.Forms.DataGridView' could be found (are you missing a using directive or an assembly reference?) "

Laila Over a year ago

Try removing the Databind(), you may not need it in windows forms. But make sure to set the dataGridView1.AutoGenerateColumns = True. Referring to this: stackoverflow.com/questions/1449773/…. They say that the datasource handles the binding.

Collectives™ on Stack Overflow

Select Query sql C# how to output the results to a DataGrid

3 Answers 3

4 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related