导出excel 代码1
string sql = "select MEMBER_NAME,MEMBER_SEX,MEMBER_MOBI from MEMBER where C_ID=1";
string connstr = "server=ZKX_SERVER1;database=ZKXCTI;User Id=sa;pwd=sa;";
DataSet ds=new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql,connstr);
da.Fill(ds,"MEMBER");
DataTable dt=ds.Tables["MEMBER"];
StringWriter sw=new StringWriter();
// 设置列名
sw.WriteLine("姓名\t性别\t电话");
foreach(DataRow dr in dt.Rows)
{
// 按列名写入数据字段
sw.WriteLine(dr["MEMBER_NAME"]+"\t"+dr["MEMBER_SEX"]+"\t"+dr["MEMBER_MOBI"]);
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
----------------
