sqlserver匯出為EXcel--CSV格式

標籤：excel   row   datarow   add   cat   content   exce   writer   for   

 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格式