reading files

csharp beginner

I am stuck with a small problem. I need help here .... So, please help me if anybody having a solution for this.

I am having a no of csv files and each file is having two rows. Now what i want is, reading each file and writing the elements of each row from the csv files, into two fixed arrays.

The code i wrote is:

FolderBrowserDialog folder = new FolderBrowserDialog();

if (folder.ShowDialog() == DialogResult.OK)

{

string[] filesGot = Directory.GetFiles(folder.SelectedPath);

try

{

List listA = new List();

List listB = new List();

foreach (string fileRead in filesGot)

{

string[] datalines = File.ReadAllLines(fileRead);

foreach (string line in datalines)

{

string[] mycolumns = line.Split(',');

listA.Add(mycolumns[0]);

listB.Add(mycolumns[1]);

}

string[] firstlistA = listA.ToArray();

string[] firstlistB = listB.ToArray();

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

csharp beginner12y ago
Hey Farhan, thanks your codes were helpful to me. :)
csharp beginner12y ago
Thanks Anupam.... you got it right. Actually the codes are correct. I figured out my mistake. I was doing mistake somewhere else, and was thinking that i was making mistake somewhere in creating arrays. Sorry my mistake :)
Farhan Shariff12y ago
// Reading one CSV file

private void button1_Click(object sender, EventArgs e)
{

OpenFileDialog openFileDialog = new OpenFileDialog();
// To list only csv files, we need to add this filter
openFileDialog.Filter = "|*.csv";

DialogResult result = openFileDialog.ShowDialog();

if (result == DialogResult.OK)
{
tbCSVPath1.Text = openFileDialog.FileName;

}

table1 = GetDataTabletFromCSVFile(tbCSVPath1.Text);

//Read elements into Array
List firstlistA = new List();
// Classic version :-)
for( int a = 0 ; a < datatable1.Rows.Count ; a ++)
{
firstlistA.Add(table1.Rows[a]["Column Name"].ToString());
}

}

//Function to import csv file to Memory

private static DataTable GetDataTabletFromCSVFile(string csv_file_path)
{
DataTable table1 = new DataTable();

using (TextFieldParser csvReader = new TextFieldParser(csv_file_path))
{
csvReader.SetDelimiters(new string[] { "," });
csvReader.HasFieldsEnclosedInQuotes = true;
string[] colFields = csvReader.ReadFields();
foreach (string column in colFields)
{
DataColumn datecolumn1 = new DataColumn(column);
datecolumn1.AllowDBNull = true;
table1.Columns.Add(datecolumn1);
}
while (!csvReader.EndOfData)
{
string[] fieldData = csvReader.ReadFields();

//Making empty value as null
for (int i = 0; i < fieldData.Length; i++)
{
if (fieldData[i] == "")
{
fieldData[i] = null;
}
}
table1.Rows.Add(fieldData);

}

}

return table1;
}
Anupam Singh12y ago
Hmm.. Actually your code looks fine and I dont see any error in this code.
if you have your csv file like :

firststring,secondstring
thirdstring,fourthstring

then you are not going to face any issue using this code.

You might have any incorrect file if its not working for you.
csharp beginner12y ago
Actually the code is not to write csv file. What i want is to read each csv files which we choose, and then put data from each csv file into two arrays. Where array named 'firstlistA' will contain all the data of first row from all the csv files we read and array named 'firstlistB' will contain all the data of second row from all the csv files.
Anupam Singh12y ago
Where is the code for writing csv file ?