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)
                       SqlDataAdapter sqlDa = new SqlDataAdapter();
                      sqlDa.SelectCommand = new SqlCommand(selectStatement, objSqlConctn);
                      SqlCommandBuilder cb = new SqlCommandBuilder(sqlDa);
                      sqlDa.UpdateCommand = cb.GetUpdateCommand();

Open in new window

ADITYA RAOSoftware DeveloperAsked:
Who is Participating?
Vikram Singh SainiConnect With a Mentor Software Engineer cum AD DeveloperCommented:
I think last two lines of  your code need to be changed as:

sqlDa.UpdateCommand = cb.GetUpdateCommand();

Open in new window

And why it is so? Answer at link: Does SqlCommandBuilder.GetUpdateCommand() need to be called before using SqlDataAdpater.Update()?

Also you can look at related article: Update database from DataGridView
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.