Working with datatable.

[Jensen bredal]

I have a DataTabel object filled with table data from a database.

The table contains rows that have the same data in a particular column.
How can i make a new copy of the datatable removing the repeating rows?

Many thanks in advance
JB

[Dmitriy Lapshin [C# / .NET MVP]]

Hi Jensen,

Create a DataView for the original DataTable sorted by that column. Create a
new DataTable you'll be inserting rows to. Start from the first DataView's
row, adding a new row to the destination table with all the data from the
source row. Then skip all rows having the same value in the column. Once the
value in the column changes, add this row and again skip further rows having
the same value. Do so until you've processed all rows in the view.

This is a off-the-top-of-my-head solution, I can't remember whether
DataTable's Select method supports the DISTINCT feature.

--
Sincerely,
Dmitriy Lapshin [C# / .NET MVP]
Bring the power of unit testing to the VS .NET IDE today!
http://www.x-unity.net/teststudio.aspx

"Jensen bredal" <je************@yahoo.com> wrote in message
news:eq**************@TK2MSFTNGP09.phx.gbl...

I have a DataTabel object filled with table data from a database.

The table contains rows that have the same data in a particular column.
How can i make a new copy of the datatable removing the repeating rows?

Many thanks in advance
JB

[Mehdi]

On Thu, 24 Feb 2005 12:33:11 +0100, Jensen bredal wrote:

I have a DataTabel object filled with table data from a database.

The table contains rows that have the same data in a particular column.
How can i make a new copy of the datatable removing the repeating rows?

This article gives you a method to do exactly what you want:
http://support.microsoft.com/default...b;en-us;326176

[Jensen bredal]

great ,

How could this be done in an sql statement if i could directly acces the
source table?

"Dmitriy Lapshin [C# / .NET MVP]" <x-****@no-spam-please.hotpop.com> wrote
in message news:u8*************@TK2MSFTNGP10.phx.gbl...

Hi Jensen,

Create a DataView for the original DataTable sorted by that column. Create
a new DataTable you'll be inserting rows to. Start from the first
DataView's row, adding a new row to the destination table with all the
data from the source row. Then skip all rows having the same value in the
column. Once the value in the column changes, add this row and again skip
further rows having the same value. Do so until you've processed all rows
in the view.

This is a off-the-top-of-my-head solution, I can't remember whether
DataTable's Select method supports the DISTINCT feature.

--
Sincerely,
Dmitriy Lapshin [C# / .NET MVP]
Bring the power of unit testing to the VS .NET IDE today!
http://www.x-unity.net/teststudio.aspx

"Jensen bredal" <je************@yahoo.com> wrote in message
news:eq**************@TK2MSFTNGP09.phx.gbl...

I have a DataTabel object filled with table data from a database.

The table contains rows that have the same data in a particular column.
How can i make a new copy of the datatable removing the repeating rows?

Many thanks in advance
JB

[Jensen bredal]

Great article.

Many thanks...

JB
"Mehdi" <vi****@REMOVEME.gmail.com> wrote in message
news:17*****************************@40tude.net...

On Thu, 24 Feb 2005 12:33:11 +0100, Jensen bredal wrote:

I have a DataTabel object filled with table data from a database.

The table contains rows that have the same data in a particular column.
How can i make a new copy of the datatable removing the repeating rows?

This article gives you a method to do exactly what you want:
http://support.microsoft.com/default...b;en-us;326176

[Cor Ligthert]

Jensen,

How could this be done in an sql statement if i could directly acces the
source table?

Almost exactly as Dimitry says using the Select Distinct.

The Net system.data namespace does not support a Distinct, the method that
Mehdi shows and Dimitry suggest in this thread is in my opinion as well the
best method for is. (Be aware that the showed method does only move one
field, you can of course do more fields and than count)

I hope this helps

Cor