Issue in reading CVS file in Silverlight

Question

0.00/5 (No votes)

See more:

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

Posted 16-May-11 20:34pm

Sreenath Gv

Updated 16-May-11 20:44pm

TweakBird

v2

Add a Solution

Comments

Sandeep Mewara 17-May-11 2:44am

You are not new here, yet you dont format your code part using PRE tags. Please do so from next time.

Sreenath Gv 17-May-11 2:46am

sure...

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mark Salsbery · Accepted Answer · 2011-05-16T21:01:00

Solution 1

When you call lObjStreamReader.Read() you read the first character. Don't make that call and your '4' won't be missing.

StreamReader lObjStreamReader = new StreamReader(Prp_Opendialogue.File.OpenRead());
bool lBlnIsColumnRow = true;
string lStrLine;
while ((lStrLine = lObjStreamReader.ReadLine()) != null)
{
    // do something with lStrLine
}

Posted 16-May-11 21:01pm

Mark Salsbery

Comments

Sreenath Gv 17-May-11 4:20am

thanks mark.

adityajha 10-Jul-12 2:51am

Thanks Mark.

Sam Hobbs · Accepted Answer · 2011-05-17T13:53:00

Solution 2

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

Posted 17-May-11 13:53pm

Sam Hobbs

Issue in reading CVS file in Silverlight

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Issue in reading CVS file in Silverlight

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us