C＃的WinForms - 如何从DataGridView更新发送到数据库 [英] C# WinForms - how to send updates from DataGridView to DataBase
本文介绍了C＃的WinForms - 如何从DataGridView更新发送到数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个客户表和代理表中的.mdb文件。该代理表确实尚未唯一的是填充代理下拉为每一个客户...
我挂customerBindingSource一个DataGridView。该customerBindingSource有数据成员设置为客户和DataSource设置为bindingSource1。这有数据源设置为customerAppDS21。如果我选择customerAppDS21并单击DataSet设计器编辑，我可以很清楚地看到，有一个客户表和代理表。这些都是直接从Data.mdf>表文件夹拖动。我已经通过配置向导，并检查了更新，插入和删除命令正确生成。
我设置的唯一ID（GUID），当用户离开行或添加行（我不认为两者都是必要的，但我很怀疑这是问题的原因）。用户可以更新或添加的行数可能。当用户点击Save按钮调用 customerTableAdapter.Update（customerAppDS21.Customer）; 。所有事件都绝对正确接线。
问题基本上是DataSet中似乎得到更新的但数据库本身不会被更新。我可以关闭程序并重新加载它马上和数据是存在的。但是，如果我对代码做任何修改，然后重新编译和加载程序中的所有数据已经一去不复返了。这是什么让我觉得数据集被更新，但不是数据库。
有没有人有任何想法如何解决这个问题？我曾尝试添加 .acceptChanges（）; 行前和 .Update（BLA）后; 行，没有成功。我也打过电话 customerBindingSource.EndEdit（）; 和 bindingSource1.EndEdit（）; 在 .Update（BLA）; 行
任何帮助，将不胜感激。我现在已经有这个问题2天，并试图教程alsorts得到在哪里我错了提示。
问候，
理查德
更新：代码如下...
无效的button1_Click（对象发件人，EventArgs五）
{
验证（）;
customerBindingSource.EndEdit（）;
customerTableAdapter.Update（customerAppDS21.Customer）;
}
无效grdCustomers_RowLeave（对象发件人，DataGridViewCellEventArgs E）
{
的DataGridViewRow GVR = grdCustomers.Rows [e.RowIndex]
如果（gvr.Cells [0] .value的== NULL）
{
字符串G = Guid.NewGuid（）的ToString（）。
gvr.Cells [0] .value的=克;
}
，否则
{
字符串currID = gvr.Cells [0] .Value.ToString（）;
如果（currID.Equals（））
{
字符串G = Guid.NewGuid（）的ToString（）。
gvr.Cells [0] .value的=克;
}
}
}
无效grdCustomers_UserAddedRow（对象发件人，DataGridViewRowEventArgs E）
{
的DataGridViewRow GVR = grdCustomers.Rows [grdCustomers。了selectedCells [0] .RowIndex];
如果（gvr.Cells [0] .value的== NULL）
{
字符串G = Guid.NewGuid（）的ToString（）。
gvr.Cells [0] .value的=克;
}
，否则
{
字符串currID = gvr.Cells [0] .Value.ToString（）;
如果（currID.Equals（））
{
字符串G = Guid.NewGuid（）的ToString（）。
gvr.Cells [0] .value的=克;
}
}
}
设计代码（对不起其如此长 - 我不想冒险错过了什么重要）：
命名空间CustomerApp
{
部分类CustomerAppForm
{
///<总结>
///必需的设计变量。
///< /总结>
私人System.ComponentModel.IContainer成分= NULL;
///<总结>使用
///清理的任何资源。
///< /总结>
///< PARAM NAME =处理>真要是托管资源应释放;否则为false< /参数>
保护覆盖无效的Dispose（BOOL处置）
{
如果（处置和放大器;及（成分= NULL）！）
{
components.Dispose（）;
}
base.Dispose（处置）;
}
#region Windows窗体设计器生成的代码
///<总结>
///设计器支持所需的方法 - 不要修改
///此方法的代码编辑器的内容。
///< /总结>
私人无效的InitializeComponent（）
{
this.components =新System.ComponentModel.Container（）;
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 =新System.Windows.Forms.DataGridViewCellStyle（）;
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 =新System.Windows.Forms.DataGridViewCellStyle（）;
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 =新System.Windows.Forms.DataGridViewCellStyle（）;
this.tabControl1 =新System.Windows.Forms.TabControl（）;
this.tabPage1 =新System.Windows.Forms.TabPage（）;
this.button1 =新System.Windows.Forms.Button（）;
this.grdCustomers =新System.Windows.Forms.DataGridView（）;
this.agentBindingSource =新System.Windows.Forms.BindingSource（this.components）;
this.bindingSource1 =新System.Windows.Forms.BindingSource（this.components）;
this.customerAppDS21 =新CustomerApp.CustomerAppDS2（）;
this.tabPage2 =新System.Windows.Forms.TabPage（）;
this.customerTableAdapter =新CustomerApp.CustomerAppDS2TableAdapters.CustomerTableAdapter（）;
this.agentTableAdapter =新CustomerApp.CustomerAppDS2TableAdapters.AgentTableAdapter（）;
this.customerBindingSource =新System.Windows.Forms.BindingSource（this.components）;
this.idDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.companynameDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.contactforenameDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.contactsurnameDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.companyaddress1DataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.companyaddress2DataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.companytownDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.companycountyDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.companypostcodeDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.contacttelephoneDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.contactfaxDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.contactemailDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.agentIDDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewComboBoxColumn（）;
this.contactfullnameDataGridViewTextBoxColumn =新System.Windows.Forms.DataGridViewTextBoxColumn（）;
this.tabControl1.SuspendLayout（）;
this.tabPage1.SuspendLayout（）;
（（System.ComponentModel.ISupportInitialize）（this.grdCustomers））BeginInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.agentBindingSource））BeginInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.bindingSource1））BeginInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.customerAppDS21））BeginInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.customerBindingSource））BeginInit在（）;
this.SuspendLayout（）;
//
// tabControl1
//
this.tabControl1.Controls.Add（this.tabPage1）;
this.tabControl1.Controls.Add（this.tabPage2）;
this.tabControl1.Location =新System.Drawing.Point（12，12）;
this.tabControl1.Name =tabControl1;
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size =新System.Drawing.Size（1000，640）;
this.tabControl1.TabIndex = 0;
//
// tabPage1
//
this.tabPage1.Controls.Add（this.button1）;
this.tabPage1.Controls.Add（this.grdCustomers）;
this.tabPage1.Location =新System.Drawing.Point（4,22）;
this.tabPage1.Name =tabPage1;
this.tabPage1.Padding =新System.Windows.Forms.Padding（3）;
this.tabPage1.Size =新System.Drawing.Size（992，614）;
this.tabPage1.TabIndex = 0;
this.tabPage1.Text =客户;
this.tabPage1.UseVisualStyleBackColor = TRUE;
//
//按钮1
//
this.button1.Location =新System.Drawing.Point（882，462）;
this.button1.Name =Button1的;
this.button1.Size =新System.Drawing.Size（75，23）;
this.button1.TabIndex = 1;
this.button1.Text =保存;
this.button1.UseVisualStyleBackColor = TRUE;
//
// grdCustomers
//
this.grdCustomers.AllowUserToOrderColumns = TRUE;
this.grdCustomers.AutoGenerateColumns = FALSE;
dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle1.Font =新System.Drawing.Font（Microsoft无衬线」，8.25F，System.Drawing.FontStyle.Regular，System.Drawing.GraphicsUnit.Point，（（字节）（0）））;
dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
this.grdCustomers.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
this.grdCustomers.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.grdCustomers.Columns.AddRange（新System.Windows.Forms.DataGridViewColumn [] {
this.idDataGridViewTextBoxColumn，
this.companynameDataGridViewTextBoxColumn，
this.contactforenameDataGridViewTextBoxColumn，
this.contactsurnameDataGridViewTextBoxColumn，
this.companyaddress1DataGridViewTextBoxColumn，
this.companyaddress2DataGridViewTextBoxColumn，
this.companytownDataGridViewTextBoxColumn，
this.companycountyDataGridViewTextBoxColumn，
this.companypostcodeDataGridViewTextBoxColumn，
本.contacttelephoneDataGridViewTextBoxColumn，
this.contactfaxDataGridViewTextBoxColumn，
this.contactemailDataGridViewTextBoxColumn，
this.agentIDDataGridViewTextBoxColumn，
this.contactfullnameDataGridViewTextBoxColumn}）;
this.grdCustomers.DataSource = this.customerBindingSource;
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle2.Font =新System.Drawing.Font（Microsoft无衬线」，8.25F，System.Drawing.FontStyle.Regular，System.Drawing.GraphicsUnit.Point，（（字节）（0）））;
dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
this.grdCustomers.DefaultCellStyle = dataGridViewCellStyle2;
this.grdCustomers.Location =新System.Drawing.Point（3，3）;
this.grdCustomers.Name =grdCustomers;
dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle3.Font =新System.Drawing.Font（Microsoft无衬线」，8.25F，System.Drawing.FontStyle.Regular，System.Drawing.GraphicsUnit.Point，（（字节）（0）））;
dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
this.grdCustomers.RowHeadersDefaultCellStyle = dataGridViewCellStyle3;
this.grdCustomers.RowTemplate.DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb（（（int）的（（（字节）（255）））），（（int）的（（（字节）（255） ））），（（int）的（（（字节）（192）））））;
this.grdCustomers.RowTemplate.DefaultCellStyle.Padding =新System.Windows.Forms.Padding（2）;
this.grdCustomers.RowTemplate.DefaultCellStyle.SelectionBackColor = System.Drawing.Color.FromArgb（（（int）的（（（字节）（255）））），（（int）的（（（字节）（224） ））），（（int）的（（（字节）（192）））））;
this.grdCustomers.Size =新System.Drawing.Size（983，605）;
this.grdCustomers.TabIndex = 0;
//
// agentBindingSource
//
this.agentBindingSource.DataMember =代理人;
this.agentBindingSource.DataSource = this.bindingSource1;
//
// bindingSource1
//
this.bindingSource1.AllowNew = TRUE;
this.bindingSource1.DataSource = this.customerAppDS21;
this.bindingSource1.Position = 0;
//
// customerAppDS21
//
this.customerAppDS21.DataSetName =CustomerAppDS2;
this.customerAppDS21.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// tabPage2
//
this.tabPage2.Location =新System.Drawing.Point（4,22）;
this.tabPage2.Name =tabPage2;
this.tabPage2.Padding =新System.Windows.Forms.Padding（3）;
this.tabPage2.Size =新System.Drawing.Size（992，614）;
this.tabPage2.TabIndex = 1;
this.tabPage2.Text =代理人;
this.tabPage2.UseVisualStyleBackColor = TRUE;
//
// customerTableAdapter
//
this.customerTableAdapter.ClearBeforeFill = TRUE;
//
// agentTableAdapter
//
this.agentTableAdapter.ClearBeforeFill = TRUE;
//
// customerBindingSource
//
this.customerBindingSource.DataMember =客户;
this.customerBindingSource.DataSource = this.bindingSource1;
//
// idDataGridViewTextBoxColumn
//
this.idDataGridViewTextBoxColumn.DataPropertyName =ID;
this.idDataGridViewTextBoxColumn.HeaderText =ID;
this.idDataGridViewTextBoxColumn.Name =idDataGridViewTextBoxColumn;
this.idDataGridViewTextBoxColumn.ReadOnly = TRUE;
//
// companynameDataGridViewTextBoxColumn
//
this.companynameDataGridViewTextBoxColumn.DataPropertyName =COMPANY_NAME;
this.companynameDataGridViewTextBoxColumn.HeaderText =公司名称;
this.companynameDataGridViewTextBoxColumn.Name =companynameDataGridViewTextBoxColumn;
this.companynameDataGridViewTextBoxColumn.ToolTipText =该公司的名称;
//
// contactforenameDataGridViewTextBoxColumn
//
this.contactforenameDataGridViewTextBoxColumn.DataPropertyName =contact_forename;
this.contactforenameDataGridViewTextBoxColumn.HeaderText =联系用的名字;
this.contactforenameDataGridViewTextBoxColumn.Name =contactforenameDataGridViewTextBoxColumn;
//
// contactsurnameDataGridViewTextBoxColumn
//
this.contactsurnameDataGridViewTextBoxColumn.DataPropertyName =contact_surname;
this.contactsurnameDataGridViewTextBoxColumn.HeaderText =跟姓;
this.contactsurnameDataGridViewTextBoxColumn.Name =contactsurnameDataGridViewTextBoxColumn;
//
// companyaddress1DataGridViewTextBoxColumn
//
this.companyaddress1DataGridViewTextBoxColumn.DataPropertyName =company_address1;
this.companyaddress1DataGridViewTextBoxColumn.HeaderText =地址1;
this.companyaddress1DataGridViewTextBoxColumn.Name =companyaddress1DataGridViewTextBoxColumn;
//
// companyaddress2DataGridViewTextBoxColumn
//
this.companyaddress2DataGridViewTextBoxColumn.DataPropertyName =company_address2;
this.companyaddress2DataGridViewTextBoxColumn.HeaderText =2的地址;
this.companyaddress2DataGridViewTextBoxColumn.Name =companyaddress2DataGridViewTextBoxColumn;
//
// companytownDataGridViewTextBoxColumn
//
this.companytownDataGridViewTextBoxColumn.DataPropertyName =company_town;
this.companytownDataGridViewTextBoxColumn.HeaderText =城;
this.companytownDataGridViewTextBoxColumn.Name =companytownDataGridViewTextBoxColumn;
//
// companycountyDataGridViewTextBoxColumn
//
this.companycountyDataGridViewTextBoxColumn.DataPropertyName =company_county;
this.companycountyDataGridViewTextBoxColumn.HeaderText =县;
this.companycountyDataGridViewTextBoxColumn.Name =companycountyDataGridViewTextBoxColumn;
//
// companypostcodeDataGridViewTextBoxColumn
//
this.companypostcodeDataGridViewTextBoxColumn.DataPropertyName =company_postcode;
this.companypostcodeDataGridViewTextBoxColumn.HeaderText =邮编
this.companypostcodeDataGridViewTextBoxColumn.Name =companypostcodeDataGridViewTextBoxColumn;
//
// contacttelephoneDataGridViewTextBoxColumn
//
this.contacttelephoneDataGridViewTextBoxColumn.DataPropertyName =contact_telephone;
this.contacttelephoneDataGridViewTextBoxColumn.HeaderText =电话;
this.contacttelephoneDataGridViewTextBoxColumn.Name =contacttelephoneDataGridViewTextBoxColumn;
//
// contactfaxDataGridViewTextBoxColumn
//
this.contactfaxDataGridViewTextBoxColumn.DataPropertyName =contact_fax;
this.contactfaxDataGridViewTextBoxColumn.HeaderText =传真;
this.contactfaxDataGridViewTextBoxColumn.Name =contactfaxDataGridViewTextBoxColumn;
//
// contactemailDataGridViewTextBoxColumn
//
this.contactemailDataGridViewTextBoxColumn.DataPropertyName =CONTACT_EMAIL;
this.contactemailDataGridViewTextBoxColumn.HeaderText =电子邮件;
this.contactemailDataGridViewTextBoxColumn.Name =contactemailDataGridViewTextBoxColumn;
//
// agentIDDataGridViewTextBoxColumn
//
this.agentIDDataGridViewTextBoxColumn.DataPropertyName =AGENTID;
this.agentIDDataGridViewTextBoxColumn.DataSource = this.agentBindingSource;
this.agentIDDataGridViewTextBoxColumn.DisplayMember =contact_fullname;
this.agentIDDataGridViewTextBoxColumn.HeaderText =AGENTID;
this.agentIDDataGridViewTextBoxColumn.Name =agentIDDataGridViewTextBoxColumn;
this.agentIDDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.agentIDDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.agentIDDataGridViewTextBoxColumn.ValueMember =ID;
//
// contactfullnameDataGridViewTextBoxColumn
//
this.contactfullnameDataGridViewTextBoxColumn.DataPropertyName =contact_fullname;
this.contactfullnameDataGridViewTextBoxColumn.HeaderText =contact_fullname;
this.contactfullnameDataGridViewTextBoxColumn.Name =contactfullnameDataGridViewTextBoxColumn;
this.contactfullnameDataGridViewTextBoxColumn.ReadOnly = TRUE;
this.contactfullnameDataGridViewTextBoxColumn.Visible = FALSE;
//
// CustomerAppForm
//
this.AutoScaleDimensions =新System.Drawing.SizeF（6F，13F）;
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize =新System.Drawing.Size（1184，662）;
this.Controls.Add（this.tabControl1）;
this.Location =新System.Drawing.Point（100，100）;
this.Name =CustomerAppForm;
this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
this.Text =文物艺术纸有限公司 - 客户申请;
this.Load + =新System.EventHandler（this.CustomerAppForm_Load）;
this.tabControl1.ResumeLayout（假）;
this.tabPage1.ResumeLayout（假）;
（（System.ComponentModel.ISupportInitialize）（this.grdCustomers））EndInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.agentBindingSource））EndInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.bindingSource1））EndInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.customerAppDS21））EndInit在（）;
（（System.ComponentModel.ISupportInitialize）（this.customerBindingSource））EndInit在（）;
this.ResumeLayout（假）;
}
#endregion
私人System.Windows.Forms.TabControl tabControl1;
私人System.Windows.Forms.TabPage tabPage1;
私人System.Windows.Forms.TabPage tabPage2;
私人System.Windows.Forms.BindingSource bindingSource1;
私人CustomerAppDS2 customerAppDS21;
私人System.Windows.Forms.BindingSource agentBindingSource;
私人CustomerAppDS2TableAdapters.CustomerTableAdapter customerTableAdapter;
私人CustomerAppDS2TableAdapters.AgentTableAdapter agentTableAdapter;
私人System.Windows.Forms.Button按钮1;
私人System.Windows.Forms.BindingSource customerBindingSource;
私人System.Windows.Forms.DataGridViewTextBoxColumn idDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn companynameDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn contactforenameDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn contactsurnameDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn companyaddress1DataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn companyaddress2DataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn companytownDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn companycountyDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn companypostcodeDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn contacttelephoneDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn contactfaxDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn contactemailDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewComboBoxColumn agentIDDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridViewTextBoxColumn contactfullnameDataGridViewTextBoxColumn;
私人System.Windows.Forms.DataGridView grdCustomers;
}
}
解决方案
我想这可能是你的问题。仔细阅读这两篇文章。第一个包含其中的第二连杆（Ⅰ下面给出）建议线程
http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic58794.aspx
和
的 http://msdn.microsoft.com/en-us/library/ms246989.aspx
在第一个环节，阅读的答案：克里穆尔曼
I have a .mdb file with a Customers table and an Agents table. The only thing that the Agents table does as yet is populate the Agent dropdown for each customer...
I have a DataGridView linked to the customerBindingSource. The customerBindingSource has DataMember set to Customer and DataSource set to bindingSource1. This has the DataSource set to customerAppDS21. If I select customerAppDS21 and click Edit in DataSet Designer I can quite clearly see that there is a Customer table and Agent table. These were dragged directly from the Data.mdf > Tables folder. I have been through the Configure wizard and checked that the Update, Insert and Delete commands are generated correctly.
I am setting the unique ID (GUID) when the user leaves a row or adds a row (I dont think both are needed, but I very much doubt this is the cause of the problem). The user can update or add as many rows as possible. When the user clicks the Save button it calls customerTableAdapter.Update(customerAppDS21.Customer);. All the events are definitely wired up correctly.
The problem is basically that the DataSet appears to get updated but the database itself is not updated. I can close the program and reload it straight away and the data is there. However if I make any changes to the code and then recompile and load the program all the data is gone. This is what makes me think the DataSet is being updated but not the database.
Does anyone have any idea how to solve the problem? I have tried adding the .acceptChanges(); line both before and after the .Update(bla); line, with no success. I have also tried calling customerBindingSource.EndEdit(); and bindingSource1.EndEdit(); before the .Update(bla); line.
Any help with this would be greatly appreciated. I have had this problem for 2 days now and tried alsorts of tutorials to get a hint on where I am going wrong.
Regards,
Richard
Update: Code below...
void button1_Click(object sender, EventArgs e)
{
Validate();
customerBindingSource.EndEdit();
customerTableAdapter.Update(customerAppDS21.Customer);
}
void grdCustomers_RowLeave(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow gvr = grdCustomers.Rows[e.RowIndex];
if (gvr.Cells[0].Value == null)
{
String g = Guid.NewGuid().ToString();
gvr.Cells[0].Value = g;
}
else
{
String currID = gvr.Cells[0].Value.ToString();
if (currID.Equals(""))
{
String g = Guid.NewGuid().ToString();
gvr.Cells[0].Value = g;
}
}
}
void grdCustomers_UserAddedRow(object sender, DataGridViewRowEventArgs e)
{
DataGridViewRow gvr = grdCustomers.Rows[grdCustomers.SelectedCells[0].RowIndex];
if (gvr.Cells[0].Value == null)
{
String g = Guid.NewGuid().ToString();
gvr.Cells[0].Value = g;
}
else
{
String currID = gvr.Cells[0].Value.ToString();
if (currID.Equals(""))
{
String g = Guid.NewGuid().ToString();
gvr.Cells[0].Value = g;
}
}
}
Designer code (sorry its so long - I dont want to risk missing out anything vital):
namespace CustomerApp
{
partial class CustomerAppForm
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.button1 = new System.Windows.Forms.Button();
this.grdCustomers = new System.Windows.Forms.DataGridView();
this.agentBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.bindingSource1 = new System.Windows.Forms.BindingSource(this.components);
this.customerAppDS21 = new CustomerApp.CustomerAppDS2();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.customerTableAdapter = new CustomerApp.CustomerAppDS2TableAdapters.CustomerTableAdapter();
this.agentTableAdapter = new CustomerApp.CustomerAppDS2TableAdapters.AgentTableAdapter();
this.customerBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.idDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.companynameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contactforenameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contactsurnameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.companyaddress1DataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.companyaddress2DataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.companytownDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.companycountyDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.companypostcodeDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contacttelephoneDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contactfaxDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.contactemailDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.agentIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.contactfullnameDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.tabControl1.SuspendLayout();
this.tabPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.grdCustomers)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.agentBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.customerAppDS21)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.customerBindingSource)).BeginInit();
this.SuspendLayout();
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Location = new System.Drawing.Point(12, 12);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(1000, 640);
this.tabControl1.TabIndex = 0;
//
// tabPage1
//
this.tabPage1.Controls.Add(this.button1);
this.tabPage1.Controls.Add(this.grdCustomers);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(992, 614);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "Customers";
this.tabPage1.UseVisualStyleBackColor = true;
//
// button1
//
this.button1.Location = new System.Drawing.Point(882, 462);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(75, 23);
this.button1.TabIndex = 1;
this.button1.Text = "Save";
this.button1.UseVisualStyleBackColor = true;
//
// grdCustomers
//
this.grdCustomers.AllowUserToOrderColumns = true;
this.grdCustomers.AutoGenerateColumns = false;
dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
this.grdCustomers.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
this.grdCustomers.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.grdCustomers.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.idDataGridViewTextBoxColumn,
this.companynameDataGridViewTextBoxColumn,
this.contactforenameDataGridViewTextBoxColumn,
this.contactsurnameDataGridViewTextBoxColumn,
this.companyaddress1DataGridViewTextBoxColumn,
this.companyaddress2DataGridViewTextBoxColumn,
this.companytownDataGridViewTextBoxColumn,
this.companycountyDataGridViewTextBoxColumn,
this.companypostcodeDataGridViewTextBoxColumn,
this.contacttelephoneDataGridViewTextBoxColumn,
this.contactfaxDataGridViewTextBoxColumn,
this.contactemailDataGridViewTextBoxColumn,
this.agentIDDataGridViewTextBoxColumn,
this.contactfullnameDataGridViewTextBoxColumn});
this.grdCustomers.DataSource = this.customerBindingSource;
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
this.grdCustomers.DefaultCellStyle = dataGridViewCellStyle2;
this.grdCustomers.Location = new System.Drawing.Point(3, 3);
this.grdCustomers.Name = "grdCustomers";
dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
this.grdCustomers.RowHeadersDefaultCellStyle = dataGridViewCellStyle3;
this.grdCustomers.RowTemplate.DefaultCellStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
this.grdCustomers.RowTemplate.DefaultCellStyle.Padding = new System.Windows.Forms.Padding(2);
this.grdCustomers.RowTemplate.DefaultCellStyle.SelectionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192)))));
this.grdCustomers.Size = new System.Drawing.Size(983, 605);
this.grdCustomers.TabIndex = 0;
//
// agentBindingSource
//
this.agentBindingSource.DataMember = "Agent";
this.agentBindingSource.DataSource = this.bindingSource1;
//
// bindingSource1
//
this.bindingSource1.AllowNew = true;
this.bindingSource1.DataSource = this.customerAppDS21;
this.bindingSource1.Position = 0;
//
// customerAppDS21
//
this.customerAppDS21.DataSetName = "CustomerAppDS2";
this.customerAppDS21.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// tabPage2
//
this.tabPage2.Location = new System.Drawing.Point(4, 22);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(992, 614);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "Agents";
this.tabPage2.UseVisualStyleBackColor = true;
//
// customerTableAdapter
//
this.customerTableAdapter.ClearBeforeFill = true;
//
// agentTableAdapter
//
this.agentTableAdapter.ClearBeforeFill = true;
//
// customerBindingSource
//
this.customerBindingSource.DataMember = "Customer";
this.customerBindingSource.DataSource = this.bindingSource1;
//
// idDataGridViewTextBoxColumn
//
this.idDataGridViewTextBoxColumn.DataPropertyName = "id";
this.idDataGridViewTextBoxColumn.HeaderText = "id";
this.idDataGridViewTextBoxColumn.Name = "idDataGridViewTextBoxColumn";
this.idDataGridViewTextBoxColumn.ReadOnly = true;
//
// companynameDataGridViewTextBoxColumn
//
this.companynameDataGridViewTextBoxColumn.DataPropertyName = "company_name";
this.companynameDataGridViewTextBoxColumn.HeaderText = "Company Name";
this.companynameDataGridViewTextBoxColumn.Name = "companynameDataGridViewTextBoxColumn";
this.companynameDataGridViewTextBoxColumn.ToolTipText = "The name of the company";
//
// contactforenameDataGridViewTextBoxColumn
//
this.contactforenameDataGridViewTextBoxColumn.DataPropertyName = "contact_forename";
this.contactforenameDataGridViewTextBoxColumn.HeaderText = "Contact Forename";
this.contactforenameDataGridViewTextBoxColumn.Name = "contactforenameDataGridViewTextBoxColumn";
//
// contactsurnameDataGridViewTextBoxColumn
//
this.contactsurnameDataGridViewTextBoxColumn.DataPropertyName = "contact_surname";
this.contactsurnameDataGridViewTextBoxColumn.HeaderText = "Contact Surname";
this.contactsurnameDataGridViewTextBoxColumn.Name = "contactsurnameDataGridViewTextBoxColumn";
//
// companyaddress1DataGridViewTextBoxColumn
//
this.companyaddress1DataGridViewTextBoxColumn.DataPropertyName = "company_address1";
this.companyaddress1DataGridViewTextBoxColumn.HeaderText = "Address 1";
this.companyaddress1DataGridViewTextBoxColumn.Name = "companyaddress1DataGridViewTextBoxColumn";
//
// companyaddress2DataGridViewTextBoxColumn
//
this.companyaddress2DataGridViewTextBoxColumn.DataPropertyName = "company_address2";
this.companyaddress2DataGridViewTextBoxColumn.HeaderText = "Address 2";
this.companyaddress2DataGridViewTextBoxColumn.Name = "companyaddress2DataGridViewTextBoxColumn";
//
// companytownDataGridViewTextBoxColumn
//
this.companytownDataGridViewTextBoxColumn.DataPropertyName = "company_town";
this.companytownDataGridViewTextBoxColumn.HeaderText = "Town";
this.companytownDataGridViewTextBoxColumn.Name = "companytownDataGridViewTextBoxColumn";
//
// companycountyDataGridViewTextBoxColumn
//
this.companycountyDataGridViewTextBoxColumn.DataPropertyName = "company_county";
this.companycountyDataGridViewTextBoxColumn.HeaderText = "County";
this.companycountyDataGridViewTextBoxColumn.Name = "companycountyDataGridViewTextBoxColumn";
//
// companypostcodeDataGridViewTextBoxColumn
//
this.companypostcodeDataGridViewTextBoxColumn.DataPropertyName = "company_postcode";
this.companypostcodeDataGridViewTextBoxColumn.HeaderText = "Postcode";
this.companypostcodeDataGridViewTextBoxColumn.Name = "companypostcodeDataGridViewTextBoxColumn";
//
// contacttelephoneDataGridViewTextBoxColumn
//
this.contacttelephoneDataGridViewTextBoxColumn.DataPropertyName = "contact_telephone";
this.contacttelephoneDataGridViewTextBoxColumn.HeaderText = "Telephone";
this.contacttelephoneDataGridViewTextBoxColumn.Name = "contacttelephoneDataGridViewTextBoxColumn";
//
// contactfaxDataGridViewTextBoxColumn
//
this.contactfaxDataGridViewTextBoxColumn.DataPropertyName = "contact_fax";
this.contactfaxDataGridViewTextBoxColumn.HeaderText = "Fax";
this.contactfaxDataGridViewTextBoxColumn.Name = "contactfaxDataGridViewTextBoxColumn";
//
// contactemailDataGridViewTextBoxColumn
//
this.contactemailDataGridViewTextBoxColumn.DataPropertyName = "contact_email";
this.contactemailDataGridViewTextBoxColumn.HeaderText = "Email";
this.contactemailDataGridViewTextBoxColumn.Name = "contactemailDataGridViewTextBoxColumn";
//
// agentIDDataGridViewTextBoxColumn
//
this.agentIDDataGridViewTextBoxColumn.DataPropertyName = "agentID";
this.agentIDDataGridViewTextBoxColumn.DataSource = this.agentBindingSource;
this.agentIDDataGridViewTextBoxColumn.DisplayMember = "contact_fullname";
this.agentIDDataGridViewTextBoxColumn.HeaderText = "agentID";
this.agentIDDataGridViewTextBoxColumn.Name = "agentIDDataGridViewTextBoxColumn";
this.agentIDDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.agentIDDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.agentIDDataGridViewTextBoxColumn.ValueMember = "id";
//
// contactfullnameDataGridViewTextBoxColumn
//
this.contactfullnameDataGridViewTextBoxColumn.DataPropertyName = "contact_fullname";
this.contactfullnameDataGridViewTextBoxColumn.HeaderText = "contact_fullname";
this.contactfullnameDataGridViewTextBoxColumn.Name = "contactfullnameDataGridViewTextBoxColumn";
this.contactfullnameDataGridViewTextBoxColumn.ReadOnly = true;
this.contactfullnameDataGridViewTextBoxColumn.Visible = false;
//
// CustomerAppForm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1184, 662);
this.Controls.Add(this.tabControl1);
this.Location = new System.Drawing.Point(100, 100);
this.Name = "CustomerAppForm";
this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
this.Text = "Heritage Art Papers Ltd - Customer Application";
this.Load += new System.EventHandler(this.CustomerAppForm_Load);
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.grdCustomers)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.agentBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.customerAppDS21)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.customerBindingSource)).EndInit();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.TabControl tabControl1;
private System.Windows.Forms.TabPage tabPage1;
private System.Windows.Forms.TabPage tabPage2;
private System.Windows.Forms.BindingSource bindingSource1;
private CustomerAppDS2 customerAppDS21;
private System.Windows.Forms.BindingSource agentBindingSource;
private CustomerAppDS2TableAdapters.CustomerTableAdapter customerTableAdapter;
private CustomerAppDS2TableAdapters.AgentTableAdapter agentTableAdapter;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.BindingSource customerBindingSource;
private System.Windows.Forms.DataGridViewTextBoxColumn idDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn companynameDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn contactforenameDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn contactsurnameDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn companyaddress1DataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn companyaddress2DataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn companytownDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn companycountyDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn companypostcodeDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn contacttelephoneDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn contactfaxDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn contactemailDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewComboBoxColumn agentIDDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridViewTextBoxColumn contactfullnameDataGridViewTextBoxColumn;
private System.Windows.Forms.DataGridView grdCustomers;
}
}
解决方案
I guess this might be your problem. Read these two articles very carefully. The first one contains a thread where in the second link (I gave below) is suggested.
http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic58794.aspx
and
http://msdn.microsoft.com/en-us/library/ms246989.aspx
In the first link, read the answer of: Kerry Moorman.
这篇关于C＃的WinForms - 如何从DataGridView更新发送到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
