public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
private void Export(GridView gvUser, string Style, string FileType, string FileName)
{
Response.ClearContent();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());
Response.ContentType = FileType;
//page.Response.ContentType = "application/ms-excel";
Page.EnableViewState = false;
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
//turn off paging
gvUser.AllowPaging = false;
BindGrid(gvUser);
gvUser.RenderControl(hw);
Response.Write(Style);
Response.Write(sw.ToString());
//page.Response.Flush();
Response.End();
//turn the paging on again
gvUser.AllowPaging = true;
BindGrid(gvUser);
}
private void BindGrid(GridView gvUser)
{
DataSet ds = new DataSet();
ds = Session["myDataSet"] as DataSet;
gvUser.DataSource = ds;
gvUser.DataBind();
}
protected void gvMessageByGroup_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Attributes.Add("onmouseover", "currentcolor = this.style.backgroundColor;this.style.backgroundColor = '#cee5f8'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor =currentcolor;");
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[3].Attributes["class"] = "text";
}
}
protected void lbtnExportToExcel_Click(object sender, EventArgs e)
{
string strStyle = @"<style> .text { mso-number-format:/@; }</style>";
Export(gvMessageByGroup, strStyle, "application/ms-excel", "myExcel.xls");
}