Hi Shashikant,
Thanks for your help. I have already gone through that link. I have solved my problem by creating header and footer at Gridview Row created event.
In Gridview Properties I have set- ShowHeader="false" and ShowFooter="true".
Sharing you the working code which works for me.
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
GridViewRow HeaderRow = new GridViewRow(1, 0, DataControlRowType.Header, DataControlRowState.Insert);
TableCell HeaderCell2 = new TableCell();
HeaderCell2.Text = "Sr.No.";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Product";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Pack";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Sales Qty";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "FOC";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Phy. Samp. Qty";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Unit Rate";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Value (" + ViewState["currency"] + " )";
//HeaderCell2.Text = "Value";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Value in Lacs";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Shpt.Req.Dt.";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Instructions";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
HeaderCell2 = new TableCell();
HeaderCell2.Text = "Status";
HeaderCell2.Font.Bold = true;
HeaderRow.Cells.Add(HeaderCell2);
GridView1.Controls[0].Controls.AddAt(0, HeaderRow);
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "Total";
e.Row.Cells[0].Font.Bold = true;
e.Row.Cells[7].Font.Bold = true;
e.Row.Cells[8].Font.Bold = true;
}
}