private static void ExportToCSV(System.Data.DataTable datatable, CSV.CSVWriter csvwriter)
{
foreach (System.Data.DataRow row in datatable.Rows)
{
csvwriter.WriteItems(row.ItemArray);
}
csvwriter.Close();
}
public static void SetDataCSVFromTable(System.Windows.Forms.IDataObject dataobject, System.Data.DataTable datatable)
{
var default_encoding = System.Text.Encoding.Default;
var out_memstream = new System.IO.MemoryStream();
var streamwriter = new System.IO.StreamWriter(out_memstream, default_encoding);
var csvwriter = new CSV.CSVWriter(streamwriter);
ExportToCSV(datatable, csvwriter);
var bytes = out_memstream.ToArray();
var in_memstream = new System.IO.MemoryStream(bytes);
dataobject.SetData(System.Windows.Forms.DataFormats.CommaSeparatedValue, in_memstream);
}
public static void SetDataCSVFromTable(System.Windows.Forms.IDataObject dataobject, System.Data.DataTable datatable)
{
var default_encoding = System.Text.Encoding.Default;
var out_memstream = new System.IO.MemoryStream();
var streamwriter = new System.IO.StreamWriter(out_memstream, default_encoding);
var csvwriter = new CSV.CSVWriter(streamwriter);
ExportToCSV(datatable, csvwriter);
var bytes = out_memstream.ToArray();
var in_memstream = new System.IO.MemoryStream(bytes);
dataobject.SetData(System.Windows.Forms.DataFormats.CommaSeparatedValue, in_memstream);
}
