c#+ update database according to datagrid view

[radhikabista]

i have a table tbl_client in Ms Access database. my program displays a datagrid view with the search result records. i want to save the changes to data gridview to database.for this i call the update method of a class customer to save the changes when user click on update button. every time i run the code i get the run time error datatype mis match error in update statement.
my class goes like this:

public int update()
   {
      OleDbConnection con = new OleDbConnection(@"provider= Microsoft.Jet.OLEDb.4.0; Data Source = D:\My Documents\Visual Studio 2005\Projects\db2.mdb");
      con.Open();
 
      string sqlUpdate;
 
      sqlUpdate = " Update tbl_client Set fname= '@p1' Where client_id='@p0'";      
     // sqlUpdate = "Update tbl_client Set reg_date= '@p2', fname='@p3', lname= '@p4', mname= '@p5', gender= '@p6', address= '@p7', phone= '@p8', mobile='@p9', email='@p10', project_id= '@p11', visit_date= '@p12', agent= '@p13', feedback1= '@p14', remarks= '@p15' Where client_id= '@p1'";
      OleDbParameter[] pUpdate = new OleDbParameter[15];
 
 
      pUpdate[0] = new OleDbParameter("@p0", OleDbType.Integer, 40,"client_id");
      pUpdate[1] = new OleDbParameter("@p1", OleDbType.VarChar, 20, "fname");
      pUpdate[1] = new OleDbParameter("@p2", OleDbType.Date, 30, "reg_date");
      pUpdate[2] = new OleDbParameter("@p3", OleDbType.VarChar, 40,"fname");
      pUpdate[3] = new OleDbParameter("@p4", OleDbType.VarChar, 20,"lname");
      pUpdate[4] = new OleDbParameter("@p5", OleDbType.VarChar, 20,"mname");
      pUpdate[5] = new OleDbParameter("@p6", OleDbType.VarChar, 40, "gender");
      pUpdate[6] = new OleDbParameter("@p7", OleDbType.VarChar, 40, "address");
      pUpdate[7] = new OleDbParameter("@p8", OleDbType.Integer, 9, "phone");
      pUpdate[8] = new OleDbParameter("@p9", OleDbType.Integer, 9, "mobile");
      pUpdate[9] = new OleDbParameter("@p10", OleDbType.VarChar, 40, "email");
      pUpdate[10] = new OleDbParameter("@p11", OleDbType.VarChar, 40, "project_id");
      pUpdate[11] = new OleDbParameter("@p12", OleDbType.Date, 40, "visit_date");
      pUpdate[12] = new OleDbParameter("@p13", OleDbType.VarChar, 40, "agent");
      pUpdate[13] = new OleDbParameter("@p14", OleDbType.LongVarChar, 40, "feedback1");
      pUpdate[14] = new OleDbParameter("@p15", OleDbType.LongVarChar, 30, "remarks");
 
      OleDbCommand cmdUpdate = new OleDbCommand(sqlUpdate,con);
 
     // cmdUpdate.Parameters.AddRange(pUpdate);
 
 
      OleDbDataAdapter da = new OleDbDataAdapter();
      OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
     // DataSet ds = new DataSet();
 
      da.UpdateCommand  = cmdUpdate;
      int  i=da.Update(ds);
      ds.AcceptChanges();
      if (i > 0)
      {
          MessageBox.Show("database updated");
      }
      else {
          MessageBox.Show("update error.");
      }
     return i;
 
    }

what is the problem with my update method.

thanks in advance
Radhika

[kenobewan]

Let's start with the update query, if you have the name of the parameter in single quotes its a string...