Automatically Sort columns in GridView in ASP.Net

Yes you can sort from database

--Ascending
SELECT * FROM Customers
ORDER BY CustomerName ASC

--Descending
SELECT * FROM Customers
ORDER BY CustomerName DESC

Refer

http://asp-net-example.blogspot.in/2008/12/aspnet-gridview-sorting-example-how-to.html

yes you can achive this by simply using order by function

basically order by function has two properties 

1> asc

2>desc

sample

Select * from table1 order by colomn1

>> output returns accending order for colomn1

note by defalut the output returns in accending order no need  to mention asc here!!!

Select * from table1 order by colomn1 desc

>> output returns descending order for colomn1

cheers!!!!