How to Update DataTable object data in C#

Question

Pankaj Kumar Choudhary · Answer

Hello @Lalit you can use AcceptChange Method like this: if (Convert.ToInt32(row["id"]) == 4) { row["Name"] = "Priya Yadav"; dt.AcceptChanges(); }

Munesh Sharma · Answer

DataTable dt = new DataTable(); DataRow[] dr = dt.Select("ItemCode ="+ItemCode); { dr [ 0 ][ "ItemName" ] = txtItemName . Text ; dr [ 0 ][ "ItemName" ] = txtItemName . Text ; dr [ 0 ][ "GroupCode" ] = txtGroup . Text ; dr [ 0 ][ "Price" ] = txtPrice . Text ; dr [ 0 ][ "Descriptions" ] = txtDescriptions . Text ; }

Nanhe Siddique · Answer

read this link http://stackoverflow.com/questions/1666087/c-sharp-how-to-change-data-in-datatable it may help you

Lalit Raghav · Answer

DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(int)); dt.Columns.Add("name", typeof(string)); dt.Rows.Add(1, "lalit"); dt.Rows.Add(2, "Manoj"); dt.Rows.Add(3, "Mahesh"); dt.Rows.Add(4, "Priya"); foreach (DataRow row in dt.Rows) { if (Convert.ToInt32(row["id"]) == 4) { row["Name"] = "Priya Yadav"; } }

How to Update DataTable object data in C#

Answers (4)