添加个取消按钮 取消对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("修改成功!");
        }

解决方案 »

  1.   

    DialogResult result=MessageBox.Show("确定要更改?","操作提示",MessageBoxButtons.OKCancel);            if (result==DialogResult.OK)
                {
                 sqlCommandBuiler builder=new sqlCommandBuiler(da);
                    da.Update(ds, "Book"); 
                //MessageBox.Show("修改成功!");             }