In this article, I am going to explain how to extract data from database and how to show data on a page using WPF ListView control.

I am using Northwind database, you can use whatever you want, and only you have to change is the connection string, your SQL string, and the binding properties in XAML code.

Here is the. xaml code:

<Grid x:Name="Grid1">

  <ListView Name="ListViewEmployeeDetails" Margin="4,20,40,100" ItemTemplate="{DynamicResource EmployeeTemplate}" ItemsSource="{Binding Path=Table}">

    <ListView.Background>

      <LinearGradientBrush>

        <GradientStop Color="Gray" Offset="0"/>           

      </LinearGradientBrush>

    </ListView.Background>

    <ListView.View>         

      <GridView>

        <GridViewColumn Header="Employee ID" DisplayMemberBinding="{Binding Path=EmployeeID}"/>

        <GridViewColumn Header="First Name" DisplayMemberBinding="{Binding Path=FirstName}"/>

        <GridViewColumn Header="Last Name" DisplayMemberBinding="{Binding Path=LastName}"/>

        <GridViewColumn Header="BirthDate" DisplayMemberBinding="{Binding Path=BirthDate}"/>

        <GridViewColumn Header="City" DisplayMemberBinding="{Binding Path=City}"/>

        <GridViewColumn Header="Country" DisplayMemberBinding="{Binding Path=Country}"/>

      </GridView>

    </ListView.View>

  </ListView>

</Grid>

Here is .VB code:

         Dim con As SqlConnection = New SqlConnection()
         Dim ad As SqlDataAdapter = New SqlDataAdapter()
         Dim cmd As SqlCommand = New SqlCommand()
         Dim str As String = "SELECT EmployeeID, FirstName, LastName, BirthDate, City, Country FROM Employees"
         cmd.CommandText = str
         ad.SelectCommand = cmd
         con.ConnectionString = "Data Source=localhost; Initial Catalog=Northwind; Integrated Security=True"
         cmd.Connection = con
         Dim ds As DataSet = New DataSet()
         ad.Fill(ds)
         ListViewEmployeeDetails.DataContext = ds.Tables(0).DefaultView
         con.Close()
 

Note:  Add two namespace.

Imports System.Data.SqlClient
Imports System.Data

Snapshot:

I hope you will like this article. If yes drop me a line or write a comment below in the comments section.