Add data from SQL database to DataGrid C# WPF MVVM

Question

I'm connecting to SQL Database and trying to fill DataGrid with received DataTable, but DataGrid is empty

In my ViewModel I have:

DataTable:

private DataTable _myData;
public DataTable MyData 
{  get => _myData;
   set=> UpdateValue(value, ref _myData);
}

Connecting Method:

var connStr = new StringBuilder();
            const string agentsQuery =
                "select CONCAT(users.last_name, ' ', users.first_name) as Agent from users where users.valid_id = 1 group by users.id";

            connStr.AppendFormat("server={0};user={1};database=otrs;password={2}",
                Connect.IP,
                Connect.User,
                Connect.Password);

            Connect.Connection = new MySqlConnection(connStr.ToString());
            Connect.Connection.Open();

           using (var sqlCom = new MySqlCommand(agentsQuery,  Connect.Connection))
                {
                    sqlCom.ExecuteNonQuery();
                    var dataAdapter = new MySqlDataAdapter(sqlCom);
                    dataAdapter.Fill(_myData);

                }

XAML Code:

<DataGrid ItemsSource="{Binding Path=MyData}"
          AutoGenerateColumns="True">
</DataGrid>

Connection is working. I've tried to load data to List and bind to ComboBox and everything is OK. Also, I've tried to bind List and ObservableCollection to DataGrid but it doesn't work anyway.

try this stackoverflow.com/a/21955956/2470530

caner
– caner

2017-05-08 10:57:22 +00:00
Commented May 8, 2017 at 10:57 — caner
– caner, Commented May 8, 2017 at 10:57

Pavel · Accepted Answer · 2017-05-08 12:08:01Z

1

using (var sqlCom = new MySqlCommand(agentsQuery, Connect.Connection))
                {
                    sqlCom.ExecuteNonQuery();
                    var dt = new DataTable();
                    var dataAdapter = new MySqlDataAdapter(sqlCom);
                    dataAdapter.Fill(dt);
                    MyData = dt;

                }

That's worked!

answered May 8, 2017 at 12:08

Pavel

113 bronze badges

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

Collectives™ on Stack Overflow

Add data from SQL database to DataGrid C# WPF MVVM

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related