Total Pageviews

5/07/2010

How to get Distinct Rows from DataSet / Datatable ?

Hello,

So many times we come across a situation where we require to have distinct rows from dataset or from data table on basis of particular field. I saw many people are writing separate function and looping through the datatable to avoid the duplicates, although they have binded data to Dataset.

The way is to simple in .net but many people are unaware of that.

please have look to following Few simple line which take care of avoiding duplicate Rows.



First option in ToTable is a boolean which indicates, you want distinct rows or not?

Second option in the ToTable is the column name based on which we have to select distinct rows.

thanks

bhavik

2 comments:

Anonymous said...

But am not getting Distinct rows... could you help me

Linda Thomas said...

This is a very useful information for every person who want to start a successful career in programming. So many times we come across a situation where we require to have distinct rows from dataset or from data table on basis of particular field. I saw many people are writing separate reviews on BuyEssayClub and looping through the datatable to avoid the duplicates, although they have binded data to Dataset.

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews