VB.NET: Load data from a MySQL database into a DataGridView control

Question

I want to put the information from my MySQL database to a DataGridView(DataGridView1).

My "MySQL" Columns are

ID, Username & Password

The connection string is

"server=localhost;user id=root;password=;database=exdb"

The table in my database(exdb) is "users" and I have all the necessary connectors, MySQL imports & Re & references in my project.

What should I do?

That is a basic question that you can easily find sample for on google; here is a link: ycouriel.blogspot.ch/2009/10/c-datagridview-and-mysql.html — noobob
– noobob, Commented Jan 23, 2013 at 9:26

bonCodigo · Accepted Answer · 2013-01-23 09:34:11Z

1

Yes it's something you can search online and find an asnwer. Give this simple code a try:

System.Data;
System.Data.SqlClient

//create connection , replace userID/password if you have.
MySqlConnection con = 
  new MySqlConnection(@"server=localhost;user id=root;password=;database=exdb");     
con.Open();
//user the table name as per yours
MySqlDataAdapter adp = new MySqlDataAdapter("Select * from table1;" ,con);

DataSet ds = new DataSet();
adp.Fill(ds);
//change name according to your datagridview
dataGridView1.DataSource = ds;
dataGridView1.DataBind();

answered Jan 23, 2013 at 9:34

bonCodigo

14.4k1 gold badge52 silver badges93 bronze badges

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

2 Comments

Aljie Over a year ago

Your importing SqlClient while using MysqlConnection, is that okay?

Aljie Over a year ago

you imported System.Data; System.Data.SqlClient But you're using Mysql connection, is there no error with that?

Collectives™ on Stack Overflow

VB.NET: Load data from a MySQL database into a DataGridView control

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related