dataset sort

[thomasp]

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

[m.posseth]

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