Issue in reading CVS file in Silverlight

Question

Hi,

While reading CSV file, in each line first character is missing…. Here is the case..

CSV file data…

Reported Date	Name	Status
4/19/2011 18:52	INC000005134305	Closed
4/19/2011 18:48	INC000005134250	Closed
4/19/2011 18:11	INC000005134058	Closed

Code..

OpenFileDialog Prp_Opendialogue = new OpenFileDialog();

bool? lBlnFile = Prp_Opendialogue.ShowDialog();

if ((bool)lBlnFile)

{

FileInfo lObjFileInfo = Prp_Opendialogue.File;

}

StreamReader lObjStreamReader = new StreamReader(Prp_Opendialogue.File.OpenRead());

bool lBlnIsColumnRow = true;

while (lObjStreamReader.Read() != null)

{

string lStrLine = lObjStreamReader.ReadLine();

}

………….

Here in this lStrline, I am getting "/19/2011 18:52, INC000005134305, Closed", here you can see 4 is missing. How can I get this…

Any ideas please..

Sreenath

Sreenath G · Answer

When you call lObjStreamReader.Read() you read the first character. Don't make that call and your '4' won't be missing. Collapse | Copy Code StreamReader lObjStreamReader = new StreamReader(Prp_Opendialogue.File.OpenRead()); bool lBlnIsColumnRow = true ; string lStrLine; while ((lStrLine = lObjStreamReader.ReadLine()) != null) { // do something with lStrLine }

Sam Hobbs · Answer

Sreenath, see Loadin a CSV file into a DataGrid in Silverlight 4 Application ; I gave you the answer 4 days ago.

Sreenath G · Answer

for previos..plzz chek out http://www.codeproject.com/Questions/195066/Issue-in-CSV-loading-to-Silverlight-datagrid.aspx

Jaganathan Bantheswaran · Answer

Hi, Try to read CVS file in some other way or read other file and check it. Did you get the solution for Binding problem in Previous Silverlight query ? If yes please post the Answer.

Issue in reading CVS file in Silverlight

Answers (4)