re: Exporting Dataset as CSV

Steve — Thu, 01 Oct 2009 12:31:45 GMT

Here's an alternative that returns the CSV as a string:

public static string ConvertDataSetToCSV(DataSet ds)

{

const string LC_COMMA = ",";

const string LC_DBLQUOTE = "\"";

const string LC_DBLQUOTE_ESC = "\"\"";

StringBuilder csv = new StringBuilder();

foreach (DataTable tbl in ds.Tables)

{

// Append the table's column headers.

foreach (DataColumn col in tbl.Columns)

{

csv.Append(LC_DBLQUOTE + col.ColumnName + LC_DBLQUOTE + LC_COMMA);

}

csv.Length -= 1;

csv.Append(Environment.NewLine);

// Append the table's data.

foreach (DataRow row in tbl.Rows)

{

foreach (object val in row.ItemArray)

{

csv.Append(LC_DBLQUOTE + val.ToString().Replace(LC_DBLQUOTE, LC_DBLQUOTE_ESC)

+ LC_DBLQUOTE + LC_COMMA);

}

csv.Length -= 1;

csv.Append(Environment.NewLine);

}

// Add an empty line between this and the next table.

csv.Append(Environment.NewLine);

}

return csv.ToString();

}

samreen — Thu, 20 Nov 2008 11:10:28 GMT

i like it n want to use it