按下添加按钮后 datagridView 不刷新
代码 添加后 数据库中存在 窗体里不显示
if (bh1txt.Text == "")
{
MessageBox.Show("请输入教师编号!");
bh1txt.Focus();
return;
}
if (dd1txt.Text == "")
{
MessageBox.Show("请输入教师姓名!");
dd1txt.Focus();
return;
}
if (lx1txt.Text == "")
{
MessageBox.Show("请输入教师性别!");
lx1txt.Focus();
return;
}
if (lx1txt.Text == "")
{
MessageBox.Show("请输入授课专业!");
lx1txt.Focus();
return;
}
SqlConnection conn = new SqlConnection(ConSql1);
conn.Open();
string ConSql = "select * from 教师信息";
SqlCommand cmd = new SqlCommand(ConSql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read() == true)
{
if (bh1txt.Text.Trim().CompareTo(dr[0].ToString().Trim()) == 0)
{
MessageBox.Show("教师编号已存在,请重新输入");
return;
}
}
conn.Close();
string bianh = bh1txt.Text;
string mingc = dd1txt.Text;
string rens = lx1txt.Text;
string rens1= comSk.Text;
string ConSql2 = "insert into 教师信息 values('" + bianh + "','" + mingc + "','" + rens + "','" + rens1 + "')";
SqlConnection conn2 = new SqlConnection(ConSql1);
conn2.Open();
SqlCommand cmd2 = new SqlCommand(ConSql2, conn2);
cmd2.ExecuteReader();
TeacherInfo_Load(sender, e);