62,074
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
gxjgxjgxj 2007-07-09
- 打赏
- 举报
SqlConnection sqlCnn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["CnnStr"]);
SqlDataAdapter da=new SqlDataAdapter("select * from Users",sqlCnn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataTable dt = ds.Tables["table1"];
StringWriter sw=new StringWriter();
sw.WriteLine("自动编号\t姓名\t年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["UID"]+"\t"+dr["ULoginName"]+"\t"+dr["UPassword"]);
}
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();
你把数据库换成你要测试的就行了，当中可能有些命明改一下，有不清楚再交流
SqlDataAdapter da=new SqlDataAdapter("select * from Users",sqlCnn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
DataTable dt = ds.Tables["table1"];
StringWriter sw=new StringWriter();
sw.WriteLine("自动编号\t姓名\t年龄");
foreach(DataRow dr in dt.Rows)
{
sw.WriteLine(dr["UID"]+"\t"+dr["ULoginName"]+"\t"+dr["UPassword"]);
}
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();
你把数据库换成你要测试的就行了，当中可能有些命明改一下，有不清楚再交流
corder_li 2007-07-09
- 打赏
- 举报
如何把DataGrid里的指定列导出到excel?
我把问题没有说清楚吗
我把问题没有说清楚吗
corder_li 2007-07-09
- 打赏
- 举报
人呢?
