datagrid mysql数据库,如何将数据从mysql数据库导入datagridview

i have a table in mysql database named cms.order

and i am working on a widows form using C#.

How can i show the data from the table in database in the datagridview of the windows form

解决方案

You can use the following code to read the table data from database and display it into data gridview.

string connectionString = ""; //Set your MySQL connection string here.

string query =""; // set query to fetch data "Select * from tabelname";

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];

}

}