一個Ajax.NET的查詢實例

DataGrid1.DataSource=DB("query",sSql);

DataGrid1.HeaderStyle.BackColor=System.Drawing.Color.Blue;

DataGrid1.Width=Unit.Percentage(100);

DataGrid1.HeaderStyle.ForeColor=System.Drawing.Color.White;

DataGrid1.DataBind();

System.Text.StringBuilder sb=new System.Text.StringBuilder();

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

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

this.DataGrid1.RenderControl(htw);

string s=sb.ToString().Replace(" 上午 12:00:00", "");

this.toExcel=s;

Session["txtExcel"]=s;

return s;

}

public void setToExcel()

{

//下面這行很重要，attachment 參數表示作為附件下載，您可以改成online在線打開

//filename=FileFlow.xls 指定輸出文件的名稱，注意其擴展名和指定文件類型相符，可以為：.doc .xls .txt .htm

Response.AppendHeader("Content-Disposition","attachment;filename=EOL_"+eformsn.Text+".xls");