Updating a row in datatable 2016 administration database microsoft server skill sql updating

When the user is ready to update the gridview (via data table) to database, the user clicks a button. The code runs without error but when I checked the SQL Server table, the records are not updated. Data Item Index]["rate"]); decimal intestimated_expenses = intunit1 * intunit2 * intrate; dt. Data Item Index]["estimated_expenses"] = intestimated_expenses; Hi, I've found the solution. Data Item Index]["unit1"]); decimal intunit2 = Convert. Fill(dt);" Then I stored the Data Table to Session[Asset Expenses]. Update(dt);", it corrected UPDATED the records to SQL Server table. Is Post Back) { //string CS = Configuration Manager. Connection String; using (Sql Connection con = new Sql Connection(CS)) { Data Set ds = new Data Set(); Sql Data Adapter da = new Sql Data Adapter("Select * from trans.asset_expenses", CS); Data Table dt = new Data Table(); da. Open(); //Sql Command cmd = new Sql Command("select id, unit1,unit2,rate,estimated_expenses,description,asset_master_id,asset_expenses_type_id,is_active,period_id,estate_id FROM trans.asset_expenses", con); //using (Sql Data Reader rdr = cmd. To resolve this behaviour, I stored records from the "select" statement to a Data Table "da. Add("B", typeof(string)); Stopwatch watch = new Stopwatch(); watch.

mgebhard, Thank you for directing me to the url on saving data back to database using Table Adapter.

Data Item Index]["unit1"]); decimal intunit2 = Convert. From Sql Data Reader, I appended all records to Data Table. Primary Key = new Data Column[] ; //Update the values.

Data Item Index]["unit2"]); decimal intrate = Convert. Previously, I used Sql Data Reader to store records retrieved from "select" statement. Add("rate"); protected void gv Asset Expenses_Row Updating(object sender, Grid View Update Event Args e) { Data Table dt = (Data Table)Session["Asset Expenses"]; //dt.

New Row(); dr["id"]=rdr["id"]; dr["unit1"] = rdr["unit1"]; ... protected void gv Asset Expenses_Row Updating(object sender, Grid View Update Event Args e) { //Retrieve the table from the session object.

Execute Reader()) //{ // ///Data Set ds = new Data Set(); // ///// Sql Data Adapter da=new Sql Data Adapter // //Data Table dt = new Data Table(); // //dt.