reading a stream from all the lines of a file

vaidyapragati · May 3rd, 2007, 04:16 AM

Hi, i want to read a data from a pipe separated file, the stream should read only upto first pipe separator n after that it should read data from second line in the same manner.
every time the data which is read is used to retrive some information from the database n it should happen till the file is completely read.

DZukiewicz · May 3rd, 2007, 07:49 AM

Well, its not fun giving the game away, but heres a start:

Firstly, you could read the file in as lines individually:

Code:

string[] lines = File.ReadAllLines(filename);

ArrayList extractedData = new ArrayList();

foreach(string line in lines)
{
     string extract = string.Empty;
     int position = line.IndexOf("|");
 
     if(position > -1)
          extract = line.Substring(0,position);

     extractedData.Add(extract);
}

string[] extracts = new string[extractedData.Length];
Array.Copy(extractedData,extracts,0,extractedData.Length);

//Do your database bits here.

Hope this helps.

Regards,

Dominic

vaidyapragati · May 10th, 2007, 01:44 AM

it is giving an error, System.Collections.Arraylist() does not contain defination for "length"

vaidyapragati · May 10th, 2007, 02:33 AM

just hv a look d way i tried is:

FileStream fs = new FileStream("C:\\data.lst", FileMode.Open, FileAccess.Read);
StreamReader reader = new StreamReader(fs);
string str;
str = reader.ReadLine().ToString();
while (str =reader .ReadLine ()!=null )

          {
                        String[] collection = str.Split('|');
                        string empid = collection[0];
                        Console.Write(empid);

and here database connection

bt in this also it's givin an error inwhile loop that, cannot convert bool to string and string to bool