65.9K
CodeProject is changing. Read more.
Home

Sorting Datagrid Columns

starIcon
emptyStarIcon
starIcon
emptyStarIconemptyStarIconemptyStarIcon

1.44/5 (6 votes)

Sep 18, 2007

1 min read

viewsIcon

21893

Code for sorting of data in datagrid according to columns headers

Navneet Sharma's Article for sorting of datagrid columns

Introduction

This article can be used to sort the data according to the columns of a datagrid using windows forms while developing from C# application in .Net 3.0 environments and functions/methods have been defined here. This code has been inherited and implemented by me after a survey on the web and contains the items useful for sorting datagrid in web applications.

Background

This article can be used to sort the data according to the columns of a datagrid using windows forms while developing from C# application in .Net 3.0 environments

Using the code

Copy this code to sort columns of a datagrid on a webform while developing from C# application in .Net 3.0 environments. Write down the event named datagrid1_Sorting() in your code by selecting the event from the event list.

Copy the below code and paste it into your application.

//


protected void dgXMLData_Sorting(object sender, GridViewSortEventArgs e)

{
    try
        {
            SortColumn = e.SortExpression; //Only if your sort expression is like your column name

            SortOrder = Convert.ToString(Session["SortOrder"]);
            DV = (DataView) datagrid1.DataSource;
            DV.Sort = SortColumn + " " + SortOrder;
            datagrid1.DataSource = DV;
            datagrid1.DataBind();
            Session["SortOrder"] = "ASC";
        }
        catch (Exception ex)
        {
            lblErr.Text = "" + ex.Message + "";
        }

}

Language Used: C#, ASP.Net

Platforms: Win XP Professional with SP 2, .Net 3.0

Points of Interest

Did you learn anything interesting/fun/annoying while writing the code? Did you do anything particularly clever or wild or zany?

History

This code has been implemented here for the first time in this post and if you want some modifications in it then mail me or suggest me the required improvements and I will do the required changes.

Please vote this article if this was useful to you.