Click here to Skip to main content
13,357,552 members (48,434 online)
Rate this:
Please Sign up or sign in to vote.
See more: , +
Hello FRNDS, Please solve my problem facing with GRIDVIEW AND DROPDOWNLIST.

Am working on ASp.NET, c#, SqlSERVER2005.

On my webpage I have a Dropdownlist and a is dispalying perfectly from database. and this gridview contains PAGING ALSO(it contains Large number of records in GRIDVIEW) and the thing here is I need to sort the data based upon dropdown.

It should sort the complete column when selected from dropdownlist item.

In dropdownlist I used items as
1)sort by Employee name ---This must be sort alphabetwise A-Z
2)Sort by Hiring Date ---- Ascending order
3)Sort by Terminating Date --- Ascending Order.

When i select one item from Dropdownlist, that particular column must sort in Gridview.

Please help me, and solve this problem.

Posted 25-Jul-12 0:05am
aspnet_regiis 25-Jul-12 5:24am
what have you tried?
Sandeep Mewara 25-Jul-12 5:25am
And what is the issue here? What have you tried and are stuck with?

All you need is to sort the data based on a selection made in dropdown.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


Use this:
//Dropdownlist selected value changed event. This can be done on button click event also.
protected void DropDownList1_SelectIndexChanged(object sender, EventArgs e)        {
    gvSorting.Sort(DropDownList1.SelectedValue, SortDirection.Ascending);        

//Gridview sort command
protected void gvSorting_Sorting(object sender, GridViewSortEventArgs e)
    DataTable dtSortTable = gvSorting.DataSource as DataTable;
    if (dtSortTable != null)
        DataView dvSortedView = new DataView(dtSortTable);
        dvSortedView.Sort = e.SortExpression + " " + getSortDirectionString(e.SortDirection);
        gvSorting.DataSource = dvSortedView;

//Getting the sort direction
private static string getSortDirectionString(SortDirection sortDireciton)
    string newSortDirection = String.Empty;
    if (sortDireciton == SortDirection.Ascending)
        newSortDirection = "ASC";
        newSortDirection = "DESC";
    return newSortDirection;

All the best.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180111.1 | Last Updated 25 Jul 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100