首页 > 代码库 > sqlserver导出为EXcel--CSV格式
sqlserver导出为EXcel--CSV格式
DataTable dt = Connect.BindTable(" SELECT 名称,地址,当前日期 FROM table GROUP BY 名称,地址,当前日期 order by 名称,地址,当前日期 desc ");
Export(dt);
/*exel文件导入函数*/
private void Export(System.Data.DataTable tab)
{
StringWriter sw = new StringWriter();
sw.WriteLine("名称,地址,当前日期");
foreach (DataRow dr in tab.Rows)
{
sw.WriteLine(dr["名称"] + "," + dr["地址"] + "," + dr["当前日期"] );
}
sw.Close();
Response.AddHeader("Content-Disposition", "attachment; filename=test.csv");
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}
sqlserver导出为EXcel--CSV格式