gpt4 book ai didi

c# - 如何将 DataTable 绑定(bind)到 DataGrid

转载 作者:可可西里 更新时间:2023-11-01 08:23:31 24 4
gpt4 key购买 nike

这是我的数据表。

DataTable _simpleDataTable = new ataTable();     

var person = new DataColumn("Person") {DataType = typeof (Person)};
_simpleDataTable.Columns.Add(person);

var student = new DataColumn("Student") {DataType = typeof (Student)};
_simpleDataTable.Columns.Add(student);

var dr1 = _simpleDataTable.NewRow();
dr1[0] = new Person {PersonId = 1, PersonName = "TONY"};
dr1[1] = new Student { StudentId = 1, StudentName = "TONY" };
_simpleDataTable.Rows.Add(dr1);

var dr2 = _simpleDataTable.NewRow();
dr2[0] = new Person { PersonId = 2, PersonName = "MAL" };
dr2[1] = new Student { StudentId = 2, StudentName = "MAL" };
_simpleDataTable.Rows.Add(dr2);

请告诉我如何绑定(bind)以上类型的 DataTable。

最佳答案

这是一个基于问题要求和 these answers 的工作示例解决方案

主窗口

XAML

<Window x:Class="HowBindDataTableToDataGrid.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="MainWindow" Height="350" Width="525">
<Window.Resources>
<!-- you need foreach class one DataTemplate-->
<DataTemplate x:Key="PersonDataTemplate" DataType="Person">
<StackPanel>
<TextBlock Background="LightBlue" Text="{Binding PersonId}"/>
<TextBlock Background="AliceBlue" Text="{Binding PersonName}"/>
</StackPanel>
</DataTemplate>
<DataTemplate x:Key="StudentDataTemplate" DataType="Student">
<StackPanel>
<TextBlock Background="Orange" Text="{Binding StudentId}"/>
<TextBlock Background="Yellow" Text="{Binding StudentName}"/>
</StackPanel>
</DataTemplate>
</Window.Resources>
<Grid>
<DataGrid Name="simpleDataGrid" AutoGeneratingColumn="simpleDataGrid_AutoGeneratingColumn" />
</Grid>
</Window>

.CS

using System.Data;
using System.Windows;
using System.Windows.Data;
using System.Windows.Controls;

namespace HowBindDataTableToDataGrid
{
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();

simpleDataGrid.ItemsSource = LoadDataTable().AsDataView();
}

private void simpleDataGrid_AutoGeneratingColumn(object sender, DataGridAutoGeneratingColumnEventArgs e)
{
if (e.PropertyType == typeof(Person))
{
MyDataGridTemplateColumn col = new MyDataGridTemplateColumn();
col.ColumnName = e.PropertyName;
col.CellTemplate = (DataTemplate)FindResource("PersonDataTemplate");
e.Column = col;
e.Column.Header = e.PropertyName;
}
else if (e.PropertyType == typeof(Student))
{
MyDataGridTemplateColumn col = new MyDataGridTemplateColumn();
col.ColumnName = e.PropertyName;
col.CellTemplate = (DataTemplate)FindResource("StudentDataTemplate");
e.Column = col;
e.Column.Header = e.PropertyName;
}
}

private DataTable LoadDataTable()
{
var _simpleDataTable = new DataTable();

var person = new DataColumn("Person") { DataType = typeof(Person) };
_simpleDataTable.Columns.Add(person);

var student = new DataColumn("Student") { DataType = typeof(Student) };
_simpleDataTable.Columns.Add(student);

var dr1 = _simpleDataTable.NewRow();
dr1[0] = new Person { PersonId = 1, PersonName = "TONY" };
dr1[1] = new Student { StudentId = 1, StudentName = "TONY" };
_simpleDataTable.Rows.Add(dr1);

var dr2 = _simpleDataTable.NewRow();
dr2[0] = new Person { PersonId = 2, PersonName = "MAL" };
dr2[1] = new Student { StudentId = 2, StudentName = "MAL" };
_simpleDataTable.Rows.Add(dr2);

return _simpleDataTable;
}
}

public class MyDataGridTemplateColumn : DataGridTemplateColumn
{
public string ColumnName { get; set; }

protected override System.Windows.FrameworkElement GenerateElement(DataGridCell cell, object dataItem)
{
// The DataGridTemplateColumn uses ContentPresenter with your DataTemplate.
ContentPresenter cp = (ContentPresenter)base.GenerateElement(cell, dataItem);
// Reset the Binding to the specific column. The default binding is to the DataRowView.
BindingOperations.SetBinding(cp, ContentPresenter.ContentProperty, new Binding(this.ColumnName));
return cp;
}
}
}

人物.cs

namespace HowBindDataTableToDataGrid
{
public class Person
{
private int personId;
private string personName;

public int PersonId
{
get { return personId; }
set { personId = value; }
}
public string PersonName
{
get { return personName; }
set { personName = value; }
}
}
}

学生.cs

namespace HowBindDataTableToDataGrid
{
public class Student
{
private int personId;
private string personName;

public int StudentId
{
get { return personId; }
set { personId = value; }
}
public string StudentName
{
get { return personName; }
set { personName = value; }
}
}
}

关于c# - 如何将 DataTable 绑定(bind)到 DataGrid,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/6808210/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com