How to delete first row in DataTable

Question

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();

Rajanikant Hawaldar · Answer

Hi Rohan Gupta I agree with all the reply's but dont forget to 'null check and rowcount check' before delete

Gajendra Jangid · Answer

Hello Rohan, DataTable dt2 = dt1.Clone(); dt2.Rows.Remove(dt2.Rows[0]);

Dhanik Sahni · Answer

DataRow[] rows; rows=dataTable.Select( "UserName = 'ABC'" ); // UserName is Column Name foreach(DataRow r in rows) r.Delete();

Amit Kumar · Answer

Hi, You can use very simple code. Which is given below. dt.Rows.RemoveAt (0);

Sunil Sawant · Answer

string csvData = File.ReadAllText(csvPath); foreach (string row in csvData.Split('
')) { if (!string.IsNullOrEmpty(row)) { dt.Rows.Add(); int i = 0; foreach (string cell in row.Split(',')) { dt.Rows[dt.Rows.Count - 1][i] = cell; i++; } } } dt.Rows[0].Delete(); // first row removed.

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

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 (11)