I have a c# linq assignment to add a data from the csv file, here is my code:

        struct DailyValues
        {
            public DateTime Date { get; private set; }
            public decimal Open { get; private set; }
            public decimal High { get; private set; }
            public decimal Low { get; private set; }
            public decimal Close { get; private set; }
            public decimal Volume { get; private set; }
            public decimal AdjClose { get; private set; }

            public DailyValues(DateTime date, decimal open, decimal high, decimal low,
                decimal close, decimal volume, decimal adjClose)
                : this()
            {
                Date = date;
                Open = open;
                High = high;
                Low = low;
                Close = close;
                Volume = volume;
                AdjClose = adjClose;
            }

            public override string ToString()
            {
                return string.Format("O:{0} / H:{1} / L:{2} / C:{3} / V:{4} / AC:{5} / {6:d}",
                        Open, High, Low, Close, Volume, AdjClose, Date);
            }

            // reads stock values from csv file into a List
            public static List<DailyValues> GetStockValues(string filePath)
            {
                List<DailyValues> values = new List<DailyValues>();

                // TODO: add the data from the csv file


                string[] rows = filePath.Replace("\r", "").Split('\n');
                foreach (string row in rows)
                {
                    if (string.IsNullOrEmpty(row)) continue;
                    string[] cols = row.Split(',');
                    DailyValues v = new DailyValues();

                    v.Open = Convert.ToDecimal(cols[0]);
                    v.High = Convert.ToDecimal(cols[1]);
                    v.Low = Convert.ToDecimal(cols[2]);
                    v.Close = Convert.ToDecimal(cols[3]);
                    v.Volume = Convert.ToDecimal(cols[4]);
                    v.AdjClose = Convert.ToDecimal(cols[5]);
                    v.Date = Convert.ToDateTime(cols[6]);
                    values.Add(v);


                }


                return values;
            }
        }
    }

And when I compile it shows me command
Can anyone help me out give me some hint where did i did wrong? I would be very appreciate that!

Recommended Answers

All 2 Replies

Run it in debugging and find out what line the exception occurs on.

Where are you reading the file? I see you changing the path, but not actually reading any data from the file. And why do you change the path?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.