Hi,
I am writing a .csv file from application.
One column of the data contain zero padded numbers like 0021,0034 etc .
while writing the data into csv file , the numbers in the column is coming like 21 , 34 etc.
but I want the zero padding to be done.
Can anyone help me out to resolve this.?
CODE
DialogResult result;
SaveFileDialog objSaveDlg = new SaveFileDialog();
objSaveDlg.DefaultExt = ".csv";
objSaveDlg.OverwritePrompt = false;
result = objSaveDlg.ShowDialog();
if (result == DialogResult.OK)
{
GenerateCSV(objSaveDlg);
}
//-------------------GenerateCSV function -------------------
private void GenerateCSV( SavefileDialog objSaveDlg)
{
StreamWriter objStreamWriter = new StreamWriter(objSaveDlg.FileName);
DataTable dt = new DataTable();
dt = Filldata();
// write headers
string[] strArrColumns = new string[dt.Columns.Count];
// add column headers
for (int i = 0; i < dt.Columns.Count; i++)
{
strArrColumns = dt.Columns.ColumnName;
}
// write column headers
p_objStreamWriter.WriteLine(string.Join(",", strArrColumns));
// write data
string[] strArrRows = new string[dt.Columns.Count];
for (int j = 0; j < dt.Rows.Count; j++)
{
for (int k = 0; k < dt.Columns.Count; k++)
{
strArrRows[k] = " " + dt.Rows[j].ItemArray[k].ToString();
}
p_objStreamWriter.WriteLine(string.Join(",", strArrRows));
}
}
The data which is needed to write to csv is taking from data table dt.
| 