Find duplicate rows in datatable

[steve]

Hi All

I need to detect duplicate rows in a datatable in VB net 2003 using MS
Access 2K

I can do it at database level with sql e.g
sql = "select membernumber from members group by membernumber having
count(membernumber) > 1"
dt = getdata(sql, "dupes") ' getdata is my sub routine which returns a
datatable

Can you do a similar thing querying an Ado.net Datatable?

i.e can you do advanced querying on a populated datatable?

Any tips appreciated

Regards

Steve

 

[Miha Markic [MVP C#]]

Hi steve,

Hi All

I need to detect duplicate rows in a datatable in VB net 2003 using MS
Access 2K

I can do it at database level with sql e.g
sql = "select membernumber from members group by membernumber having
count(membernumber) > 1"
dt = getdata(sql, "dupes") ' getdata is my sub routine which returns a
datatable

Can you do a similar thing querying an Ado.net Datatable?
No.


i.e can you do advanced querying on a populated datatable?

No. Well, depends on what advanced means to you.
There is DataTable.Select method (see DataColumn.Expression for supported
expressions).
There is also a commercial product that claims it can do sql queries on
dataset (search through this newsgroup - it is advertised from time to
time) - I have never tried it though.

 

[Cor Ligthert [MVP]]

Steve,

You cannot do it in one statement, however you can get what you want, have a
look to this sample about distinct

http://www.vb-tips.com/default.aspx?ID=dcad9a66-1366-4d61-8d32-1a580eb893b2

I hope this helps,

Cor