How to Bind Datagrid using MVVM Pattern?

Question

Goal:

I am currently aiming to connect the Datagrid and the ViewModel. The ViewModel currently has code that gets data from MySQL.

Not sure where to go from here or if I am doing it correctly...

Technical_Fsqm.xaml

<Grid>
    <TextBlock Text="FSQM"/>
    <DataGrid x:Name="FSQMData"
              AutoGenerateColumns="True"
              ItemsSource="{Binding data}" Margin="0,106,0,0"/>
</Grid>

Technical_Fsqm.xaml.cs

public partial class Technical_Fsqm : UserControl
{
    public Technical_Fsqm()
    {
        InitializeComponent();
        this.DataContext = new Technical_FsqmVM();
    }
}

Technical_FsqmVM.cs

using Dapper;

public class Technical_FsqmVM : INotifyPropertyChanged
{

    public List<FsqmModel> data()
    {
        string query = "select * from table;";

        using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString))
        {
            var output = conn.Query<FsqmModel>(query).ToList();

            return output;
        }
    }


    public event PropertyChangedEventHandler PropertyChanged;
    private void OnPropertyChanged(string propertyName)
    {
        PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
    }
}

Model

public class FsqmModel
{
    public int Id { get; set; }
    public string DocumentTitle { get; set; }

}

youtube.com/watch?v=LWw7qKDWKkU may help

Kamran Mammadov
– Kamran Mammadov

2020-12-15 14:30:27 +00:00
Commented Dec 15, 2020 at 14:30 — Kamran Mammadov
– Kamran Mammadov, Commented Dec 15, 2020 at 14:30
@KamranMammadov Thank you!

DeveloperLV
– DeveloperLV

2020-12-15 14:40:19 +00:00
Commented Dec 15, 2020 at 14:40 — DeveloperLV
– DeveloperLV, Commented Dec 15, 2020 at 14:40

ASh · Accepted Answer · 2020-12-15 14:13:24Z

1

is is not possible to create binding with method, only with property:

public partial class Technical_Fsqm : UserControl
{
    public Technical_Fsqm()
    {
        InitializeComponent();
        var vm = new Technical_FsqmVM();
        vm.LoadData();
        this.DataContext = vm;
    }
}

vm

public List<FsqmModel> data { get; private set; }

public void LoadData();
{
    string query = "select * from table;";

    using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString))
    {
        data = conn.Query<FsqmModel>(query).ToList();
    }
}

answered Dec 15, 2020 at 14:13

ASh

35.9k9 gold badges68 silver badges89 bronze badges

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

3 Comments

DeveloperLV Over a year ago

Meaning the ItemSource is unnecessary?

Rekshino Over a year ago

By the way, you can create binding with a method. See binding via ObjectDataProvider.

ASh Over a year ago

@Rekshino, if smth can be done, doesn't mean it should be done. see learn.microsoft.com/en-us/dotnet/desktop/wpf/advanced/…. and ObjectDataProvider isn't binding.

Collectives™ on Stack Overflow

How to Bind Datagrid using MVVM Pattern?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related