生成CSV:
public static void CreateCSVWithCommaByDataTableAndFilePath(DataTable dt, string FilePath)
{
try
{
//HttpContext.Current.Response.Clear();
//HttpContext.Current.Response.AddHeader(
// "content-disposition", string.Format("attachment; filename={0}", FileName));
//HttpContext.Current.Response.ContentType = "application/vnd.xls";
//HttpContext.Current.Response.ContentEncoding = System.Text.UTF8Encoding.Default;
FileStream fileStream = new FileStream(FilePath, FileMode.OpenOrCreate
);
StreamWriter sw = new StreamWriter(fileStream, System.Text.UTF8Encoding.Default);
string colHeaders = "", ls_item = "";
DataRow[] myRow = dt.Select();
int i = 0;
int cl = dt.Columns.Count;
for (i = 0; i < cl; i++)
{
if (i == (cl - 1))
{
colHeaders += dt.Columns[i].Caption.ToString() + "\r\n";
}
else
{
colHeaders += dt.Columns[i].Caption.ToString() + ",";
}
}
//HttpContext.Current.Response.Write(colHeaders);
sw.Write(colHeaders);
foreach (DataRow row in myRow)
{
for (i = 0; i < cl; i++)
{
if (i == (cl - 1))
{
ls_item += row[i].ToString() + "\r\n";
}
else
{
ls_item += row[i].ToString() + ",";
}
}
//HttpContext.Current.Response.Write(ls_item);
sw.Write(ls_item);
ls_item = "";
}
//HttpContext.Current.Response.End();
sw.Close();
fileStream.Close();
}
catch (Exception ex)
{
throw ex;
}
}