如何绑定到数据表的DataGrid [英] How Bind DataTable to DataGrid

问题描述

这是我的数据表。

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);

Plaase告诉我如何绑定上述类型的DataTable的。

Plaase tell me how to bind above type of DataTable.

推荐答案

这是一个基于从问题的要求的工作样品溶液和的这个答案

This is an working sample solution based on the requirements from Question and This 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;
        }
    }
}

Person.cs

Person.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; }
        }
    }
}

Student.cs

Student.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; }
        }
    }
}

这篇关于如何绑定到数据表的DataGrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！