c# – datagridview绑定到实体不更新数据库
发布时间:2020-12-15 03:44:48 所属栏目:百科 来源:网络整理
导读:我从一个实体对象填充一个网格,它正在显示数据.当我进行更改并将其保存回来时,没有任何更新. 这是我的代码: 在我的载入事件中: var query = from c in _entities.PaymentTypes where c.CorporationId == _currentcorp.CorporationId select new DataBindin
我从一个实体对象填充一个网格,它正在显示数据.当我进行更改并将其保存回来时,没有任何更新.
这是我的代码: 在我的载入事件中: var query = from c in _entities.PaymentTypes where c.CorporationId == _currentcorp.CorporationId select new DataBindingProjection { PaymentTypeId = c.PaymentTypeId,CorporationId = c.CorporationId,TokenId = c.TokenId,IsActive = c.IsActive,Description = c.Description,CashChargeCodeType = c.CashChargeCodeType,SortOrder = c.SortOrder,ExcludeCreditCode = c.ExcludeCreditCodes,IsUpdated = c.IsUpdated,IsAdded = c.IsAdded,ClearUpdatedAndAdded = c.ClearUpdateAndAdded }; dataGridView_PaymentTypes.DataSource = query.ToList(); 我的课: private class DataBindingProjection { public Guid PaymentTypeId { get; set; } public Guid CorporationId { get; set; } public Guid TokenId { get; set; } public bool IsActive { get; set; } public string Description { get; set; } public int CashChargeCodeType { get; set; } public int SortOrder { get; set; } public int ExcludeCreditCode { get; set; } public bool IsUpdated { get; set; } public bool IsAdded { get; set; } public bool ClearUpdatedAndAdded { get; set; } } 在按钮中保存更改: private void button_SaveChanges2_Click(object sender,EventArgs e) { button_SaveChanges2.Enabled = false; _entities.SaveChanges(); timer1.Enabled = true; button_SaveChanges2.Enabled = true; } 我究竟做错了什么? 响应bmused: 定义在班级: private SuburbanPortalEntities _entities; 在我的负载中定义: var bs = new BindingSource(); _entities.PaymentTypes.Where(x => x.CorporationId == _currentcorp.CorporationId).Load; bs.DataSource = _entities.PaymentTypes.Local.ToBindingList(); dataGridView_PaymentTypes.DataSource = bs; 它显示它无法加载符号加载和本地: 解决方法
可以通过从DbContext Local ObservableCollection< T>创建IBindingList来实现具有Winforms和Entity Framework的双向数据绑定.并将其设置为BindingSource的DataSource.例:
private BindingSource bs = new BindingSource(); private MyDbContext context = new MyDbContext(); context.MyEntities.Where(x=>x.SomeProperty == 2).Load(); bs.DataSource = context.MyEntities.Local.ToBindingList(); myDataGridView.DataSource = bs; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |