用MySQL数据填充Datagridview

Question

我尝试了多次，但是它就是无法用MySQL数据填充DataGridView表格，这是我的代码：

string connectionString = "SERVER=localhost;DATABASE=shootsource;UID=root;PASSWORD=;";
        string sql = "SELECT * FROM characters";
        MySqlConnection connection = new MySqlConnection(connectionString);
        connection.Open();
        sCommand = new MySqlCommand(sql, connection);
        sAdapter = new MySqlDataAdapter(sCommand);
        sBuilder = new MySqlCommandBuilder(sAdapter);
        sDs = new DataSet();
        sAdapter.Fill(sDs, "characters");
        sTable = sDs.Tables["characters"];
        connection.Close();
        dataGridView1.DataSource = sDs.Tables["characters"];
        dataGridView1.ReadOnly = true;
        dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

它只显示来自mysql表'characters'的列：id，name，time等...如何从数据库中填充它？

这是问题的图片：

- Catalin Mihai

---

它只显示列标题吗？这是你的意思吗？你确定表格中甚至有数据吗？ - Mike Park

有的，这里是一张照片：http://www.picz.ro/index.php?id=1dc2d2d989590d263a979c7a097124a0 - Catalin Mihai

我在那里看不到任何问题。 - Mike Park

你有任何可用的代码可以测试吗？ - Catalin Mihai

没事了，但现在它出错了，提示无法将日期/时间转换为字符串...?? - Catalin Mihai

Answer 1

       private void MySQL_ToDatagridview()
    {
        //VarribleKeeper.MySQLConnectionString = your connection string
       //info being your table name
        MySqlConnection mysqlCon = new  

        MySqlConnection(VarribleKeeper.MySQLConnectionString);
        mysqlCon.Open();

        MySqlDataAdapter MyDA = new MySqlDataAdapter();
        string sqlSelectAll = "SELECT * from info";
        MyDA.SelectCommand = new MySqlCommand(sqlSelectAll, mysqlCon);

        DataTable table = new DataTable();
        MyDA.Fill(table);

        BindingSource bSource = new BindingSource();
        bSource.DataSource = table;


        dataGridView1.DataSource = bSource;
    }

- Taco2

Answer 2

在设置数据源之后，需要执行数据绑定

dataGridView1.DataBind();

- AntLaC