Tuesday, 27 April 2010

Get distinct rows from DataTable

Found a method in data table object to get distinct rows:

DataTable dtTest = dtProduct.DefaultView.ToTable(true, new string[] { "PRODUCT", "NATURE", "TYPE" });

The first parameter has to be 'true' to get distinct rows, the second is the list of columns to return.

Cheers.
at

No comments:

Post a Comment

Note: only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)

Shorts - week 3, 2022

Post with links to what I am reading: 1. A very good post on different aspects of system architecture: https://lethain.com/introduction-to-a...

  • WPF: TreeView example (Part 1)
    Let’s look at another often used control in business applications – TreeView. It is a great control to visualise hierarchical data. Take an ...
  • How to check when a machine was restarted?
    Yesterday evening one of our test servers automatically rebooted. And today morning we found out that the last night’s test run was interrup...