Repeater导入到excel 
Quotation
string sqlstr = " 1=1 ";
KD_YUEJIA kdyj = new KD_YUEJIA();
DataSet ds = kdyj.GetList(sqlstr);
this.Repeater1.DataSource = ds.Tables[0].DefaultView;
Repeater1.DataBind();
Response.ContentType = "application/vnd.ms-excel"; //关键的一行
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);
this.Repeater1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
searchOrders(sqlstr); //导出全部之后,还要分页 如果是分页导入的话,放到searchOrders中
KD_YUEJIA kdyj = new KD_YUEJIA();
DataSet ds = kdyj.GetList(sqlstr);
this.Repeater1.DataSource = ds.Tables[0].DefaultView;
Repeater1.DataBind();
Response.ContentType = "application/vnd.ms-excel"; //关键的一行
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);
this.Repeater1.RenderControl(hw);
Response.Write(sw.ToString());
Response.End();
searchOrders(sqlstr); //导出全部之后,还要分页 如果是分页导入的话,放到searchOrders中
就是直接把repeater中的数据导入进去,这个非常方便!
周未生活
asp.net的一些http变量
