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();??? }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!