Winform使用ADO.NET的SqlDataAdapter更新多表数据

最新推荐文章于 2023-11-25 12:49:15 发布

忙碌的布谷鸟

最新推荐文章于 2023-11-25 12:49:15 发布

阅读量1.9k

点赞数 1

分类专栏： winForm 数据库编程 C#基础文章标签： winform dataset insert object email class

本文链接：https://blog.csdn.net/guoquanyou/article/details/7420987

版权

数据库编程同时被 3 个专栏收录

37 篇文章 0 订阅

订阅专栏

C#基础

17 篇文章 0 订阅

订阅专栏

winForm

10 篇文章 0 订阅

订阅专栏

public partial class Form1 : Form
    {
        DataSet ds = new DataSet();
        SqlDataAdapter adapter = null;
        DBHelper dbHelper = new DBHelper();
        public Form1()
        {
            InitializeComponent();
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            DataGridViewRow row = this.dgvStudent.CurrentRow;

             StringBuilder strBuilder = new StringBuilder();
            strBuilder.Append("insert into student values('");
            strBuilder.Append(row.Cells["LoginPwd"].Value);
            strBuilder.Append("','");
            strBuilder.Append(row.Cells["StudentName"].Value);
            strBuilder.Append("','");
            strBuilder.Append(row.Cells["Gender"].Value);
            strBuilder.Append("',");
            strBuilder.Append(row.Cells["GradeId"].Value);
            strBuilder.Append(",'");
            strBuilder.Append(row.Cells["Phone"].Value);
            strBuilder.Append("','");
            strBuilder.Append(row.Cells["Address"].Value);
            strBuilder.Append("','");
            strBuilder.Append(row.Cells["Birthday"].Value);
            strBuilder.Append("','");
            strBuilder.Append(row.Cells["Email"].Value);
            strBuilder.Append("');");
            strBuilder.Append("update teacher set sex='Ů' where teacherId=6;");

            adapter.InsertCommand = new SqlCommand(strBuilder.ToString(),dbHelper.Connection);
            adapter.Update(ds, "student");
        }

}