How to effect the database with visual controls?

Yusif Wassal

Hello

I have a program for msaccess 2007 and VS 2010, every thing working correctly except saving the data to the database. by the way its reading correctly from the dbase

Here is the code:
Add new record:

private void button4_Click(object sender, EventArgs e)

{

f1.Text = "";

f2.Text = "";

newCustomersRow = pharmaDataSet.Tables["drugType"].NewRow();

newCustomersRow["DName"] = f1.Text.ToString();

newCustomersRow["Description"] = f2.Text.ToString();

pharmaDataSet.Tables["drugType"].Rows.Add(newCustomersRow);

drugTypeBindingSource.MoveLast();

DataGridViewDataErrorContexts cntxt = new DataGridViewDataErrorContexts();

dg.CommitEdit(cntxt);

drugTypeBindingSource.MoveLast();

f1.Text = "";

f2.Text = "";

}

Delete record:

private void button3_Click(object sender, EventArgs e)

{

try

{

drugTypeBindingSource.RemoveCurrent();

}

catch (Exception)

{

}

Save to DBase

private void button2_Click(object sender, EventArgs e)

{

this.Validate();

this.drugTypeBindingSource.EndEdit();

tableAdapterManager.UpdateAll(pharmaDataSet);

* drugTypeBindingSource.DataSource = pharmaDataSet.drugType;

dg.DataSource = drugTypeBindingSource;

drugTypeTableAdapter.Update(pharmaDataSet.drugType);

pharmaDataSet.drugType.AcceptChanges();

ActiveForm.Close();

// tableAdapterManager.UpdateAll(pharmaDataSet);

}

private void ff_TextChanged(object sender, EventArgs e)

{

try

{

// customerCreditBindingSource BindingSource myBindingSource;

//dg.DataSource = drugTypeBindingSource;

//drugTypeBindingSource.DataSource = pharmaDataSet;

//drugTypeBindingSource.DataMember = pharmaDataSet.Tables[2].TableName;

drugTypeBindingSource.Filter = "DName Like '" + ff.Text + "%'";

// button2.Visible = false;

// button4.Visible = false;

}

catch (Exception) { }

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Yusif Wassal14y ago
but it gives an error when I click button2 :

concurrency violation the updatecommand affected 0 of the expected 1 records

in the method updateAll
Yusif Wassal14y ago
it run o errors but does not effect the database
Nitesh Kejriwal14y ago
Does it throw any error message or it runs fine but does nothing?
Yusif Wassal14y ago
Sorry it looks like that:
newCustomersRow = pharmaDataSet.Tables["drugType"].NewRow();

newCustomersRow["DName"] = "sa"; // f1.Text;
newCustomersRow["Description"] = "sd"; // f2.Text;
pharmaDataSet.Tables["drugType"].Rows.Add(newCustomersRow);

pharmaDataSet.AcceptChanges();

drugTypeBindingSource.MoveLast();

but does not effect the database
Yusif Wassal14y ago
Hi again,

I add the method, so it ll looks like that:

// newCustomersRow = pharmaDataSet.Tables["drugType"].NewRow();

newCustomersRow["DName"] = "sa"; // f1.Text;
newCustomersRow["Description"] = "sd"; // f2.Text;
pharmaDataSet.Tables["drugType"].Rows.Add(newCustomersRow);

pharmaDataSet.AcceptChanges();

drugTypeBindingSource.MoveLast();

But has not affect also
Nitesh Kejriwal14y ago
You are adding a new record in button4_Click(). DO not find the AcceptChanges() there.
Yusif Wassal14y ago
I thought the following method affect it
pharmaDataSet.drugType.AcceptChanges();

if I am wrong then please tell me the correct method to commit the dbase
Nitesh Kejriwal14y ago
In your code, you are not committing changes to your dataset "pharmaDataSet" at any point of time. Please explain more if it is not correct