添加行时，DataTable中的列重复 [英] Duplicate column in DataTable when adding row

问题描述

我创建一个DataTable并将其绑定到DataGrid。我的数据源由一个表（FooTable）组成，其中一个表（FooName）组成。

I create a DataTable and bind it to a DataGrid. My DataSource consist of one Table (FooTable) which consist of one column (FooName).

以下代码运行良好-除了每次我添加新行时，是使用相同数据填充的重复列，但我不知道该如何删除。请参见下面的图像和代码。我只有一个FooName列，并且出现重复列。

The following codes runs fine - except that each time I add a new row, there is a duplicate Column fill in with the same data, which I don't know how to get rid of. See below image and code. I have only one FooName column and a duplicate column comes out.

/* Create a DataGrid dg1 */
DataGrid dg1 = new DataGrid();
DataGridTextColumn col = new DataGridTextColumn();
col = new DataGridTextColumn();
colA.Binding = new Binding("FooName");
colA.Header = "FooName";
dg1.Columns.Add(colA);
dataGrid1.Children.Add(dg1);

/* Create a DataTable and bind it to DataGrid */
SqlCeDataAdapter da = new SqlCeDataAdapter();
string sqlStr = @"SELECT * FROM FooTable";
da.SelectCommand = new SqlCeCommand(sqlStr, conn);
da.Fill(ds, "FooTable");
dt = ds.Tables["FooTable"];
DataRow newRow = dt.NewRow();
newRow["FooName"] = "Donkey";
dt.Rows.Add(newRow);
dg1.ItemsSource = ds.Tables[0].DefaultView;

推荐答案

尝试将AutoGenerateColumns设置为false

try setting AutoGenerateColumns to false

 dg1.AutoGenerateColumns = false

这篇关于添加行时，DataTable中的列重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！