sorting a grid column in asp.net 1.0

[sbv]

hi all

how can i sort my grid in 1.0 version? i am binding data on a click event.
and after that calling a function that alters the second column for values.
for ex. on 1st binding my grid is as follows

date status
-----------------------------
01/01/2008
01/02/2008
01/03/2008

and on function call, its

date status
-----------------------------
01/01/2008 P
01/02/2008 A
01/03/2008 P

these status i assigned manually. how can i sort this grid? so that i get it as...

date status
-----------------------------
01/02/2008 A
01/01/2008 P
01/03/2008 P

please help me.

I searched on google so much. but not getting solution. :(

plz help asap.

[ruhi]

You can use group by function in select query..

[sbv]

You can use group by function in select query..

yes. but i am assigning this "A" or "P" to cell only.
Its not in my database.
then how can i use group by ?

[ruhi]

How you are assigning values "A" or "P" directly to the cells will you plz tell in detail ?

[sbv]

How you are assigning values "A" or "P" directly to the cells will you plz tell in detail ?

just as.. on item bound checked for date value and assigned value.

dg.Items(i).Cells(1).Text = "P"

[ruhi]

check this link
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.sort.aspx
may be you get any hint..