将数据从SQL数据库添加到DataGrid C＃WPF MVVM(Add data from SQL database to DataGrid C# WPF MVVM)

将数据从SQL数据库添加到DataGrid C＃WPF MVVM(Add data from SQL database to DataGrid C# WPF MVVM)

我正在连接到SQL数据库并尝试使用收到的DataTable填充DataGrid，但DataGrid为空

在我的ViewModel中，我有：

数据表：

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

连接方法：

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代码：

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

连接正在工作。 我试图加载数据到列表并绑定到组合框，一切都正常。 此外，我试图将List和ObservableCollection绑定到DataGrid，但它无法正常工作。

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.

最满意答案

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

这是有效的！

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!