Keep specific Rows in DataTable

[Sahil_Garg]

Dear Forum Members

I had a DataTable of unknown number of Rows i want to keep only top 5 .
I cannot use Filter . Is there any way to do
Any help will be appreciated .
Thanks
Sahil Garg

[william.coulson (Will Coulson)]

Hi @Sahil_Garg,

Try using a For Each Row with a counter. Set the counter to 0 before the loop, then enter the loop, and add the row to another DataTable. Then add one to the counter and the loop will start again. Once the counter is equal to 5, exit the loop. Would look something like this:

Edit: It should be count = 4 in If statement, not 5

[ppr (Peter Preuss)]

@Sahil_Garg
taking the first 5 rows can be done with following statement:
YourDataTableVar.AsEnumerable.Take(5).CopyToDataTable

[Sahil_Garg]

copyToDatatable will be the new one right ?

[ppr (Peter Preuss)]

@Sahil_Garg
Yes
have a look below (Had used two as the DataTable has less rows, justg for demo purpose)

[Sahil_Garg]

It works bro Thanks for your response