Some doubts in DataGrid Control to Sort the Values ASP.NET?

Hai friends, I need to sort the datagrid control in asp.net page. when i click the column header it should be sorted and display. but one condition has to be applied. when i click the sort expression it should not go and sort from the database itself. this is must . how to do pa? anybody could help me to do?Some doubts in DataGrid Control to Sort the Values ASP.NET?
The following articles will certainly help you :








Optimized ASP.NET DataGrid Sorting %26gt;


http://www.codeproject.com/aspnet/Optimi鈥?/a>





Working with Data Grid:


http://samples.gotdotnet.com/quickstart/鈥?/a>Some doubts in DataGrid Control to Sort the Values ASP.NET?
thru oracle as back end u can made


select * from %26lt;tablename%26gt; orderby %26lt;as u wish%26gt;