如何将数据从mysql数据库导入到datagridview [英] how to import data from mysql database to datagridview

问题描述

我在mysql数据库中有一个名为cms.order的表 我正在使用C#处理寡妇形式. 如何在Windows窗体的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

推荐答案

您可以使用以下代码从数据库中读取表数据并将其显示在数据gridview中.

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

这篇关于如何将数据从mysql数据库导入到datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！