Link to home
Start Free TrialLog in
Avatar of ADITYA RAO
ADITYA RAOFlag for India

asked on

How to save Datatable back to database in C#

I  have Datatable in which data is fetched by query from two tables in database.
Now I  have updated a value of  one particular column in Data Table.
I  want to save it back to database,but unable to do the same Please help
Here dtbPlate is my datatable in which I  already have values from two tables

                   
                        //Here dtbPlate is my datatable in which I  already have values from two tables
                       DataRow[] rowsToUpdate = dtbPlate.Select("TestCode ='" + iTestCode.ToString() + "'");
                      foreach (DataRow row in rowsToUpdate)
                      {
                          row["RLU"] = Convert.ToInt64(row["RLU"]) - avgBlanking;
                      }
                    
                      string selectStatement = "SELECT RLU FROM TblPlateSchedule";
                      SqlConnection objSqlConctn = new SqlConnection();
                      objSqlConctn.ConnectionString = "Server=(local);Database=DBLUMIQUANT;Trusted_Connection=True;";  //Assign connection String

                      if (objSqlConctn.State == System.Data.ConnectionState.Open)
                      {
                          
                      }
                      else
                      {
                          objSqlConctn.Open();
                      }
                       SqlDataAdapter sqlDa = new SqlDataAdapter();
                      sqlDa.SelectCommand = new SqlCommand(selectStatement, objSqlConctn);
                      SqlCommandBuilder cb = new SqlCommandBuilder(sqlDa);
                      sqlDa.UpdateCommand = cb.GetUpdateCommand();
                      sqlDa.Update(dtbPlate);

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Vikram Singh Saini
Vikram Singh Saini
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial