Actually I am using the DISTINCT query, but my requirement is extracting
data from different databases (5 DBs totally), same table names ...
If there had been some rows which are duplicate, how to retrieve them,
thats my question.
I had used this response from "Doug Wilson".
===========================================================
C[#]
DataRow[] dr = myDataTable.Select("id = 4","Name DESC);
The Select method takes 2 params - the search criteria (string), and the
ordering criteria (string).
So, the above code will return an arraylist of datarows that have an id
value of 4, and order them by the column Name, descending.
=======================================================
If u know a better solution, pls let me know. Thanks
"Stephen
Russell" To: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
ate.com> Subject: RE: [AspNetAnyQuestionIsOk]
Unique Records in a DataSet
05/24/2004
11:48 PM
Please respond
to
AspNetAnyQuest
ionIsOk
[EMAIL PROTECTED] wrote:
> Hi All,
>
> Can anybody help me to find out the unique records in a DataSet
> quickly? May be by using some property setting or method calling? I
> know how to retreive unique records by using a loop.
>
Why not get them from the DB?
Select Distinct <column list>
from yourTable
Where yourCriterior
Stephen Russell
S.R. & Associates
Memphis, TN 38115
901.246-0159
Yahoo! Groups Sponsor
ADVERTISEMENT
(Embedded image moved to file: pic11478.gif)
(Embedded image moved to file: pic29358.gif)
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Disclaimer:
The contents of this e-mail are strictly confidential and may be
privileged. It represents solely the views of the author and is meant
only for the stated recipient/s.
Any unauthorized distribution is strictly prohibited. F J Benjamin
Group or its subsidiaries will not accept responsibility for any
damage caused by this e-mail or
attachment/s (if any), which have been checked for viruses.
Please visit our website http://www.fjbenjamin.com
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
