在以下按鈕單擊事件中實現(xiàn):
PRivate void btnMIME_Click(object sender, System.EventArgs e)
{
BindData();
Response.ContentType = "application/vnd.ms-Excel";
Response.AddHeader("Content-Disposition", "inline;filename="
+ HttpUtility.UrlEncode("下載文件.xls",Encoding.UTF8 ) );
//如果輸出為Word,修改為以下代碼
//Response.ContentType = "application/ms-word"
//Response.AddHeader("Content-Disposition", "inline;filename=test.doc")
StringBuilder sb=new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append("<html><body>");
dgShow.RenderControl(hw);
sb.Append("</body></html>");
Response.Write(sb.ToString());
Response.End();
}
注:1.若DataGrid中有按鈕列,則在導(dǎo)出前應(yīng)先將其隱藏.
2.若DataGrid有分頁,而又要打印所有數(shù)據(jù)的話就應(yīng)先取消分頁.
http://pyt5208.VEVb.com/archive/2006/07/10/447048.html
新聞熱點
疑難解答