数据网格不允许编辑项目
本文关键字:编辑 项目 不允许 网格 数据网 数据 | 更新日期: 2023-09-27 18:32:19
我在 Wpf DataGrid. I am adding values in datagrid's first column called
Model Name 中遇到了问题"。 下面我也给出了我的代码来显示问题。
所以我的问题是第一列将显示数据库中的值,其他列可以写。所有值都将保存在某个数据库表中。当我使用 datagrid.Items.Add(data);
时,它会给出第一列中的值,工作正常,但如果我开始在其他列中写入,它会给出错误
"不允许编辑项目"。
这是我在 WPF 中的代码
<DataGrid HorizontalAlignment="Center"
Name="DeliveryGrid" IsReadOnly="False"
AutoGenerateColumns="False"
LoadingRow="DataGrid_LoadingRow"
Margin="0,85,0,0"
VerticalAlignment="Top"
Height="235"
Width="462">
<DataGrid.Columns>
<DataGridTextColumn Header="Model" Width="90" Binding="{Binding ModelName}" x:Name="ModelName" />
<DataGridTextColumn Header="Engine No" Width="90" x:Name="EngineNo" />
<DataGridTextColumn Header="Chasis No" Width="90" x:Name="ChasisNo" />
<DataGridTextColumn Header="Authority No" Width="90" x:Name="AuthorityNo" />
<DataGridTextColumn Header="Price" x:Name="Price" />
</DataGrid.Columns>
</DataGrid>
这是我在 C# 中的代码
public class BikesOrderObjects
{
public string ModelName { get; set; }
public int ModelID { get; set; }
public string BEngineNo { get; set; }
public string BChasisNo { get; set; }
public string BAuthorityNo { get; set; }
public double Price { get; set; }
public int qty { get; set; }
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
RST_DBDataContext conn = new RST_DBDataContext();
LoadDeliveryData();
}
private void LoadDeliveryData()
{
RST_DBDataContext conn = new RST_DBDataContext();
var BikesOrderData = conn.TblBikesOrdersDetails
.Where(TblBikesOrdersDetail => TblBikesOrdersDetail.BOId == 1)
.Select(TblBikesOrdersDetail => new
{
qty = TblBikesOrdersDetail.BQty,
ModelID = TblBikesOrdersDetail.ModelId,
ModelName = TblBikesOrdersDetail.TblBikeModel.ModelName
});
foreach (var item in BikesOrderData)
{
for (int i = 0; i < item.qty; i++)
{
var data = new BikesOrderObjects { ModelName = item.ModelName };
DeliveryGrid.Items.Add(data);
}
}
}
您可以直接should not update the Items
DataGrid
,而是将ItemsSource
设置为实现IEditableCollectionView
接口的集合以允许编辑。此接口具有允许编辑的功能EditItems()
。
所以为了解决这个问题。在窗口中创建ObservableCollection<BikesOrderObjects>
属性,例如MyBikesOrders,并将DataGrid ItemsSource
绑定到它,例如
<DataGrid HorizontalAlignment="Center" ItemsSource="{Binding MyBikesOrders}"/>
假设您已将窗口的DataContext
设置为自身。
在构造函数中,您可以通过更新来初始化此集合,并在LoadDeliveryData
方法中将对象添加到此集合中。
我得到了解决方案,这是我的代码
private void LoadDeliveryData()
{
RST_DBDataContext conn = new RST_DBDataContext();
var BikesOrderData = conn.TblBikesOrdersDetails
.Where(TblBikesOrdersDetail => TblBikesOrdersDetail.BOId == 1)
.Select(TblBikesOrdersDetail => new
{
qty = TblBikesOrdersDetail.BQty,
ModelID = TblBikesOrdersDetail.ModelId,
ModelName = TblBikesOrdersDetail.TblBikeModel.ModelName
});
List<BikesOrderObjects> data = new List<BikesOrderObjects>();
foreach (var item in BikesOrderData)
{
for (int i = 0; i < item.qty; i++)
{
BikesOrderObjects datae = new BikesOrderObjects();
datae.ModelName = item.ModelName;
data.Add(datae);
}
}
DeliveryGrid.ItemsSource = data;
}