大体代码如下,相关地方敬请自行修改:
//SqlDataAdapter mycmd = new SqlDataAdapter(sqlcmd,mycon); DataSet ds = new DataSet(); mycmd.Fill(ds,"mytable"); StringWriter sw=new StringWriter(); sw.WriteLine("姓名\t班级\t学号\t学科\t成绩\t阶段\t日期\tID"); foreach(DataRow dr in ds.Tables["mytable"].Rows) { sw.WriteLine(dr[0].ToString()+"\t"+dr[1].ToString()+"\t"+dr[2].ToString()+"\t"+dr[3].ToString()+"\t"+dr[4].ToString()+"\t"+dr[5].ToString()+"\t"+dr[6].ToString()+"\t"+dr[7].ToString()+"\t"); } sw.Close(); Response.AddHeader("Content-Disposition", "attachment; filename=MyWord.doc"); Response.ContentType = "application/ms-excel"; Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); Response.Write(sw); Response.End();
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18