C#基础学习23（DataSet查询和更新数据）

 窗体代码：

DataSet ds = new DataSet();
//点击查询
private void 查询数据ToolStripMenuItem_Click(object sender, EventArgs e)
{
    LoadDSData();
            
}
//点击更新
private void 修改更新ToolStripMenuItem_Click(object sender, EventArgs e)
{
    //连接字符串
    string connStr = "server=localhost;user id=root;password=123;database=strong;charset=utf8;port=3306";
    using (MySqlConnection conn = new MySqlConnection(connStr))
    {
        string sql = "select * from thesis";
        using (MySqlDataAdapter msda = new MySqlDataAdapter(sql, conn))//MySqlDataAdapter建立一个连接并执行查询，相当于MySqlCommand
        {
            MySqlCommandBuilder mscb = new MySqlCommandBuilder(msda);//自动生成单表命令，用于将对DataSet所做的更改与关联的MySql数据库的更改相协调
            msda.Update(ds, "thesis");//自动调用相对应的sql语句
            MessageBox.Show("操作成功");
            LoadDSData();
        }
    }
}
//查询数据库
private void LoadDSData()
{
    //连接字符串
    string connStr = "server=localhost;user id=root;password=123;database=strong;charset=utf8;port=3306";
    using (MySqlConnection conn = new MySqlConnection(connStr))
    {
        string sql = "select * from thesis";
        using (MySqlDataAdapter msda = new MySqlDataAdapter(sql, conn))//MySqlDataAdapter建立一个连接并执行查询，相当于MySqlCommand
        {
            conn.Open();//打开数据库
            ds.Clear();//清除下DataSet
            msda.Fill(ds, "thesis");
        }
    }
    dgv.AutoGenerateColumns = false;//禁止自动生成列
    dgv.DataSource = ds.Tables["thesis"].DefaultView;//绑定数据DefaultView视图
}

效果：