How do I load a DataGrid with data from a database using WPF and MVVM?

Question

I am a complete newbie to WPF and MVVM so I apologise in advance if this query is quite simple. I've searched online and havent been able to find anything which fits my requirements. Hense why I'm here!

I am currently trying to implement a table of data queried from a database using LINQ. This is the query I run:

DataContext connection = new DataContext();

    var getTripInformation = from m in connection.tblTrips
                where m.TripDate > DateTime.Today
                select new { m.TripID, m.TripName, m.TripDate, m.ClosingDate, m.PricePerAdult, m.PricePerChild, m.Status };

Which fills my var with the relevant information which I expect.

Now, what I want to be able to do is diplay this in my View using a DataGrid. Can anyone assist me with this?

It is yeah. I'm just strugging to setup the model to bind the grid to the query. — framps
– framps, Commented Jun 22, 2012 at 13:09
so add an observableCollection<tblTrips> property and put a onPropertyChanged("PropertyName") in setter part then bind you Datagrid's ItemsSource : ItemsSource="{Binding PropertyName}" to this property. now to set the property : in the viewModel's constructor put PropertyName = new ObservableCollection<tblTrips>(getTripInformation.ToList()) It would work unless you did't bind your VM to the View as it has to be. — HichemSeeSharp
– HichemSeeSharp, Commented Jun 22, 2012 at 13:20

Jordan Parmer · Accepted Answer · 2012-06-22 16:04:28Z

7

In a nutshell, you will have your View and ViewModel. The ViewModel will need to implement the INotifyPropertyChanged interface to facilitate view binding. This just provides an event that is raised when you change a property on your ViewModel. Your View will then bind to the ViewModel's properties. This works as long as the DataContext of the view is set to a ViewModel instance. Below, this is done in code-behind, but many purists do this directly in XAML. Once these relationships are defined, run your LINQ query to populate the ObservableCollection (which also implements INotifyPropertyChanged for when items are added/removed internally) and your grid will show the data.

ViewModel

public class MyViewModel : INotifyPropertyChanged
{
    public event PropertyChangedEventHandler PropertyChanged;

    private ObservableCollection<MyRecord> _records = null;
    public ObservableCollection<MyRecord> Records 
    {
        get { return _records; }
        set
        {
            if( _records != value )
            {
                _records = value;

                if( this.PropertyChanged != null )
                {
                    this.PropertyChanged( this, new PropertyChangedEventArgs( "Records" ) );
                }
             }
         }
    }

    public MyViewModel()
    {
        this.Records = new ObservableCollection<MyRecord>();
        this.LoadData();
    }

    private void LoadData()
    {
        // this populates Records using your LINQ query
    }

View (Code-Behind)

public class MyView : UserControl
{
    public MyView()
    {
        InitializeControl();

        // setup datacontext - this can be done directly in XAML as well
        this.DataContext = new MyViewModel();
    }
}

View (XAML)

<DataGrid
    ItemsSource="{Binding Path=Records, Mode=OneWay}"
    ...
/>

If you set AutoGenerateColumns = 'True' on your DataGrid, it will create a row for each public property of the bound item type. If you set this value to false, you will need to explicitly list the columns and what property they will map to.

edited Jun 22, 2012 at 16:04

answered Jun 22, 2012 at 13:22

Jordan Parmer

37.4k30 gold badges100 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

framps Over a year ago

Hiya, having tried to implement your suggestion. The NotifyPropertyChangedEventArgs is appearing with a red line beneath it and I cant find a solution?

Jordan Parmer Over a year ago

Sorry, it's PropertyChangedEventArgs. I'll fix my post.

pchajer · Accepted Answer · 2012-06-22 12:10:10Z

0

If you are developing the application using MVVM then you need to do-

ViewModel Class - that will have UI logic and will implement INotifyPropertyChanged interface. You need to create Property of type collection which will gets binded with DataGrid. And on setter of this proeprty you need to call PropertyChangedEventHandler.
You need to set the DataContext of View to your ViewModel on XAML, Codebehind, ViewModel or on some mediator class.

answered Jun 22, 2012 at 12:10

pchajer

1,5822 gold badges13 silver badges25 bronze badges

1 Comment

framps Over a year ago

Do you have an example which you can provide for this as I'm struggling with the logic?

Collectives™ on Stack Overflow

How do I load a DataGrid with data from a database using WPF and MVVM?

2 Answers 2

ViewModel

View (Code-Behind)

View (XAML)

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

ViewModel

View (Code-Behind)

View (XAML)

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related