Read csv file into wpf C#

<ListView x:Name="ListViewPeople"> <ListView.View> <GridView> <GridViewColumn Header="First name" Width="100" DisplayMemberBinding="{Binding Path=FirstName}"/> <GridViewColumn Header="Last name" Width="150" DisplayMemberBinding="{Binding Path=LastName}"/> <GridViewColumn Header="ID" Width="40" DisplayMemberBinding="{Binding Path=ID}"/> <GridViewColumn Header="Email" Width="200" DisplayMemberBinding="{Binding Path=Email}"/> </GridView> </ListView.View> </ListView>

public class Person { public string FirstName { get; set; } public string LastName { get; set; } public int ID { get; set; } public string Email { get; set; } public Person(string firstName, string lastName, int id, string email) { FirstName = firstName; LastName = lastName; ID = id; Email = email; } }

public MainWindow() { InitializeComponent(); // We can access ListViewPeople here because that's the Name of our list // using the x:Name property in the designer. ListViewPeople.ItemsSource = ReadCSV("example"); }

public IEnumerable<Person> ReadCSV(string fileName)
{
    // We change file extension here to make sure it's a .csv file.
    // TODO: Error checking.
    string[] lines = File.ReadAllLines(System.IO.Path.ChangeExtension(fileName, ".csv"));

    // lines.Select allows me to project each line as a Person. 
    // This will give me an IEnumerable<Person> back.
    return lines.Select(line =>
    {
        string[] data = line.Split(';');
        // We return a person with the data in order.
        return new Person(data[0], data[1], Convert.ToInt32(data[2]), data[3]);
    });
}

Posted by: Guest on April-13-2020

Source

Code answers related to "Read csv file into wpf C#"

Code answers related to "C#"

Browse Popular Code Answers by Language

Answers for "Read csv file into wpf C#"

Code answers related to "Read csv file into wpf C#"

Code answers related to "C#"

C# Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us