[ms3009]

Hi Every one,

I am using StreamReader to read my csv file.
My csv file contains very huge data, around 17200 line...

my probelm is, when i execute my application and try to read csv file, then my application screen becomes blank (Consumes memory).

I am using following code to read file...

using (StreamReader sr = new StreamReader(fileStream))  
//fileStream is my FileStream object...
// which i have initialized as
//fileStream = new FileStream(CSVFileName, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.None);
{
      String temp;
      while ((temp = sr.ReadLine()) != null)
      {
         if (l_strCSVData.Trim().ToString().Equals(""))
               l_strCSVData = temp;
         else
               l_strCSVData = l_strCSVData + '\n' + temp;
       }
}

*edit: Please use code tags in the future, thanks!


is there any way to make this reading process fast, so that my screen wont get blank???

This post has been edited by Martyr2: 09 April 2008 - 09:20 AM

[zakary]

No it is only as fast as the Computers processor will allow, what you can do is put that in a separate thread and maybe use a progress bar to show the user that your application is doing something.

[Martyr2]

zakary's advice is bang on... what you are seeing is not a consumption of memory, but consuming up your processors time (it doesn't have time to repaint the screen, it is processing your file). The remedy is exactly what zakary said, use a separate thread which will divide the CPU's time (of if you have a multicore, multiple processors they will process it) between painting the screen and reading the file. This will also allow you the ability to setup a progress bar to display the progress of the file reading to the user while they do other things.

For more information on threading, try a site like the one listed below which will show you how C# threading works and gives examples...

Threading in C# - Free E-book

Enjoy!

This post has been edited by Martyr2: 09 April 2008 - 09:25 AM