-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: JayakumarJ
Message 1 in Discussion
Hi, From my C# form I need to insert/update/delete the records in MS Access. I am
using oleDbDataAdapter,oleDbConnection and DataSet. Dataset is binded wiht the
datagrid. Insert,Delete and Update commands are wizard generated. When I am trying to
Delete and update I am getting DBConcurrencyException. The update code looks like
below.
try
{
DataSet temp;
//ds dataset
temp = ds.GetChanges();
if (ds.HasChanges(DataRowState.Deleted))
{
oleDbDataAdapter1.Update(temp.Tables["Consultants"].Select(null, null,
DataViewRowState.Deleted));
}
if (ds.HasChanges(DataRowState.Modified))
{
oleDbDataAdapter1.Update(temp.Tables["Consultants"].Select(null, null,
DataViewRowState.ModifiedCurrent));
}
if (ds.HasChanges(DataRowState.Added))
oleDbDataAdapter1.Update(temp.Tables["Consultants"].Select(null, null,
DataViewRowState.Added));
ds.AcceptChanges();
}
catch(SystemException ex){}
If anyone knows Let me know where I am wrong.
Thanks,
Jayakumar
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
