Avalonia 关于DataTable数据集通过DataGrid展示数据的问题

Avalonia 的DataGrid不支持直接绑定DataTable显示数据，因此需要特别处理。

 

public static void DataGridBindDataTable(DataGrid grid,DataTable dt)
{
try
{

//先清除datagrid 的所有column
while (grid.Columns.Count > 0) { grid.Columns.RemoveAt(grid.Columns.Count - 1); }

//绑定datatable的dataview
grid.ItemsSource = dt.DefaultView;

//datatable列循环生成列信息
foreach (System.Data.DataColumn x in dt.Columns)
{
if (x.DataType == typeof(bool))
{
grid.Columns.Add(new DataGridCheckBoxColumn { Header = x.ColumnName, Binding = new Avalonia.Data.Binding($"Row.ItemArray[{x.Ordinal}]") });
}
else
{
grid.Columns.Add(new DataGridTextColumn { Header = x.ColumnName, Binding = new Avalonia.Data.Binding($"Row.ItemArray[{x.Ordinal}]") });
}
}

}
catch(Exception ex)
{
throw ex;
}
}

由于DataView有默认的属性，但是在DataGrid中不需要展示，因此需要通过AutoGeneratingColumn事件进行处理

private void DataGrid_AutoGeneratingColumn(object? sender, Avalonia.Controls.DataGridAutoGeneratingColumnEventArgs e)
{
// 排除不需要的属性
if (e.PropertyName == "DataView" ||
e.PropertyName == "Item" ||
e.PropertyName == "RowVersion" ||
e.PropertyName == "Row" ||
e.PropertyName == "IsNew" ||
e.PropertyName == "IsEdit")
{
e.Cancel = true;
}
}