Quick C# Help Retrieve data using while (!sr.EndOfStream)

David Chen

I ran into problem for my school assignment and it is to display whatever in a meal.csv file, here is a code we are starting with. The array string of itemDetails is where the data is store then passed into array ReadLines, then in Main, it is passed to mealContent, but when I tried Console.WriteLine(mealContent); it only prompted System.String[]. So how do I at least display it out in the command prompt. Thanks for the help guys~ Source code is also attached

Code/meal.csv

lunch,bento box b - sashimi,box combo,$9.59
dinner,vegetable sushi,6 rolls,$3.50
dinner,tuna roll,3 rolls,$4.50
dinner,roe, 2 rolls,$3.95
lunch,bento box a - chicken teriyaki,box combo,$8.59

lunch,bento box b - 
sashimi,box combo,$9.59
dinner,vegetable sushi,6 rolls,$3.50
dinner,tuna roll,3 rolls,$4.50
dinner,roe, 2 rolls,$3.95
lunch,bento box a - chicken teriyaki,box combo,$8.59

FileIOManager/FileLocation.cs

using System;

namespace FileIOManager
{
    static class FileLocation
    {
        public const string INPUT_FILE = "../../Data/meals.csv";
    }
}

using System;

namespace FileIOManager
{
    static class FileLocation
    {
        public const string INPUT_FILE = "../../Data/meals.csv";
    }
}

FileIOManager/FileReader.cs

using System;
using System.IO;

namespace FileIOManager
{
    static public class FileReader
    {
        private static int GetLineCount()
        {
             StreamReader sr = new StreamReader(FileLocation.INPUT_FILE);
             int counter = 0;
             while (!sr.EndOfStream)
             {
                  counter++;
                  sr.ReadLine();
             }
             sr.Close();
             return counter;
         }

public static string[] ReadLines()

{

int totalItems = GetLineCount();

string[] itemDetails = new string[totalItems];

StreamReader sr = new StreamReader(FileLocation.INPUT_FILE);

string itemDetail;

int counter = 0;

while (!sr.EndOfStream){

itemDetail = sr.ReadLine();

if (itemDetail.Trim() != "")

itemDetails[counter++] = itemDetail;

}

sr.Close();

return itemDetails;

}

6 Replies

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

Bryian Tan16y ago

Accepted answer

hello,

to display the output, replace these lines

Console.WriteLine(mealContent);
Console.ReadLine();

foreach (string m in mealContent)
            {
                Console.WriteLine(m);
                Console.ReadLine();
            }

David Chen16y ago

in main im trying to set it like this

string[] meals = System.IO.File.ReadAllLines("meals.csv");

while I created a separate class file like this, but im stuck, dont know how to go any where now.

Btw, do you have msn Bryian

class MealContent
        {
            public string MealTime;
            public string Entre;
            public string UnitOfIssue;
            public double Price = 0.0d;
            public MealContent(string csvData)
            {
                string[] parts = csvData.Split(',');
                MealTime = parts[0];
                Entre = parts[1];
                UnitOfIssue = parts[2];
                parts[3] = parts[3].Replace('$', ' ').Trim();
                Price = double.Parse(parts[3]);
            }
        }

Bryian Tan16y ago
hello,

What you have so far? Show me your codes.
David Chen16y ago
I understand what you are doing. Iterate over the array and write out each one individually. But im actually stuck on the next step lol i hope you can help out too.

the price actually needed to times by 1.8 so Price = Cost * 1.8

also i'll be dealing with bubble sort.. which I have never learn to knew how to coz we have ot make it look like this in the end

* Lunch Items *

$15.46     bento box a - chicken teriyaki, box combo

$17.26     bento box b – sashimi, box combo

* Dinner Items *

$7.11     roe, 2 rolls

$8.10     tuna roll, 3 rolls
$6.30     vegetable sushi, 6 rolls

Thanks again for your time off

David
Bryian Tan16y ago
You are welcome.
David Chen16y ago
Thank you Bryian Tan