<summary>
Export data to a CSV file
</summary>
<param name= "dtexporttable" > datatable</param> required for Export
<param name= "Diccolumnsinfo" > Exported column dictionary, key datable column, value needs to export column name </param>
<param name= "FilePath" > exported file path </param>
public static void Exportcsv (DataTable dtexporttable, dictionary<string, string> diccolumnsinfo,string FilePath)
{
List<string> notexist=new list<string> ();
if (dtexporttable!=null&&diccolumnsinfo!=null)
{
foreach (string key in Diccolumnsinfo.keys)
{
if (!dtexporttable.columns.contains (key))
{
Notexist.add (key);
}
}
}
foreach (string key in Notexist)
{
Diccolumnsinfo.remove (key);
}
for (int i=dtexporttable.columns.count-1;i>=0;i--)
{
String Colname=dtexporttable.columns[i]. ColumnName;
if (!diccolumnsinfo.containskey (colname))
{
DtExportTable.Columns.RemoveAt (i);
}
}
if (dtexporttable = = NULL | | DtExportTable.Columns.Count <= 0 | | DtExportTable.Rows.Count <= 0 | | diccolumnsinfo = null | | Diccolumnsinfo.count <= 0 | | String. IsNullOrEmpty (FilePath))
throw new Exception ("Export condition is not satisfied!") ");
StringBuilder sbresult=new StringBuilder ();
int colcount=dtexporttable.columns.count;
String header=string. Empty;
for (int i=0;i<colcount;i++)
{
if (String.IsNullOrEmpty (Header))
{
Header = Diccolumnsinfo[dtexporttable.columns[i]. ColumnName];
}
Else
{
Header + = "," + diccolumnsinfo[dtexporttable.columns[i]. ColumnName];
}
}
Sbresult.appendline (header);//Add Table header
foreach (DataRow Dr in Dtexporttable.rows)
{
String rowstring=string. Empty;
for (int i=0;i<colcount;i++)
{
if (String.IsNullOrEmpty (rowstring))
{
Rowstring=dr[i]. ToString ();
}
Else
{
rowstring+= "," +dr[i ". ToString ();
}
}
Sbresult.appendline (rowstring); Adding rows
}
File.writealltext (Filepath,sbresult.tostring ());
}
C # DataTable Export CSV algorithm