添加个取消按钮 取消对dataGridView未更新的修改 如何实现
SqlDataAdapter da;
DataSet ds;
SqlConnection conn;
private void Form1_Load(object sender, EventArgs e)
{
//实例你自己的连接对象,请在SqlbConnection()里加自己的连接字符串
conn = new SqlConnection(@"Server=(local)\sqlexpress;Integrated Security=True;" + "Database=scc");
conn.Open();
da = new SqlDataAdapter("SELECT * FROM Book", conn);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "Book");
dataGridView1.DataSource = ds.Tables["Book"]; }
private void button1_Click(object sender, EventArgs e)
{
da.Update(ds, "Book");
MessageBox.Show("修改成功!");
}
SqlDataAdapter da;
DataSet ds;
SqlConnection conn;
private void Form1_Load(object sender, EventArgs e)
{
//实例你自己的连接对象,请在SqlbConnection()里加自己的连接字符串
conn = new SqlConnection(@"Server=(local)\sqlexpress;Integrated Security=True;" + "Database=scc");
conn.Open();
da = new SqlDataAdapter("SELECT * FROM Book", conn);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds, "Book");
dataGridView1.DataSource = ds.Tables["Book"]; }
private void button1_Click(object sender, EventArgs e)
{
da.Update(ds, "Book");
MessageBox.Show("修改成功!");
}
{
sqlCommandBuiler builder=new sqlCommandBuiler(da);
da.Update(ds, "Book");
//MessageBox.Show("修改成功!"); }