Adding Column(s) to a a CSV using datagrid

fileContent has been taken from the previous code, this contain the content of the file. I cast the Datagrid in the DataTable.
dt.Columns.Count counts the column from the grid and add another column in it.

private DataTable addColumn(string fileContent)
{

DataTable dt = (DataTable)gvData.DataSource;
int iColCount = dt.Columns.Count;
dt.Columns.Add("Column" + (iColCount + 1).ToString());
return dt;
}
now this is the button btnAddColumn_Click which add the columns, will call the method addColumn and will add the column in the existing grid

private void btnAddColumn_Click(object sender, EventArgs e)
{
string fileContent = this.readFile(openFileDialog1.FileName);

DataTable dt = this.addColumn(fileContent);
gvData.DataSource = dt;
}

I hope that will be solve your problem.. please let me know if still you feel any problem....

Export Datagrid in CSV file in C#

Previously, I wrote a code for Importing any CSV file into a Datagrid, now here is the code for exporting the Datagrid into the CSV file. You can load the CSV file by the code in the previous post, then that grid can be exported back to the CSV file with different name.. Here is the code for it.

This is for saving the CSV file on the particular location

SaveFileDialog sfd = new SaveFileDialog();
String stringFile = string.Empty;
if (sfd.ShowDialog() == DialogResult.OK)
{
stringFile = sf.FileName;
}
else
{
return;
}
StreamWriter streamWriter= new StreamWriter(stringFile, true);

Here I initialized datatable n merge it with the datagrid.
DataTable dt = new DataTable();
dt.Merge((DataTable)gvData.DataSource); gvData is the DataGrid name

For Columns, write function will write the columns after counting.

int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
streamWriter.Write(dt.Columns[i]);
if (i < iColCount - 1)
{
streamWriter.Write(",");
}
}
streamWriter.Write(streamWriter.NewLine);

Now write all the rows.
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < iColCount; i++)
{
if (!Convert.IsDBNull(dr[i]))
{
streamWriter.Write(dr[i].ToString());
}
if (i < iColCount - 1)
{
streamWriter.Write(",");
}
}
streamWriter.Write(streamWriter.NewLine);
}
streamWriter.Close();

Feel free to ask questions and reports problem in the C# code

Importing CSV file in a Datagrid in C#

Here is the code for Importing a csv file in the Datagrid.

There are 2 helper methods 'readFile' and 'generateDataTable'

readFile opens the csv and returns its contents.

private string readFile(string filePath)
{

StreamReader streamReader = new StreamReader(filePath);
return streamReader.ReadToEnd();

}
generateDataTableFromCSV generates and returns a DataTable for the provided comma seperated string.

private DataTable generateDataTableFromCSV(string fileContent)
{

DataTable dt = new DataTable();
string[] row = fileContent.Split("\r\n".ToCharArray());

string rowstr = row[0];

string[] col = rowstr.Split(',');
int colCount = 1;
foreach (string colstr in col)
{
dt.Columns.Add(new DataColumn("Column" + colCount));
colCount++;
}

dt.AcceptChanges();
return dt;
}

Here is the code on button click event handler that reads the csv file, and displays it in a datagrid.

private void btnLoad_Click(object sender, EventArgs e)
{
string fileContent = this.readFile(openFileDialog1.FileName);

DataTable dt = this.generateDataTableFromCSV(fileContent);

string[] row = fileContent.Split("\r\n".ToCharArray());
foreach(string rowstr in row)
{
DataRow myRow = dt.NewRow();
int colCount = 0;
string [] col = rowstr.Split(',');

foreach (string colstr in col)
{
myRow[colCount] = colstr;
colCount++;
}

dt.Rows.Add(myRow);
}

gvData.DataSource = dt;

}


For StreamReader we need to use the System.IO;
using System.IO;

here is a screenshot of the form


Feel free to ask me questions and report problems in the C# code.