Hi Triffid,

you can refer to the code below to update your database using the coommand
builder by generating the update command automatically.

protected void Button1_Click(object sender, EventArgs e)
   {
       string connstr = "provider = SQLOLEDB; data source =
in-ts-manish\\sqlexpress; integrated security = SSPI; database = pubs";
               OleDbConnection myconn = new OleDbConnection(connstr);
               // Create a dataset.
               DataSet ds = new DataSet();
       // Create  dataadapters for each tables.
               OleDbDataAdapter myadpt = new OleDbDataAdapter("select *
from dbo.authors", myconn);
       myadpt.Fill(ds,"authors");

       ds.Tables["authors"].Rows[1]["au_lname"] = "Singhal";
       OleDbCommandBuilder scb = new OleDbCommandBuilder(myadpt);
       myadpt.UpdateCommand = scb.GetUpdateCommand();
       myadpt.Update(ds,"authors");

       this.GridView1.DataSource = ds;
       this.GridView1.DataBind();
   }

Regards,
Manish
www.componentone.com