Change header text of columns in a GridView

Question

I have a GridView which i programmatically bind using c# code. The problem is, the columns get their header texts directly from Database, which can look odd when presented on websites. So basically, i would like to modify the column header text, but programmatically. i have already tried the following,

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

and

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

does not seem to give me correct result.

Could you elaborate on "does not help"? Do you get an error? How are you binding data to the grid? — Malice, Oct 22 '12 at 14:13
why not change the column name using AS keyword while retrieving data from SQL? — Karthik, Oct 22 '12 at 14:15
basically im using, SqlDataAdapter DataSet --------- adapter.Fill(ds); testGV.DataSource = ds; testGV.DataBind(); --------- — Mana, Oct 22 '12 at 14:16
change it in the query or the stored procedure you use to get data — Karthik, Oct 22 '12 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, Feb 27 '16 at 21:28

Tim Schmelter · Accepted Answer · 2012-10-22T14:32:23.653

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 '12 at 14:32

answered Oct 22 '12 at 14:17

Tim Schmelter

450,073
74
686
939

is changing the column name using As keyword while retrieving from SQL a better option? am not sure if its recommended – Karthik Oct 22 '12 at 14:20
@TimSchmelter thank you i just wanted to make sure its a good way of doing it – Karthik Oct 22 '12 at 14:27
was wondering, how do i call the function protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) – Mana Oct 22 '12 at 14:28
Thanks. Helped me. – Akshay Jun 22 '16 at 09:55
GridViewRowEventArgs I get the error this name type of namespace is not knowing!!! how do I resolve it – AbdallahRizk Jun 27 '19 at 05:40
no actually Im using asp.net in SharePoint environment – AbdallahRizk Jun 27 '19 at 07:42

score 19 · Answer 2 · edited Dec 25 '15 at 00:31

19

I Think this Works:

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

edited Dec 25 '15 at 00:31

Tristan

3,301
8
22
27

answered Dec 24 '15 at 21:32

basim

231
2
3

1

Short and sweet. Good answer! – Eric K Apr 13 '17 at 18:33
best answer off all! – elle0087 Jun 24 '20 at 14:16
Which GridView event is that best placed in? – B. Clay Shannon-B. Crow Raven Oct 02 '20 at 00:01
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 Oct 02 '20 at 00:08
PreRender seems faster. – B. Clay Shannon-B. Crow Raven Oct 02 '20 at 00:14

score 4 · Answer 3 · answered Oct 22 '12 at 14:17

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....

score 2 · Answer 4 · answered Sep 12 '18 at 10:55

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";
            }
        }
    }
}

score 1 · Answer 5 · answered Feb 10 '14 at 15:57

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.

score 0 · Answer 6 · answered May 15 '19 at 07:30

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
        }
    }

Change header text of columns in a GridView

6 Answers6

Linked

Related