private void button4_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=毕设;User Id=sa;Pwd=20190019209020061");
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells[0] != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
//插入的数据为数据库对应列数,无论是否设置可为null,都需要进行添加,若列数不匹配,会报错
string name = dataGridView1.Rows[i].Cells[0].Value.ToString();
string age = dataGridView1.Rows[i].Cells[1].Value.ToString();
string grade = dataGridView1.Rows[i].Cells[2].Value.ToString();
string profession = dataGridView1.Rows[i].Cells[3].Value.ToString();
string phone = dataGridView1.Rows[i].Cells[4].Value.ToString();
string id = dataGridView1.Rows[i].Cells[5].Value.ToString();
string code = dataGridView1.Rows[i].Cells[6].Value.ToString();
string address = dataGridView1.Rows[i].Cells[7].Value.ToString();
string dept = dataGridView1.Rows[i].Cells[8].Value.ToString();
cmd.CommandText = "update doctor set 姓名='" + name + "',年龄='" + age + "',级别='" + grade + "',专业='" + profession + "',电话='" + phone + "',科室号='" + code + "',科室地址='" + address + "',科室='" + dept + "'where 医生编号='" + id + "'";
cmd.ExecuteNonQuery();
con.Close();
}
}
MessageBox.Show("更新成功");
}