I have written the code to read the csv file(which include 4 rows)
and the application is running sucessfully, while writting to the file it writes 2nd and 4th row to the file
I am not getting why its happing.
Can anyone help me for the same.
following is the code
public partial class Form1 : Form
private void Uploadbutton_Click(object sender, EventArgs e)
filenametextBox.Text = openFileDialog1.FileName;
private void save_to_DBbutton_Click(object sender, EventArgs e)
if (openFileDialog1.FileName == "")
MessageBox.Show("File Not Selected");
StreamReader sr = new StreamReader(openFileDialog1.FileName,Encoding.GetEncoding(1250));
SW = File.CreateText("D:\\CSV\\csv.txt");
string strline = "";
string str1 = "";
string _values = null;
while ((strline = sr.ReadLine()) != null)
strline = sr.ReadLine();
_values = strline.Split(';');
foreach (string str in _values)
str1 = str + ",";
str1 = str1.Trim(',');
MessageBox.Show("Sucessfully Retrieved and file has been created");
Me neither. Perhaps you could tell us what is happening?
on a side note, if this is a practice project, writing your own csv reader is fine. However, if this is 'real' code, I have had good experiences using Lumen CSV. Parsing CSV file is not as simple as splitting on commas. It is legal to include the separator within commas (among other edge cases), and your code doesn't handle that case. Your code is too simple to be a proper CSV parser.
where i can find the Lumen CSV and it should read all the data from csv file
I am not getting what is wrong with my code.
I am developeing a utility for my company which will read the csv file
Can any one help me for the same.
I guess my preference is to always make the read call from within the loop. This seems more logical to me, but dlarkin77's method may work as well.
You might consider listening to BigEd781's advice too: CSV parsing can be a real pain if you're supporting the whole standard. On the other hand, if you're just reading in a matrix of numbers separated by commas, your fast solution may be 'good enough'.
Hope that helps.
Last edited by BioPhysEngr; February 5th, 2011 at 12:40 AM.
Reason: forgot a code tag
All advice is offered in good faith only. You are ultimately responsible for effects of your programs and the integrity of the machines they run on.