Enable sorting in GridView with dynamic HeaderText using C# and VB.Net in ASP.Net

Hi anvina,

You have to set the SortExpression and HeaderText in Page_Load event instead of RowDataBound event.

C#

protected void Page_Load(object sender, EventArgs e)
{
    GVWorkitems.Columns(1).SortExpression = "Title";
    GVWorkitems.Columns(1).HeaderText = "Title 3";
    if (!this.IsPostBack)
    {
        showwi();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    GVWorkitems.Columns(1).SortExpression = "Title"
    GVWorkitems.Columns(1).HeaderText = "Title 3"
    If Not Me.IsPostBack Then
        showwi()
    End If
End Sub

With RowDataBound event use below code.

C#

protected void GVWorkitems_RowDataBound(object sender, GridViewRowEventArgs e)
{
    GVWorkitems.Columns[1].SortExpression = "Title";
    if (e.Row.RowType == DataControlRowType.Header)
    {
        LinkButton lnkHeader = e.Row.Cells[1].Controls[0] as LinkButton;
        lnkHeader.Text = "Title 3";
    }
}

VB.Net

Protected Sub GVWorkitems_RowDataBound(sender As Object, e As GridViewRowEventArgs)
    GVWorkitems.Columns(1).SortExpression = "Title"
    If e.Row.RowType = DataControlRowType.Header Then
        Dim lnkHeader As LinkButton = TryCast(e.Row.Cells(1).Controls(0), LinkButton)
        lnkHeader.Text = "Title 3"
    End If
End Sub