By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,603 Members | 975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,603 IT Pros & Developers. It's quick & easy.

dataset sort

P: n/a
I want to use two SQL statements:

Dim strSQLLCMR As String = "SELECT DTG, POO FROM LCMR WHERE (Confirmed =
true and Friendly = False) ORDER BY DTG"
Dim strSQLQ36 As String = "SELECT DTG, POO FROM Q36 WHERE (Confirmed = true
and Friendly = False) ORDER BY DTG"

to fill one table in a dataset. Then I want to sort that dataset by the
field DTG. Is this possible?

The reason for this is that I then want to loop through the table and
determine records that have a Date/Time group (DTG) within 5 minutes of each
other.

Any suggestions welcome.
Thanks,

Thomas

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
yes this is possible as the datatable object exposes a select method wich
exposes a sort property

regards

Michel Posseth [MCP]
<th*****@msala.net> wrote in message
news:42***********************@news.newsdemon.com. ..
I want to use two SQL statements:

Dim strSQLLCMR As String = "SELECT DTG, POO FROM LCMR WHERE (Confirmed =
true and Friendly = False) ORDER BY DTG"
Dim strSQLQ36 As String = "SELECT DTG, POO FROM Q36 WHERE (Confirmed =
true
and Friendly = False) ORDER BY DTG"

to fill one table in a dataset. Then I want to sort that dataset by the
field DTG. Is this possible?

The reason for this is that I then want to loop through the table and
determine records that have a Date/Time group (DTG) within 5 minutes of
each
other.

Any suggestions welcome.
Thanks,

Thomas

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.com<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.