How to reset Gridview Sort on buttonclick event

Check this

http://www.4guysfromrolla.com/articles/012308-1.aspx

http://www.codeproject.com/Articles/14437/Extending-GridView-by-allowing-Multiple-Selections

http://www.dreamincode.net/forums/topic/76101-gridview-sort-by-multiple-columns/

I want sort by default as per SQL Query 

if I do sorting on my Gridview table 

Example Name > Desc .. 

after again on button click it should display default sort as per SQL query means Name column should be in asc  order not on desc order 

but I am getting Name col as desc .. 

I want on every button click event sort should be as per sql query 

Thank you

Sandy

This means your sort order is not getting updated. Check the property whether it is passing correct values

No I have not set any property for Sort order now 

its sorting as per SQLDatasource 

On button click even my sql query sort order should work 

not the perviously sorted order 

If you are using SQL DataSource then you cannot control the binding via button click. If you need customized sorting then use DataTable or DataSet to bind GridView