Issue in reading CVS file in Silverlight

Sreenath G

15y2.4kC#

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

4 Replies

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

Sam Hobbs15y ago
Sreenath, see Loadin a CSV file into a DataGrid in Silverlight 4 Application; I gave you the answer 4 days ago.
0
Sreenath G15y ago
for previos..plzz chek out http://www.codeproject.com/Questions/195066/Issue-in-CSV-loading-to-Silverlight-datagrid.aspx
0

Sreenath G15y ago

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        }

Jaganathan Bantheswaran15y ago
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.
0