allow sorting in each column of gridview

Question

Hi,

i have one grid with the 4 fields as given below

[EC No.] [Firm Name] [Due Amt.] [Due Days.]

i want to allow sorting in each column in descending order...n want default sorting from Due Days fields....

plz provide me code with example

thank you..

Jitendra Tiwari · Answer

Hello friend, try this attachment. i things u fine ur solution. if u like answer please mark this Thanks.

Vasanth · Answer

Please check this code , based on your requirements in sorting just using orderby in SQL Query. asp : GridView ID ="GridView1" runat ="server" AllowSorting ="True" AutoGenerateColumns ="False" DataSourceID ="AccessDataSource1"> Columns > asp : BoundField DataField ="EC_No" HeaderText ="EC_No" SortExpression ="EC_No" /> asp : BoundField DataField ="Firm_Name" HeaderText ="Firm_Name" SortExpression ="Firm_Name" /> asp : BoundField DataField ="Due_Amt" HeaderText ="Due_Amt" SortExpression ="Due_Amt" /> asp : BoundField DataField ="Due_Days" HeaderText ="Due_Days" SortExpression ="Due_Days" /> Columns > asp : GridView > asp : AccessDataSource ID ="AccessDataSource1" runat ="server" DataFile ="~/SortingDB.mdb" SelectCommand ="SELECT [EC_No], [Firm_Name], [Due_Amt], [Due_Days] FROM [Sample_Table] ORDER BY Due_Days,Due_Amt,Firm_Name,EC_No"> asp : AccessDataSource > Please check the sample.mdb and run this code. Please mark as answer if its helps ou.