#c#窗口使用DataGridView控件进行修改数据然后刷新怎么写
//这个是调用
private void btnXiugai_Click(object sender, EventArgs e)
{
Modify m = new Modify();
FrmNum frm = new FrmNum();
m.id = dgvNum.SelectedRows[0].Cells[0].Value.ToString();
m.name = dgvNum.SelectedRows[0].Cells[1].Value.ToString();
m.xb = dgvNum.SelectedRows[0].Cells[2].Value.ToString();
m.nj = dgvNum.SelectedRows[0].Cells[3].Value.ToString();
m.time = dgvNum.SelectedRows[0].Cells[4].Value.ToString();
m.ah = dgvNum.SelectedRows[0].Cells[5].Value.ToString();
frm.Show();
m.Show();
}
//这个就是窗口的类(修改)
string a = "server=.;database=MySchool;uid=sa;pwd=hebiao123456";
public string id = string.Empty;
public string name = string.Empty;
public string xb = string.Empty;
public string nj = string.Empty;
public string time = string.Empty;
public string xl = string.Empty;
public string ah = string.Empty;
private void btnBaoc_Click(object sender, EventArgs e)
{
SqlConnection b=new SqlConnection(a);
b.Open();
try
{
txtId.Text = id;
txtname.Text = name;
if (xb == "男")
{
rdoNan.Checked = true;
}
if (xb == "女")
{
rdoNv.Checked = true;
}
if (nj == "S1")
{
rdoS1.Checked = true;
}
if (nj == "S2")
{
rdoS2.Checked = true;
}
if (nj == "S3")
{
rdoS3.Checked = true;
}
if (xl == "幼儿园")
{
cboXueli.SelectedIndex = 1;
}
if (xl == "小学")
{
cboXueli.SelectedIndex = 2;
}
if (xl == "初中")
{
cboXueli.SelectedIndex = 3;
}
if (xl == "高中")
{
cboXueli.SelectedIndex = 4;
}
if (xl == "大学")
{
cboXueli.SelectedIndex = 5;
}
if (ah == "吃饭,")
{
chkEat.Checked = true;
}
if (ah == "打游戏,")
{
chkPlay.Checked = true;
}
if (ah == "睡觉,")
{
chkSleep.Checked = true;
}
time = this.dtpTime.Value.ToString("yyyy-MM-dd");
string xg = $"update Student set StudentName='{name}', Sex='{xb}', Gradeld='{nj}',BornDate='{time}',Hobby='{ah}', Education='{xl}' where StudentNo='{id}'";
SqlCommand xg2 = new SqlCommand(xg, b);
int xg3 = xg2.ExecuteNonQuery();
if (xg3 > 0)
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("修改失败");
}
}
catch (Exception)
{
throw;
}
b.Close();
}