Sort a datagrid without the help of SQL server

[Ed Chiu]

Hi,

Is there a way to sort a datagrid without the help of SQL server? I usually
use ADO.Net to get a dataset from SQL sever then bind it to datagrid. Now I
am asked to make datagrid support sorting, of course I can change my SQL
statements by adding order by clause for sorting purposes. But I would like
to know if there are other options.

TIA

[Yunus Emre ALPÖZEN]

Surely there is a simple way. Using DataView will overcome this issue.
DataTable's View property will give a valid DataView. DataView's Sort
expression works similar to SQL. It accepts an order by string. Simply you
can write "PKID ASC, UserID DESC, ActionDate ASC".

--
Thanks,
Yunus Emre ALPÖZEN
"Ed Chiu" <Ed****@discussions.microsoft.com> wrote in message
news:20**********************************@microsof t.com...

Hi,

Is there a way to sort a datagrid without the help of SQL server? I
usually
use ADO.Net to get a dataset from SQL sever then bind it to datagrid. Now
I
am asked to make datagrid support sorting, of course I can change my SQL
statements by adding order by clause for sorting purposes. But I would
like
to know if there are other options.

TIA

[Steve C. Orr [MVP, MCSD]]

Use a DataView.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Ed Chiu" <Ed****@discussions.microsoft.com> wrote in message
news:20**********************************@microsof t.com...

Hi,

Is there a way to sort a datagrid without the help of SQL server? I
usually
use ADO.Net to get a dataset from SQL sever then bind it to datagrid. Now
I
am asked to make datagrid support sorting, of course I can change my SQL
statements by adding order by clause for sorting purposes. But I would
like
to know if there are other options.

TIA

[Alex Homer]

http://www.daveandal.net/books/8900/...-datagrid.aspx

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:Oi**************@TK2MSFTNGP14.phx.gbl...

Use a DataView.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Ed Chiu" <Ed****@discussions.microsoft.com> wrote in message
news:20**********************************@microsof t.com...

Hi,

Is there a way to sort a datagrid without the help of SQL server? I
usually
use ADO.Net to get a dataset from SQL sever then bind it to datagrid. Now I
am asked to make datagrid support sorting, of course I can change my SQL
statements by adding order by clause for sorting purposes. But I would
like
to know if there are other options.

TIA

[Yener Türkeli]

Ýt is my opinion there is a simple way. You can Use DataView
DataTable's View property will give a valid DataView. DataView's Sort
Simply you
can write " ASC or DESC".
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Yener Türkeli]

Ýt is my opinion there is a simple way. You can Use DataView
DataTable's View property will give a valid DataView. DataView's Sort
Simply you
can write " ASC or DESC".

Yener Türkeli
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!