Loading

delete from Linq

Sanjay gautam

How to delete 100 record from data table using linq

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar7y ago
Accepted answer
Hi Sanju, below line is enough to delete 100 rows
dt= dt.AsEnumerable().Skip(100).CopyToDataTable();
Here is a sample application i have done for you.
DataTable dt = new DataTable();
dt.Columns.Add("Col1");
for (int i = 0; i < 120; i++)
{
        dt.Rows.Add("sd" + i);
}
dt= dt.AsEnumerable().Skip(100).CopyToDataTable();
Accept the answer if it is correct or helful, Thanks.
0
Menaka Priyadharshini B7y ago
LINQ is used for querying data. With LINQ you can select data which should be deleted, and then delete those data manually (e.g. in foreach loop or with ForEach list extension).
+1