How can I read datatable cells value and change it and store

Question

How can I read datatable cells value and change it and store to sql database Thank for helping

Rajanikant Hawaldar · Answer

Hello Srm Matin here is sample code please go through it. private static void AdapterUpdate( string connectionString) { using (SqlConnection connection = new SqlConnection(connectionString)) { SqlDataAdapter dataAdpater = new SqlDataAdapter( "SELECT CategoryID, CategoryName FROM Categories" , connection); dataAdpater.UpdateCommand = new SqlCommand( "UPDATE Categories SET CategoryName = @CategoryName " + "WHERE CategoryID = @CategoryID" , connection); dataAdpater.UpdateCommand.Parameters.Add( "@CategoryName" , SqlDbType.NVarChar, 15, "CategoryName" ); SqlParameter parameter = dataAdpater.UpdateCommand.Parameters.Add( "@CategoryID" , SqlDbType.Int); parameter.SourceColumn = "CategoryID" ; parameter.SourceVersion = DataRowVersion.Original; DataTable categoryTable = new DataTable(); dataAdpater.Fill(categoryTable); DataRow categoryRow = categoryTable.Rows[0]; categoryRow[ "CategoryName" ] = "New Beverages" ; dataAdpater.Update(categoryTable); Console.WriteLine( "Rows after update." ); foreach (DataRow row in categoryTable.Rows) { { // Printing changes made to datatable Console.WriteLine( "{0}: {1}" , row[0], row[1]); } } } }

Jignesh Kumar · Answer

Hi Srm, Please find below link, https://www.c-sharpcorner.com/uploadfile/mahesh/updating-the-database-using-the-update-method-in-ado-net/ https://www.codeproject.com/Questions/362011/Find-and-Update-cell-in-DataTable

How can I read datatable cells value and change it and store

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)