|
-
Aug 22nd, 2007, 12:57 AM
#7
Thread Starter
Fanatic Member
Re: Help with Copying Datarow
...Maybe i'll just tell what im trying to achieve and maybe solicit for some advice, suggestions or comments...
I have one Datatable Table1 in my Datatset ds1. My Table1 has 3 columns, DocumentID, DocumentTitle and ExpirationDate, and there could be one or more rows and it is posible that the value of Column DocumentID of each rows could have the same value. Now, what im trying to achieve is to retrieve those rows for each DocumentID that has the latest ExpirationDate.
For example I have 5 rows in my Table1.
Table1:
1,Title1,2007-08-15
2,Title2,2007-08-13
1,Title1,2007-08-20
2,Titel2,2007-08-18
3,Title3,2007-08-25
Rows I only want to retrive:
1,Title1,2007-08-20
2,Titel2,2007-08-18
3,Title3,2007-08-25
Hope you get my problem.
Any Advice or Suggestion on how to achive this? Thanks in advance!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|