private void 更新ToolStripMenuItem_Click(object sender, EventArgs e)
{
string constr = "Data Source=GENTLEMAN;Initial Catalog=hlx;Persist Security Info=True;User ID=sa;PassWORD=111";
SqlConnection con = new SqlConnection(constr);
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommandBuilder builder = new SqlCommandBuilder(da);
int n=da.Update(ds,"teacher");
if (n > 0)
{
MessageBox.Show("更新成功!");
}
else
{
MessageBox.Show("更新失败!");
}
da.Fill(ds, "teacher");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "teacher";
}
{
string constr = "Data Source=GENTLEMAN;Initial Catalog=hlx;Persist Security Info=True;User ID=sa;PassWORD=111";
SqlConnection con = new SqlConnection(constr);
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommandBuilder builder = new SqlCommandBuilder(da);
int n=da.Update(ds,"teacher");
if (n > 0)
{
MessageBox.Show("更新成功!");
}
else
{
MessageBox.Show("更新失败!");
}
da.Fill(ds, "teacher");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "teacher";
}