源码:
private static string ConverDataSetCSVCross(DataSet ds, string tableName, bool containColumName, int[] ColumSite)
{
//首先判断数据集中是否包含指定的表
if (ds == null || !ds.Tables.Contains(tableName))
{
return "";
}
string csvStr = "";
//下面写出数据
DataTable tb = ds.Tables[tableName];
//写出数据
foreach (int site in ColumSite)
{
csvStr = csvStr + tb.Columns[site].ColumnName + ",";//加上字段名和,
foreach (DataRow row in tb.Rows)
{
csvStr += "\"" + row[site].ToString() + "\"" + ",";
}
csvStr = csvStr.Remove(csvStr.LastIndexOf(","), 1);
csvStr += "\r\n";
}
return csvStr;
}
引用:
int[] intArray = {0,4,5 };//创建数组
ExportCSV.Export2CSV(DsRyBLByMajor, "Table1", false, strPath + "Prg\\CSV\\major_gender.csv", "1", intArray);