Sorting in Gridview Asp.net C#

Question

5.00/5 (2 votes)

See more:

SQL-Server-2005

, +

Hi Frnds, This is Ranjith Rdy.

I have a gridview on my webform and finally loaded data into it.
Now i need to sort it when i click on the header columns in gridview.

I have five fields, I need to SORT it using Header columns.
and i gave Allow Sorting = TRUE

This is my code.

C#

 protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {      
        DataTable dtSortTable = GridView1.DataSource as DataTable;

        if (dtSortTable != null)
        {
            DataView dvSortedView = new DataView(dtSortTable);

            dvSortedView.Sort = e.SortExpression + "" + getSortDirectionString(e.SortDirection);
        
            GridView1.DataSource = dvSortedView;
            GridView1.DataBind();
        }
    }

private string getSortDirectionString(SortDirection sortDirection)
    {
        string newSortDirection = String.Empty;
        if(sortDirection== SortDirection.Ascending)
        {
            newSortDirection = "ASC";
        }
        else
        {
            newSortDirection = "DESC";
        }
        return newSortDirection;
}

This is my Above code...its unable to work out..
Please anyone can suggest me and steps for SORTING.

Thanks ,

Posted 29-Apr-12 23:39pm

Ranjith Reddy CSE

Updated 29-Mar-17 3:22am

Prasad_Kulkarni

v2

Add a Solution

Comments

kartheeee 23-Jul-12 14:23pm

hi, i am trying same code, but datatable always show null
how to solve?

protected void SortRecords(object sender, GridViewSortEventArgs e)
{
DataTable dt1 = GridView1.DataSource as DataTable;
if (dt1 != null)
{
DataView dv = new DataView(dt1);
if (e.SortDirection == SortDirection.Ascending)
{
dv.Sort = e.SortExpression + "" + "desc";
}
else
{
dv.Sort = e.SortExpression + " " + " asc";
}
GridView1.DataSource = dv;
GridView1.DataBind();
}

tks
kartheeee

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Prasad_Kulkarni · Answer 1 · 2012-04-29T23:44:00

Please refer following some good articles on CP. You will surely get some help from it.
Optimized Paging and Sorting using Object Data Source[^]
Gridview Sorting with Up and Down Icons, Paging[^]
GridView:Sorting & Paging Using Generics And Nullable Datatype Function Of C# GetValueOrDefault()[^]

Some other useful links:
Gridview Sorting Using C#[^]
Code to create Sorting for a GridView in ASP.net in Code Behind[^]
Sorting a GridView Bound to a Custom Data Object[^]
Sorting in Gridview[^]

_Amy · Answer 2 · 2012-12-23T19:52:00

It looks like you need to have

C#

var DataSource = from data in GridViewData
                    orderby data.Column1
                    select data;

Since the orderby clause takes a property name. The clause doesn't parse the string to determine what to order by like Dynamic Queryable does.

Or, in the case of sorting on multiple fields, I would use

C#

var DataSource = from data in GridViewData
                    select data;
switch(fieldToSortOn)
{
  case "Column1":
    DataSource = NewDataSource.OrderBy(x => x.Field1);
    break;
  case "Column2":
    DataSource = NewDataSource.OrderBy(x => x.Field2);
    break;

  ...
}
GridView1.DataSource = DataSource; 
GridView1.DataBind();

You can also try using Handle GridView.OnSorting() and create sorting expression dynamically using LINQ[^].

prasad546 · Answer 3 · 2012-12-23T19:15:00

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt=getdata();//here getdata() method returns data from database;
        Session["data"] = dt;
    }
}

protected void ComponentGridView_Sorting(object sender, GridViewSortEventArgs e)
{
    DataTable dataTable = Session["data"] as DataTable;

    if (dataTable != null)
    {
        DataView dataView = new DataView(dataTable);
        dataView.Sort = e.SortExpression + " " + ConvertSortDirection(e.SortDirection);

        ComponentGridView.DataSource = dataView;
        ComponentGridView.DataBind();
    }
}

private string ConvertSortDirection(SortDirection sortDirection)
{
    string newSortDirection = String.Empty;

    switch (sortDirection)
    {
        case SortDirection.Ascending:
            newSortDirection = "ASC";
            break;

        case SortDirection.Descending:
            newSortDirection = "DESC";
            break;
    }

    return newSortDirection;
}

Shafeequl · Answer 4 · 2013-06-13T22:58:00

Hope this may helps You...Dont forget to mark as Answer if this is the right one..k...

 protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable dtbl = new DataTable();
         dtbl = ;//here get the datatable from db
        if (ViewState["Sort Order"] == null)
        {
            dtbl.DefaultView.Sort = e.SortExpression+" DESC";
            GridView1.DataSource = dtbl;
            GridView1.DataBind();
            ViewState["Sort Order"] = "DESC";
        }
        else
        {
            dtbl.DefaultView.Sort = e.SortExpression + "" + " ASC";
            GridView1.DataSource = dtbl;
            GridView1.DataBind();
            ViewState["Sort Order"] = null;
        }
}

Happy Codding...

Sorting in Gridview Asp.net C#

4 solutions

Solution 1

Solution 4

Solution 3

Solution 5

Add your solution here

Preview 0