please give a appropriate anwser if you can...

///

/// Gridview Name

/// File Name

public static void ExportToExcel(System.Web.UI.WebControls.GridView gv,string FileName)

{

HttpContext.Current.Response.ClearContent();

HttpContext.Current.Response.Buffer = true;

HttpContext.Current.Response.AddHeader("content-disposition",string.Format("attachment; filename={0}","" + FileName + ".xls"));

HttpContext.Current.Response.ContentType = "application/ms-excel";

System.IO.StringWriter sw = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

gv.AllowPaging = false;

gv.RenderControl(htw);

HttpContext.Current.Response.Write(sw.ToString());

HttpContext.Current.Response.End();

}

///

/// Gridview Name

/// File Name

public static void ExportToExcelNewFrm(System.Web.UI.WebControls.GridView gv,string FileName)

{

string style = @" ";

HttpContext.Current.Response.ClearContent();

// Create form tag

System.Web.UI.HtmlControls.HtmlForm form1 = new System.Web.UI.HtmlControls.HtmlForm();

gv.AllowPaging = false;

form1.Controls.Add(gv);

HttpContext.Current.Response.AddHeader("content-disposition",string.Format("attachment; filename={0}","" + FileName + ".xls"));

HttpContext.Current.Response.ContentType = "application/ms-excel";

System.IO.StringWriter sw = new System.IO.StringWriter();

System.IO.StringWriter header = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

gv.RenderControl(htw);

// Style is added dynamically

HttpContext.Current.Response.Write(style);

HttpContext.Current.Response.Write(sw.ToString());

HttpContext.Current.Response.End();

}