protected void btnExpt_Click(object sender, EventArgs e) { DataTable dy = null; DataTable dz = null; IncentiveBusiness obj = new IncentiveBusiness(); string MemberId = txtEmployeecode.Text; DataTable dt = obj.GetArticalWisePoints(MemberId); if (dt.Rows.Count == 0) { GridView5.Visible = false; Panel1.Visible = false; // noField.Visible = true; // noField.Text = "No Records Found"; } else { ViewState["GridViewStudentlist"] = dt; } // DataTable dt = (DataTable)ViewState["GridViewStudentlist"]; string filename = "ArticalWisePointExcel.xls"; string headerTable = @"<table width='100%' border='1' align='center' class='TestCssStyle'><h4>Artical Wise Points Summary<br/></h4></table>"; HttpContext.Current.Response.Write(headerTable); System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); DataGrid dgGrid = new DataGrid(); dgGrid.DataSource = dt; dgGrid.DataBind(); dgGrid.ShowHeader = true; dgGrid.RenderControl(hw); Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ""); this.EnableViewState = false; Response.Write(tw.ToString()); Response.End(); }