>Is there a way to delete records from a table without reading through the table and checking each record and then calling dr.delete()?
>
>I'm using datasets,tableadapters and bindingsources in an app where I give the user a combo box populated with unique dates which I have gotten from a transaction table. I want the user to be able to pick a date and then delete all records from the transaction table that have a matching date.
>
>So far I only see that I can loop through the data and test each record and then delete it using the datarow delete(). Seems very inefficient.
>
>Anyone have a better way?
>
>Thanks
You can use Select() to get all those rows into a DataRow[] and delete in a loop. Or you might directly execute a delete command on backend.
Re: How to delete a group of rows from a datatable? Thread #
1274269 Message #
1274432Cetin