Create string 2 dim array to copy the data from the csv file in C#

Question

0.00/5 (No votes)

See more:

Hello, couldn't you please advise me how to create a string 2 dimensional array and copy there the data from the csv file. This code is not creating string data[,] array and do not copy the data from the csv file in the loop.

What I have tried:

using System;
using System.IO;
using System.Data;
using System.Collections.Generic;
using lpsolve55;

namespace LpSolveExample
{
    class Program
    {
        static void Main(string[] args)
        {
            int n = 158;
            int m = 9;
            string[,] data = new string[n, m];
            string path = "D:\\NM1997.csv";
            StreamReader sr = new StreamReader(path);
            int i = 0, j = 0;
            string line; string temp;
            char delim = ';';
            string[] mass_t;
            while (((line) = sr.ReadLine()) != null)
            {
                mass_t = line.Split(';');
                while (j < mass_t.Length)
                {
                    temp = mass_t[j];
                    data[i, j] = (temp);//this does not work
                    j++;
                }
                i++;
            }
            for(int k=0;k>158; k++)
            {
                for(int l =0;l<9;l++)
                {
                    Console.Write(data[i, j]);
                    Console.WriteLine();

                }
            }
        }
    }
}

Posted 17-Nov-17 7:35am

Alma Konde

Updated 17-Nov-17 20:13pm

Add a Solution

Comments

Richard MacCutchan 17-Nov-17 13:40pm

You never reset j to zero.

BillWoodruff 17-Nov-17 22:45pm

Put break-points in your code, single-step through it using F11 in Visual Studio. Observe any errors or unexpected behavior/values. Report what you find here.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-11-17T20:03:00

Instead of using a while for your inner loop, use a for:

C#

while (!sr.EndOfStream)
{
    line = sr.ReadLine();
    mass_t = line.Split(';');
    for (int i = 0; j < mass_t.Length; j++)
    {
        temp = mass_t[j];
        data[i, j] = temp;
    }
    i++;
}

Or better, use File.ReadAllLines to read them all into an array of strings, and use foreach on that array.

Even better than that though would be to use A Fast CSV Reader[^] which will handle quoted strings as well. It can be configured to use ";" instead of "," as the separator.