Remove data row from the data table in c#

Question

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..

amol narkhede · Answer

You can use below dt.Select(Name='Ram').ToList().ForEach(r => r.Delete());

Catcher Wong · Answer

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 { 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 { Console.WriteLine(dt.Rows[i].Field string >(0) + - + dt.Rows[i].Field string >(1) + - + dt.Rows[i].Field int >(2)); } Console.Read(); } the result :

Midhun T P · Answer

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

Bikesh Srivastava · Answer

Why you don't want use loop. I think its not best practice.

Mangesh Gaherwar · Answer

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 Santhalingam · Answer

Mangesh same error repeating

Mangesh Gaherwar · Answer

dTable.Rows.Remove(dTable.AsEnumerable().Where(r => r.Field (name) == ram).FirstOrDefault())An do acceptchanges for datatable

Dinesh Santhalingam · Answer

Its remove the rows but the data table can't accept the changes.@ amol narkhede

Dinesh Santhalingam · Answer

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 Santhalingam · Answer

Yea@ Mangesh Gaherwar If name==Ram then delete the rows of Ram

Mangesh Gaherwar · Answer

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

Dinesh Santhalingam · Answer

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

Chetan Ranpariya · Answer

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.

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