Winform使用ADO.NET的SqlDataAdapter更新多表資料

 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");
        }

    }