sort grid

[IGotYourDotNet]

I need to make my grids sortable when the user clicks a header (I know how to
do use using SQL) but how make the grids columns sorttable when the grids are
populated via a Oracle Stored Procedure?

My grids(9 grids) have 8 columns and all but 2 columns must be sorttable.

can this even be done if so any examples on how to do it?

[Laiju Skaria]

U can do that by setting the AllowSorting Property of the grid to True. And
then attach the appropriate handler to the SortCommand Event.

cheers,
Laiju

"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message
news:84**********************************@microsof t.com...

I need to make my grids sortable when the user clicks a header (I know how to do use using SQL) but how make the grids columns sorttable when the grids are populated via a Oracle Stored Procedure?

My grids(9 grids) have 8 columns and all but 2 columns must be sorttable.

can this even be done if so any examples on how to do it?

[IGotYourDotNet]

but in using Srored procdures how would it work and do i have to a call a new
routine to bind the grid again?
"Laiju Skaria" wrote:

U can do that by setting the AllowSorting Property of the grid to True. And
then attach the appropriate handler to the SortCommand Event.

cheers,
Laiju

"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message
news:84**********************************@microsof t.com...

I need to make my grids sortable when the user clicks a header (I know how

to

do use using SQL) but how make the grids columns sorttable when the grids

are

populated via a Oracle Stored Procedure?

My grids(9 grids) have 8 columns and all but 2 columns must be sorttable.

can this even be done if so any examples on how to do it?

[Laiju Skaria]

u can use the same sp, pass the sortorder as a param and return the records
on the specified sort order..
"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message
news:EB**********************************@microsof t.com...

but in using Srored procdures how would it work and do i have to a call a new routine to bind the grid again?
"Laiju Skaria" wrote:

U can do that by setting the AllowSorting Property of the grid to True. And then attach the appropriate handler to the SortCommand Event.

cheers,
Laiju

"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message news:84**********************************@microsof t.com...

I need to make my grids sortable when the user clicks a header (I know how

to

do use using SQL) but how make the grids columns sorttable when the

grids are

populated via a Oracle Stored Procedure?

My grids(9 grids) have 8 columns and all but 2 columns must be

sorttable.
can this even be done if so any examples on how to do it?