Sorting Particular column in Gridview

Ramco Ramco

I have below Gridview with AutoGenerateColumns = True. I want to sort on Date column


    <%--OnRowEditing="OnRowEditing" OnRowCancelingEdit="OnRowCancelingEdit" OnRowUpdating="OnRowUpdating" AutoGenerateEditButton="true"--%>

DataTable BookPlanningResult = sQLUtility.GeBookPlanningRecommendation(vRpl, BookCollection, StudentCollection).Tables[0];
if (BookPlanningResult != null)
{
    DataColumn Remarks = new DataColumn("Remarks", typeof(string));
    BookPlanningResult.Columns.Add(Remarks);
    DataColumn Dates = new DataColumn("Date", typeof(DateTime));
    BookPlanningResult.Columns.Add(Dates);

    grdPlanning.DataSource = BookPlanningResult;
    int lastColumnIndex = BookPlanningResult.Columns.Count - 1;

    grdPlanning.DataBind();
}

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana3y ago

To enable sorting on the "Date" column of your GridView, you need to set the SortExpression property of the column to "Date" and also set the AllowSorting property of the GridView to "true". You can do this in the grdPlanning_RowDataBound event handler after the GridView has been bound to the data source, like this:

protected void grdPlanning_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        // Find the "Date" column and set its SortExpression property
        int columnIndex = -1;
        foreach (DataControlField column in grdPlanning.Columns)
        {
            columnIndex++;
            if (column.HeaderText == "Date")
            {
                column.SortExpression = "Date";
                break;
            }
        }

        // Enable sorting on the GridView
        grdPlanning.AllowSorting = true;
    }
}

Thanks

Amit Mohanty3y ago
To sort the grid view on the Date column, you need to set the SortExpression property of the BoundField or TemplateField column that corresponds to the Date column.
```
    
        
        <%--Add other columns here--%>
    
```
0