Read row from a text file and save to a string

[notSo smartGuy]

I am trying to read from a file and save rows to a string or array Im not sure which would be more efficient.

string[] array = new string roomNumber[30];
string[] testScore;

I have the test file set up the following with random values;

studentID, classroomNumber (1-30), testScore (1-100);

SID001, 1, 90
SID002, 1, 88
SID003, 1, 99
SID004, 2, 78
SID005, 2, 100
SID006, 2, 98
ETC, to room number 30

I am trying to store the second row to string[] roomNumber; and third row to string[] testScore. Then get the total score for each classroomNumber 1, 2, 3, etc as well as the average for each classroomNumber. I have tried many different ways but not sure how to store seperate rows to a string then call it and use it when needed. Thank you for the help.

[thines01]

I would suggest using a List<string> to store your rows.
You could also create a CLASS to hold your rows and store the rows in a List<CLASS> or a Dictionary<string, CLASS> where the key to the dictionary is the student ID.

If you're into creating classes, it will make keeping up with the scores to make an average easier.

[notSo smartGuy]

static void Main(string[] args)
        {
            
        }//end main

        public String getFileContent(String filePath)
        {
            string FILENAME = @"C:\Users\Desktop\test.txt";
            FileStream inFile = new FileStream(FILENAME, FileMode.Open, FileAccess.Read);
            StreamReader reader = new StreamReader(inFile);

        }//end getFileContent

        public double getSumOfNumbers(List<double> numbers)
        {
        }//end getSumeOfNumbers

        public double getAverageNumbers(List<double> numbers)
        {
        }//end getAverageOfNumbers

        public List<double> getEveryThreeValues(String source)
        {
        }//end getEveryThreeValues
    }

Would something like this work? Im not even sure if I am reading the file correctly though.

[thines01]

Well, you getFileContent method is set to return 1 string.
Let's look at it a different way:

If you wanted ALL of the rows from the file into a list of strings, you could do this:

using System.Collections.Generic;
using System.IO;

namespace DW_393702
{
   class CDW_393702
   {
      static void Main(string[] args)
      {
         StreamReader fileIn = new StreamReader("../../TextFile1.txt");
         //
         List<string> lst_strData = new List<string>();
         while (!fileIn.EndOfStream)
         {
            lst_strData.Add(fileIn.ReadLine());
         }
         //
         fileIn.Close();
      }
   }
}

With the data loaded in the list, you would still need to access the individual rows (no big deal) and get the usable data from them, right?

You could use the string .Split() method to get data from the individual strings.
You could also use more than one list or array and split the strings as they are read and count them as they are read IF nothing else is to happen to the records.

[notSo smartGuy]

Yea nothing else is happening with the records. If I was to count and split them as they are read would I use a for loop?

for(i = 0; i <= 30; i++) //to get the testScores for each roomNumber

then how would I assign the three testScores to the room number so I can do the math? Or am I making it harder than it should be?

I simply want to read the second and third row and add the testScore to get total and the average for each roomNumber

[thines01]

So, if you were to use 3 arrays (or lists), you could split the incoming string by the comma (and the space) and set the StringSplitOptions to remove empty entries.

At that point, the .Split() method would return to you three columns; the first of which would be the Student ID. The second (could be converted to an int) would be the room number. The third (converted to an int) would be the grades.

[Just a technique]
You could technically (simultaneously) loop through the room list and the grad list and add up grades based on rooms.

[notSo smartGuy]

[Just a technique]
You could technically (simultaneously) loop through the room list and the grad list and add up grades based on rooms.

Yes this is what I am trying to do...Not sure how to go about it though..

so would I set up a string array the following?? Or should I make a string array for roomNumber and testScore as well?

static void Main(string[] args)
        {
            string[] arr1 = new string[] { "studentID", "roomNumber", "testScore" };
            int sum = 0;
            int average = 0;

            StreamReader fileIn = new StreamReader(@"C:\Users\Desktop\test.txt");

            List<String> lst_strData = new List<string>();
            while (!fileIn.EndOfStream)
            {
                lst_strData.Add(fileIn.ReadLine());
                
            }//end while
            fileIn.Close();
        }//end main

[thines01]

My vision has it like this:

using System;
using System.Collections.Generic;
using System.IO;

namespace DW_393702
{
   class CDW_393702
   {
      static void Main(string[] args)
      {
         List<string> lst_strStudents = new List<string>();
         List<string> lst_strRooms = new List<string>();
         List<int> lst_intGrades = new List<int>();

         string[] arr_strData = { };
         StreamReader fileIn = new StreamReader("../../TextFile1.txt");
         while (!fileIn.EndOfStream)
         {
            // split the incoming data into columns
            arr_strData = fileIn.ReadLine().Split(", ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

            lst_strStudents.Add(arr_strData[0]);
            lst_strRooms.Add(arr_strData[1]);
            lst_intGrades.Add(int.Parse(arr_strData[2]));
         }

         fileIn.Close();

         /* at this point, the lists are all the same size, so you can
          * use one counter to go through the lists
          * You will need something to tell you how many students per room
          * You will need something to tell you how many actual distinct rooms
          */
      }
   }
}