Read csv file into wpf C#
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]);
});
}
4
5
<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>
Thank you!
5
4
(5 Votes)
0
4
6
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;
}
}
Thank you!
6
4
(6 Votes)
0
4
2
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");
}
Thank you!
2
4
(2 Votes)
0
Are there any code examples left?
New code examples in category C#
Relative searches
csse read csv file to c# wpf app
read csv c# wpf app
Read csv file into wpf C#
how to read and write csv file in c# wpf
write data to csv in c# wpf
can document view wpf view csv
C# CSv to wpf
wpf csv file
how to access a csv file in C# wpf
wpf read csv file as database
wpf import csv to datagrid
csv file to wpf programmatically
c# wpf csv import
c# wpf csv import preview
wpf parse csv file
