i had implemented a datagrid and load some information from the sql into it.
can i sort the row in the datagrid based on the one of the cells in the datagird?
let say in example the datagrid i had three column/cells. now can i sort the row based on the information of cell 2? when i click the header? the data in the cell 2 is executed based on data form the first sql query therefore it does not belong to the first query. currently the header i use is <asp:boundcolumn> but this only works for the first query once triggered data but not for the data in cell 2.
What should i do to sort the row in the datagrid based on the cell 2 data header?

please help me
thanks

are you using the standard asp:datagrid?

basically i am using the standard datagrid. any solution for my problem?

Paste your code here . You can achieve this using ItemDatabound event

Originally Posted by leolim

basically i am using the standard datagrid. any solution for my problem?