DataTable searchs

[Moon Boy]

Hi, how i search for repeated items in a DataTable? Example: I have the Column Name and Email. I want to delete every Name and Email repeateds. Thanks.

[TigerNinja_]

For better programming practices use a UniqueConstraint on your DataTable. To learn more about constraints and data integrity see this msdn article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaddingconstraintstodataset.asp[^] HTH

R.Bischoff

Denn Gott hat die Menschen so sehr geliebt, daß er seinen einzigen Sohn für sie hergab. Jeder, der an ihn glaubt, wird nicht verlorengehen, sondern das ewige Leben haben

[Heath Stewart]

See the DataTable.Select command. It uses the same expressions as DataColumn.Expression. You could use this to get a DataRow[] array and then remove each of those array members from the DataTable. Another way would be to sort the DataTable and iterate - not enumerate, which is what foreach does - through it keeping track of the last DataRow and comparing it with the current DataRow. If they contain the same data, remove the current DataRow (which is why you don't enumerate - changing a collection that you're enumerating throws an exception). Don't forget to decrement your index for the for loop since it will be incremented with the next iteration (you want to keep the index the same since you just removed a DataRow).

Microsoft MVP, Visual C# My Articles