无法通过XSD架构更新数据库 [英] Unable to update DB through XSD schema

问题描述

大家好.

我有一个小问题.在我的应用程序中，我具有项目中包含的访问数据库.另外，我创建了一个包含2个相关表的xsd方案.我有绑定到xsd dataSet的dataDridView.问题是当我尝试将更改的行保存在gridView中时.更改的行不会影响到数据库.

Hi Everybody.

I have a little problem. In my application I have access db included in project. Also, I created an xsd scheme with 2 related tables. I have dataDridView that is binded to xsd dataSet. Problem is when I try to save changed rows in gridView. Changed rows are not affected to db.

private void button1_Click(object sender, EventArgs e)
{            
      regionsBindingSource.EndEdit();            
      regionsTableAdapter.Update(mdlocationsDataSet.regions);  
      mdlocationsDataSet.AcceptChanges();         
}

感谢您的进步.

Thanks for advance.

推荐答案

我使用的网格版本略有不同，但也许您也可以使用它:

对于网格(数据源= mdlocationsDataSet和datamember =区域)，我只需运行update命令即可.

对于多个控件(组合键)，我正在使用类似

this.BindingContext [mdlocationsDataSet.regions] .EndCurrentEdit();
regionsTableAdapter.Update(mdlocationsDataSet.regions);

如果您的行状态为修改"，则最终在更新命令之前进行测试

I''m using a bit different version of grid,but maybe you can use it too:

for a grid (with datasource = mdlocationsDataSet & datamember = regions) I just run the update command and it works.

for multiple controls (combos) I''m using something like

this.BindingContext[mdlocationsDataSet.regions].EndCurrentEdit();
regionsTableAdapter.Update(mdlocationsDataSet.regions);

Eventualy test before update command if your rows state is "modified"

这篇关于无法通过XSD架构更新数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！