SqlConnection cn = new SqlConnection("Data Source=MICROSOF-406AD7\\SQLEXPRESS;Initial Catalog=JYDB;Integrated Security=True");
SqlCommand cm = new SqlCommand();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommandBuilder cb = new SqlCommandBuilder();
private void FrmPosiType_Load(object sender, EventArgs e)
{
cm = new SqlCommand("select * from HR_TrainType", cn);
da = new SqlDataAdapter(cm);
da.Fill(ds, "HR_TrainType");
this.dataGridView1.DataSource = ds.Tables["HR_TrainType"];
}
private void tsbSave_Click(object sender, EventArgs e)
{
cm = cn.CreateCommand();
cm.CommandText = "select * from HR_TrainType";
da = new SqlDataAdapter(cm);
cb = new SqlCommandBuilder(da);
da.Update(ds.Tables[0]);
this.dataGridView1.Update();
//MessageBox.Show("保存成功!");
}