Remove rows from datatable.

Question

Hi..I want to remove rows from my datatable based on index values. For example from row 5 to row 10.But not by using for or foreach loop.

Hemant Srivastava · Answer

Try to find out the required rows by SELECT extension method using ways listed in the following my article: http://www.c-sharpcorner.com/UploadFile/0f68f2/querying-a-data-table-using-select-method-and-lambda-express/ Then Use Remove(DataRow row) method to remove them.

Dhirendra Misra · Answer

Hello Santosh You can add one column to your datatable which is unique / index or make use of any existing column which can help you to filter your the required records. You can use DataView RowFilter to perform this. Refer: http://www.csharp-examples.net/dataview-rowfilter/ http://www.c-sharpcorner.com/UploadFile/jgodel/DataSetsOverview0611302005002923AM/DataSetsOverview06.aspx