I have a grid view which is displaying the result set as follows

```
customer |2011 shipped qty|2011 sales price|2012 shipped qty|2012 sales price

    aa        1                     2.00              2                    5.50
    cc        2                     3.00              4                   6.25

```

and i am having two drop down lists as  

monthdropdown1 and quarterdropdown2

if user selects monthdropdown1 as jan, in the grid result it should show as 

```
customer|2011 shipped qty|2011 sales price| 2012 shipped qty| 2012 sales price|
          jan                 jan                 jan            jan

   aa     1                     2.00              2                    5.50
   cc     2                     3.00              4                   6.25

```

and also same as for quarter respectively

i just need to add the selected dropdowntext to the grid view header column 

Note: Here my grid column property is autogeneratedcolumn = true

please find me the solution whether we can add selected text to gridview column header or can add saperate header column for the selected text

I have tried with this code in `Rowdatabound event` and was not worked for me

```
if (e.Row.RowType == DataControlRowType.Header)
{
    GridViewRow HeaderRow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);
    TableCell HeaderCell2 = new TableCell();
    HeaderCell2.Text = (DropDownList1.SelectedItem.Text);
    HeaderCell2.ColumnSpan = 0;
    HeaderRow.Cells.Add(HeaderCell2);
    DataGrid1.Controls[0].Controls.AddAt(0, HeaderRow);
}

```

please find me any other solution if possible 

HTML

```
<asp:GridView ID="DataGrid1" Style="visibility: visible" runat="server" AlternatingRowStyle-BackColor="#E9EDF5"
                Font-Names="Arial" ForeColor="#09538A" Font-Size="12px" BackColor="#ffffff" BorderColor="DarkGray"
                Font-Bold="true" HeaderStyle-BackColor="#298DC7" EnableViewState="false" CellSpacing="20"
                CellPadding="10" ShowFooter="false" HeaderStyle-Font-Bold="true" AutoGenerateColumns="True"  OnRowDataBound="DataGrid1__RowDataBound">
                  <RowStyle HorizontalAlign="Right" Height="20px"/>
                    <alternatingrowstyle  Height="20px" BackColor="#E9EDF5"/>
<%--                OnRowCommand="DataGrid1__RowCommand" OnRowDataBound="DataGrid1__RowDataBound">--%>
                <HeaderStyle Font-Names="Arial;" CssClass="MyHeaderStyle" Font-Size="13px" ForeColor="White"
                    Font-Bold="True" Height="20" BackColor="#298DC7"></HeaderStyle>
  <AlternatingRowStyle BackColor="#E9EDF5" />
            </asp:GridView>

```