C# win forms datagrid view displaying MySql table

Question

Hi there i am trying to load MySql table data into a datagridview in my win forms application on button click, and cant seem to get it to work. I think im missing the binding source but im very confused.

Some help would be appreciated.

private void button3_Click(object sender, EventArgs e)
     {
         string connStr = "Data Source=localhost;port=3306;Initial Catalog=bitdb;User Id=root;Password='';"; 
         string query = "Select * from Client"; 
         using (MySqlConnection conn = new MySqlConnection(connStr))
         {
             using (MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn))
             {
                 DataSet ds = new DataSet();
                 adapter.Fill(ds);
                 dataGridView1.DataSource = ds.Tables[0];
             }
         }
     }

What does the debugger say? Getting the table successful? Including some columns? Also, don't you need some column definitions on the datagridview? — Pieter21
– Pieter21, Commented May 31, 2017 at 7:48

Mihail Stancescu · Accepted Answer · 2017-05-31 10:03:53Z

3

According to the documentation you should use a BindingSource with the DataGridView component. More information here.

private void button3_Click(object sender, EventArgs e)
     {
         string connStr = "Data Source=localhost;port=3306;Initial Catalog=bitdb;User Id=root;Password='';"; 
         string query = "Select * from Client"; 
         using (MySqlConnection conn = new MySqlConnection(connStr))
         {
             using (MySqlDataAdapter adapter = new MySqlDataAdapter(query, conn))
             {
                 DataSet ds = new DataSet();
                 adapter.Fill(ds);
                 var bindingSource = new BindingSource();
                 bindingSource.DataSource = ds.Tables[0];
                 dataGridView1.DataSource = bindingSource;
             }
         }
     }

Also, any error information would be helpful.

edited May 31, 2017 at 10:03

answered May 31, 2017 at 7:55

Mihail Stancescu

4,1681 gold badge18 silver badges22 bronze badges

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

1 Comment

James lee Over a year ago

thanks yer i was missing the binding the source iv got the data displaying now. Cheers again

Collectives™ on Stack Overflow

C# win forms datagrid view displaying MySql table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related