Не выводит данные в ListView
Users:
class Users
{
public static DataView User { get; set; }
}
Load:
class Load
{
private static string connectionString = @"Data Source=DESKTOP-DHMQJ5P;Initial Catalog=Test;Integrated Security=True";
private static SqlConnection connection = new SqlConnection(connectionString);
private static SqlDataAdapter adapter;
private static DataTable dataTable = new DataTable();
private static SqlCommand command;
public static void getUsers()
{
try
{
using (connection)
{
adapter = new SqlDataAdapter($"SELECT * FROM Users", connection);
adapter.Fill(dataTable);
Users.User = dataTable.DefaultView;
};
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
App.xaml.cs:
using System.Windows;
namespace Test
{
public partial class App : Application
{
private View.MainWindow mainWindow;
private void Application_Startup(object sender, StartupEventArgs e)
{
var mainViewModel = new ViewModel.MainViewModel();
mainWindow = new View.MainWindow { DataContext = mainViewModel };
MainWindow.Show();
}
}
MainViewModel:
class MainViewModel
{
public MainViewModel()
{
Model.Load.getUsers();
}
}
MainWindow.xaml:
<StackPanel HorizontalAlignment="Center" VerticalAlignment="Center">
<ListView ItemsSource="{Binding Users}" Width="auto" Height="500" ScrollViewer.VerticalScrollBarVisibility="Visible" ScrollViewer.HorizontalScrollBarVisibility="Disabled">
<ListView.ItemTemplate>
<DataTemplate>
<StackPanel Orientation="Horizontal" Height="auto">
<TextBlock Text="{Binding id, StringFormat='id: {0}'}"/>
<TextBlock Text="{Binding name, StringFormat='Имя: {0}'}"/>
<TextBlock Text="{Binding second_name, StringFormat='Фамилия: {0}'}"/>
<TextBlock Text="{Binding patronymic, StringFormat='Отчество: {0}'}"/>
<TextBlock Text="{Binding date_birthday, StringFormat='Дата Рождения: {0}'}"/>
<TextBlock Text="{Binding phone, StringFormat='Телефон: {0}'}"/>
<TextBlock Text="{Binding email, StringFormat='Email: {0}'}"/>
</StackPanel>
</DataTemplate>
</ListView.ItemTemplate>
</ListView>
</StackPanel>
UPD: MainViewModel:
public MainViewModel()
{
Model.Load.getUsers();
DataView Users = Model.Users.User;
}
