How to change header text of columns in a GridView via codebehind

Question

I have a GridView which I programmatically bind using a a SqlDataAdapter DataSet.

adapter.Fill(ds); 
testGV.DataSource = ds; 
testGV.DataBind();

The problem is that the columns get their header texts directly from the database, which can look odd when presented on websites.

I would like to modify the column header text programmatically. I have already tried the following,

testGV.Columns[0].HeaderText = "Date";

and

this.testGV.Columns[0].HeaderText = "Date";

but they do not seem to give me the correct result.

Could you elaborate on "does not help"? Do you get an error? How are you binding data to the grid? — Malice
– Malice, Commented Oct 22, 2012 at 14:13
why not change the column name using AS keyword while retrieving data from SQL? — Karthik
– Karthik, Commented Oct 22, 2012 at 14:15
change it in the query or the stored procedure you use to get data — Karthik
– Karthik, Commented Oct 22, 2012 at 14:18
If you're AllowSorting the gridview, use the Sorted() event to handle the suggestions below, otherwise putting it in RowDataBound() will not work — Fandango68
– Fandango68, Commented Feb 27, 2016 at 21:28

Tim Schmelter · Accepted Answer · 2012-10-22 14:32:23Z

55

You should do that in GridView's RowDataBound event which is triggered for every GridViewRow after it was databound.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        e.Row.Cells[0].Text = "Date";
    }
}

or you can set AutogenerateColumns to false and add the columns declaratively on aspx:

<asp:gridview id="GridView1" 
  onrowdatabound="GridView1_RowDataBound"
  autogeneratecolumns="False"
  emptydatatext="No data available." 
   runat="server">
    <Columns>
         <asp:BoundField DataField="DateField" HeaderText="Date" 
            SortExpression="DateField" />
    </Columns>
</asp:gridview>

edited Oct 22, 2012 at 14:32

answered Oct 22, 2012 at 14:17

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Karthik Over a year ago

is changing the column name using As keyword while retrieving from SQL a better option? am not sure if its recommended

Karthik Over a year ago

@TimSchmelter thank you i just wanted to make sure its a good way of doing it

Mana Over a year ago

was wondering, how do i call the function protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

AbdallahRizk Over a year ago

GridViewRowEventArgs I get the error this name type of namespace is not knowing!!! how do I resolve it

AbdallahRizk Over a year ago

no actually Im using asp.net in SharePoint environment

TylerH · Accepted Answer · 2025-03-25 13:21:33Z

19

This should work:

testGV.HeaderRow.Cells[0].Text="Date"

edited Mar 25 at 13:21

TylerH

21.3k84 gold badges84 silver badges122 bronze badges

answered Dec 24, 2015 at 21:32

basim

2312 silver badges3 bronze badges

3 Comments

B. Clay Shannon-B. Crow Raven Over a year ago

Which GridView event is that best placed in?

B. Clay Shannon-B. Crow Raven Over a year ago

It works for me in the DataBound event, but I don't know if that's the best place for it...it's slow...maybe that event gets called a gazillion times...

B. Clay Shannon-B. Crow Raven Over a year ago

PreRender seems faster.

Ram Singh · Accepted Answer · 2012-10-22 14:17:46Z

4

You can do it with gridview's datarow bound event. try the following sample of code:

protected void grv_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[0].Text = "TiTle";
}
}

For more details about the row databound event study Thsi....

answered Oct 22, 2012 at 14:17

Ram Singh

6,97235 gold badges107 silver badges172 bronze badges

Comments

Jitendra G2 · Accepted Answer · 2018-09-12 10:55:01Z

Better to find cells from gridview instead of static/fix index so it will not generate any problem whenever you will add/remove any columns on gridview.

ASPX:

<asp:GridView ID="GridView1" OnRowDataBound="GridView1_RowDataBound" >
    <Columns>
        <asp:BoundField HeaderText="Date" DataField="CreatedDate" />
    </Columns>
</asp:GridView>

CS:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        for (int i = 0; i < e.Row.Cells.Count; i++)
        {
            if (string.Compare(e.Row.Cells[i].Text, "Date", true) == 0)
            {
                e.Row.Cells[i].Text = "Created Date";
            }
        }
    }
}

Amir Md Amiruzzaman · Accepted Answer · 2014-02-10 15:57:13Z

1

On your asp.net page add the gridview

<asp:GridView ID="GridView1" onrowdatabound="GridView1_RowDataBound" >
</asp:GridView>

Create a method protected void method in your c# class called GridView1_RowDataBound

as

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        e.Row.Cells[0].Text = "HeaderText";
    }
}

Everything should be working fine.

answered Feb 10, 2014 at 15:57

Amir Md Amiruzzaman

2,07526 silver badges25 bronze badges

Comments

Code · Accepted Answer · 2019-05-15 07:30:19Z

0

protected void grdDis_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            #region Dynamically Show gridView header From data base
            getAllheaderName();/*To get all Allowences master headerName*/

            TextBox txt_Days = (TextBox)grdDis.HeaderRow.FindControl("txtDays");
            txt_Days.Text = hidMonthsDays.Value;
            #endregion
        }
    }

answered May 15, 2019 at 7:30

Code

7595 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to change header text of columns in a GridView via codebehind

6 Answers 6

5 Comments

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

5 Comments

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related