Remove data row from the data table in c#

Dinesh Santhalingam

I have a Data Table named as dt .The Table contains the following.,

Name	bike name	Rate
Ram	A	20
Sri	B	10
dina	C	40
Ram	D	50
Sri	E	60
dina	F	70
Ram	S	80
Sri	Q	65
dina	L	70
Sonu	B	30

I want to remove the data row where name is Ram without using for loop .How to solve this ?help me..

13 Replies

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

amol narkhede9y ago
Accepted answer
You can use below,
dt.Select("Name='Ram'").ToList().ForEach(r => r.Delete());
Bikesh Srivastava9y ago
Why you don't want use loop.
I think its not best practice.
Catcher Wong9y ago
Hi dinesh,

you can try this !
class Program
    {
        static void Main(string[] args)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("Name",typeof(string));
            dt.Columns.Add("bike name", typeof(string));
            dt.Columns.Add("Rate", typeof(int));

            dt.Rows.Add("Ram", "A",20);
            dt.Rows.Add("Sri", "B", 10);
            dt.Rows.Add("dina", "C", 40);
            dt.Rows.Add("Ram", "D", 50);
            dt.Rows.Add("Sri", "E", 60);
            dt.Rows.Add("dina", "F", 70);
            dt.Rows.Add("Ram", "S", 80);
            dt.Rows.Add("Sri", "Q", 65);
            dt.Rows.Add("dina", "L", 70);
            dt.Rows.Add("Sonu", "B", 30);

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Console.WriteLine(dt.Rows[i].Field<string>(0) + "-" + dt.Rows[i].Field<string>(1) + "-" + dt.Rows[i].Field<int>(2));
            }

            dt.Select("Name='Ram'").ToList().ForEach(x=>x.Delete());
            dt.AcceptChanges();

            Console.WriteLine("=====After delete=====");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Console.WriteLine(dt.Rows[i].Field<string>(0) + "-" + dt.Rows[i].Field<string>(1) + "-" + dt.Rows[i].Field<int>(2));
            }
            Console.Read();
        }
the result :
Mangesh G9y ago
dTable.Rows.Remove(dTable.AsEnumerable().Where(r => r.Field("name") == "ram").FirstOrDefault())
dTable.AcceptChanges();

I was Having issue Posting things here

Hope this Helps U

Happy Coding !!!!
Dinesh Santhalingam9y ago
Mangesh same error repeating
Mangesh G9y ago
dTable.Rows.Remove(dTable.AsEnumerable().Where(r => r.Field("name") == "ram").FirstOrDefault())An do acceptchanges for datatable
Dinesh Santhalingam9y ago
Its remove the rows but the data table can't accept the changes.@
amol narkhede
Dinesh Santhalingam9y ago
1. dt.Rows.Remove(dt.AsEnumerable().Where(r => r.Field("Name")== "Ram").FirstOrDefault());
Its creating error @Mangesh. It said
Error 11 The type arguments for method 'System.Data.DataRowExtensions.Field(System.Data.DataRow, int)' cannot be inferred from the usage. Try specifying the type arguments explicitly.

Dinesh Santhalingam9y ago

Yea@

Mangesh Gaherwar

If name==Ram then delete the rows of Ram

Mangesh G9y ago

Dinesh you just want To Remove the rows with matching conditions right???

Midhun Tp9y ago

Hi,

Try below code -

DataView view = new DataView(dt);

view.RowFilter = ("Name<>'Ram'");

dt = view.ToTable();

Check below blog for knowing more about filtering.

http://midhuntp.blogspot.in/2017/01/filtering-dataset-based-on-column.html

Dinesh Santhalingam9y ago

Yea i understand.But some time i want to remove some row from data table dynamically thats why.,@

Chetan Ranpariya

Chetan Ranpariya9y ago

There is not way you can delete record from data table without looping thru rows.

Why don't you execute delete query directly on your database and reload the data table by running select query again? This would avoid looping and your have data updated in db and you reload the fresh data from the db.