WPF 数据网格未填充数据
本文关键字:数据 填充 数据网 WPF 网格 | 更新日期: 2023-09-27 18:36:06
我在WPF C#项目中用来自DB(Sqlite)的数据填充DataGrid时遇到问题。
我在 XAML 文件中用名称 (dataGrid_Students) 定义了数据网格:
<DataGrid Name="dataGrid_Students" Grid.Row="0" Grid.Column="0"
RenderOptions.ClearTypeHint="Enabled"
TextOptions.TextFormattingMode="Display"
CanUserAddRows="False"
CanUserDeleteRows="False"
SelectionUnit="FullRow"
AutoGenerateColumns="false"
>
<DataGrid.Columns>
<DataGridTextColumn Header="Index Number" />
<DataGridTextColumn Header="First Name" />
<DataGridTextColumn Header="Last Name" />
</DataGrid.Columns>
</DataGrid>
在定义了 DataGrid 组件的此窗口的构造函数中的 C# 文件中,我调用了该方法initDataGrid();
public StudentForm() {
InitializeComponent();
this.WindowStartupLocation = WindowStartupLocation.CenterScreen;
initDataGrid();
}
其中包含以下代码:
private void initDataGrid() {
//dataGrid_Student.DataContext = dbManager.Students; does not work
dataGrid_Student.ItemsSource = dbManager.Students;
}
所以问题是我的数据网格是空的。我已经检查了我的学生列表是否可能为空,但事实并非如此,它包含所有数据。那么为了用数据填充数据网格,我还缺少什么?
更新:
我的学生班:
[Table("student")]
class Student {
[Key] // this is a primary key in my table
[Column(name:"brind")]
public int Brind { get; set; }
[Column(name:"first_name")]
public string FirstName { get; set; }
[Column(name:"last_name")]
public string LastName { get; set; }
}
将我的属性从学生类绑定到此列:
<DataGrid Name="dataGrid_Student" Grid.Row="0" Grid.Column="0"
RenderOptions.ClearTypeHint="Enabled"
TextOptions.TextFormattingMode="Display"
CanUserAddRows="False"
CanUserDeleteRows="False"
SelectionUnit="FullRow"
AutoGenerateColumns="false"
>
<DataGrid.Columns>
<DataGridTextColumn Header="Index Number" Binding="{Binding Brind}" />
<DataGridTextColumn Header="First Name" Binding="{Binding FirstName}" />
<DataGridTextColumn Header="Last Name" Binding="{Binding LastName}" />
</DataGrid.Columns>
</DataGrid>
DataGrid 仍然是空的。
我的数据库管理器实例是这样的:
class ManagerDBContext : DbContext {
public ManagerDBContext() : base("Student_DbContext") {
Database.SetInitializer<ManagerDBContext>(null);
}
public DbSet<User> Users { get; set; }
public DbSet<Student> Students { get; set; }
}
您缺少列的绑定部分,因为您已将自动生成列设置为 false,
<DataGrid.Columns>
<DataGridTextColumn Header="Index Number" Binding="{Binding IndexNumber}" />
<DataGridTextColumn Header="First Name" Binding="{Binding FirstName}" />
<DataGridTextColumn Header="Last Name" Binding="{Binding LastName}" />
</DataGrid.Columns>
绑定时还需要转换为列表
private void initDataGrid() {
//dataGrid_Student.DataContext = dbManager.Students; does not work
dataGrid_Student.ItemsSource = dbManager.Students.ToList();
}