Updating Database from Gridview

  1. OleDbConnection con;  
  2. OleDbDataAdapter datapp;  
  3. DataSet ds;  
  4. OleDbCommandBuilder cmdbul;  
  5. public Form1()  
  6. {InitializeComponent();}  
  7. private void button1_Click(object sender, EventArgs e)  
  8. {  
  9.     try  {  
  10.                  cmdbul = new OleDbCommandBuilder(datapp);   
  11.                  datapp.Update(ds, "Details");  
  12.                  MessageBox.Show("Values Has been Updated");  
  13.          }  
  14.    catch (Exception ex)  
  15.              {  
  16.                 MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);                  
  17.              }  
  18. }  
  19.  private void Form1_Load(object sender, EventArgs e)  
  20.          {               
  21.             try               
  22.                {  
  23.                  con = new OleDbConnection();  
  24.                  con.ConnectionString = "Your Connection String";  
  25.                  con.Open();  
  26.                  datapp = new OleDbDataAdapter("Your Command for the database", con);                                              ds = new DataSet();  
  27.                  datapp.Fill(ds, "Details");  
  28.                  dataGridView1.DataSource = ds.Tables["Details"];  
  29.              }  
  30.              catch (Exception ex)  
  31.              {  
  32.                  MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);               
  33.              }                 
  34. }