How to delete first row in DataTable

Question

Abhay Shanker · Answer

Try as below- DataTable dt1 = ds . Tables [ 0 ]; foreach ( DataRowView dr in dt1 . DefaultView ) { dr . Row . Delete (); } // Finale step, remove the deleted rows dt1 . AcceptChanges (); also check below url https://msdn.microsoft.com/en-us/library/feh3ed13.aspx http://stackoverflow.com/questions/16753600/delete-row-from-data-table http://www.aspdotnet-suresh.com/2013/01/delete-particular-row-from-datatable-in.html

Manoj Bhoir · Answer

Hi, Before everyone jumps on the ' You can't delete rows in an Enumeration ' bandwagon, you need to first realize that DataTables are transactional , and do not technically purge changes until you call AcceptChanges() . Try this code : ds.Tables[0].Rows[0].Delete(); ds .Tables[0].AcceptChanges(); Or ds.Tables["TableName"].Rows[0].Delete(); ds.Tables["TableName"].AcceptChanges();

Vignesh Mani · Answer

Hi refer below link http://www.aspdotnet-suresh.com/2013/01/delete-particular-row-from-datatable-in.html http://stackoverflow.com/questions/6390904/deleting-row-from-datatable-in-c-sharp

Upendra Pratap Shahi · Answer

ds1.Tables[ "Customers" ].Rows[0].Delete();

Rajeesh Menoth · Answer

Hi, dataSet1.Tables[ "Customers" ].Rows[0].Delete(); Ref this : http://forums.asp.net/t/1470789.aspx?Deleteing+first+row+in+DataTable

Raja T · Answer

Hi Rohan, Please checkout below urls http://stackoverflow.com/questions/5648339/deleting-specific-rows-from-datatable http://stackoverflow.com/questions/6390904/deleting-row-from-datatable-in-c-sharp

How to delete first row in DataTable

Answers (6)