C#: Populate Combobox with single column in CSV

Question

I have a csv file with multiple columns, "PROJECT NAME", "PROJECT BUILD". I am trying to populate comobobox with Project Name column only.

Project name column might have multiple repeated names but repeated names should only appear once in combobox as an option to select. For example: in column 1, under "Project Name", Toyota is listed 4 times and Honda is listed 8 Times. Combobox will have 2 things, Toyota and Honda.

Here is my code so far:

// Wehn Form Loads___________________________________________________________________________________________________

    public void OnLoad(object sender, RoutedEventArgs e)
    {
        StreamReader sr = new StreamReader(path);
        string column = sr.ReadToEnd();
        string[] eachColumn = column.Split(',');

        foreach (string s in eachColumn)
        {
            
            Project_Name_Combobox.Items.Add(s);
        }
    }

The current code gets me the entire csv content (row and column) separated by "," listed under combo box. :(. Any help is apricated.

Answer 1

You have to separate out the rows and columns from csv and store whatever you need separately like below.

  public void OnLoad(object sender, RoutedEventArgs e)
    {
        StreamReader sr = new StreamReader(path);
        List<string> ProjectNames = new List<string>();
        int lineNumber = 1;
        while (!sr.EndOfStream)
        {
            var EachRow = sr.ReadLine();
            var Columns= EachRow.Split(',');
            if(lineNumber != 1){
            ProjectNames.Add(Columns[0]);           
            }
             lineNumber++;                
        }
       ProjectNames = ProjectNames.Distinct().ToList();
       foreach(var projectName in ProjectNames){
         Project_Name_Combobox.Items.Add(projectName);
       }                            
    }