CSV parsing

T

Trips

Well-known member
Joined
Aug 7, 2010
Messages
2,788
<div style="background-color:white; color:black
<pre><span style="color:blue private <span style="color:blue void btnLoad1_Click(<span style="color:blue object sender, EventArgs e)



{



dataGridView2.DataSource = ParseCSVgetDT(<span style="color:#a31515 @"C:\08082010108SAM108SAM Corrected.csv");



dataGridView2.Refresh();



}



















<span style="color:blue private DataTable ParseCSVgetDT(<span style="color:blue string filePath)



{



<span style="color:blue string[] lines = File.ReadAllLines(filePath);



DataTable dt = <span style="color:blue new DataTable();



dt.Columns.Add(<span style="color:#a31515 "field0");



dt.Columns.Add(<span style="color:#a31515 "field1");



dt.Columns.Add(<span style="color:#a31515 "field2");



dt.Columns.Add(<span style="color:#a31515 "field3");



dt.Columns.Add(<span style="color:#a31515 "field4");



dt.Columns.Add(<span style="color:#a31515 "field5");



dt.Columns.Add(<span style="color:#a31515 "field6");



dt.Columns.Add(<span style="color:#a31515 "field7");



dt.Columns.Add(<span style="color:#a31515 "field8");



dt.Columns.Add(<span style="color:#a31515 "field9");



dt.Columns.Add(<span style="color:#a31515 "field10");



dt.Columns.Add(<span style="color:#a31515 "field11");



dt.Columns.Add(<span style="color:#a31515 "field12");



<span style="color:blue string[] fields = <span style="color:blue new <span style="color:blue string[13];



<span style="color:blue for (<span style="color:blue int rows = 0; rows < lines.Length; rows++)



{



CSVRecord records = <span style="color:blue new CSVRecord();



fields = lines[rows].Split(<span style="color:#a31515 ,);



<span style="color:blue if (fields.Length >= 12)



{



dt.Rows.Add( fields[0],



fields[1],



fields[2],



fields[3],



fields[4],



fields[5],



fields[6],



fields[7],



fields[8],



fields[9],



fields[10],



fields[11],



fields[12]



);



}







}



<span style="color:blue return dt;



}











<span style="color:blue public <span style="color:blue class CSVRecord



{



<span style="color:blue public <span style="color:blue string Field1;



<span style="color:blue public <span style="color:blue string Field2;



<span style="color:blue public <span style="color:blue string Field3;



<span style="color:blue public <span style="color:blue string Field4;



<span style="color:blue public <span style="color:blue string Field5;



<span style="color:blue public <span style="color:blue string Field6;



<span style="color:blue public <span style="color:blue string Field7;



<span style="color:blue public <span style="color:blue string Field8;



<span style="color:blue public <span style="color:blue string Field9;



<span style="color:blue public <span style="color:blue string Field10;



<span style="color:blue public <span style="color:blue string Field11;



<span style="color:blue public <span style="color:blue string Field12;



<span style="color:blue public <span style="color:blue string Field13;







}



[/code]

<pre>private void btnLoad1_Click(object sender, EventArgs e)



{



dataGridView2.DataSource = ParseCSVgetDT(@"C:\08082010108SAM108SAM Corrected.csv");



dataGridView2.Refresh();



}











private DataTable ParseCSVgetDT(string filePath)



{



string[] lines = File.ReadAllLines(filePath);



DataTable dt = new DataTable();



dt.Columns.Add("field0");



dt.Columns.Add("field1");



dt.Columns.Add("field2");



dt.Columns.Add("field3");



dt.Columns.Add("field4");



dt.Columns.Add("field5");



dt.Columns.Add("field6");



dt.Columns.Add("field7");



dt.Columns.Add("field8");



dt.Columns.Add("field9");



dt.Columns.Add("field10");



dt.Columns.Add("field11");



dt.Columns.Add("field12");



string[] fields = new string[13];



for (int rows = 0; rows < lines.Length; rows++)



{



CSVRecord records = new CSVRecord();



fields = lines[rows].Split(,);



if (fields.Length >= 12)



{



dt.Rows.Add( fields[0],



fields[1],



fields[2],



fields[3],



fields[4],



fields[5],



fields[6],



fields[7],



fields[8],



fields[9],



fields[10],



fields[11],



fields[12]



);



}







}



return dt;



}[/code]
I want to pick CSV file(s) from textbox. Please suggest what modification should in this code.
<div style="background-color:white; color:black
<pre><span style="color:blue private <span style="color:blue void button3_Click(<span style="color:blue object sender, EventArgs e)

{

DialogResult dr = openFileDialog1.ShowDialog();

<span style="color:blue if (dr == DialogResult.OK) textBox1.Text = openFileDialog1.FileName;

}



[/code]
<span style="color:#0000ff; font-size:x-small <span style="color:#0000ff; font-size:x-small <font size="2" color="#0000ff <font size="2" color="#0000ff
public
</font></font><font size="2" color="#0000ff

</font>
<span style="font-size:x-small <span style="color:#0000ff; font-size:x-small <span style="color:#0000ff; font-size:x-small string<span style="font-size:x-small filename

{
<font size="2

</font>

<span style="color:#0000ff; font-size:x-small <span style="color:#0000ff; font-size:x-small get
<span style="font-size:x-small
{
<font size="2

</font>
<span style="color:#0000ff; font-size:x-small <span style="color:#0000ff; font-size:x-small return<span style="font-size:x-small filename;

}
<font size="2

</font>

<span style="color:#0000ff; font-size:x-small <span style="color:#0000ff; font-size:x-small set
<span style="font-size:x-small
{
filename = textBox1.Text.ToString();
}
}




View the full article
 
Back
Top