Hi,
I have a bindingsource, a OracleDataSet, and a connection.
I tried to update records with Autocommit = true or autocommit = false but I never get to make changes in DB.
Please help me.
Best regards
Commit Data with DataSet
Hi,
I make a few tests.
If I use a DataSet with tableadapter works perfectly but only works in the main class.
Example.
I have a form that it's derived from a base class that have the BindingSource, a base Dataset and the connection.
If I assing the bindingsource, connection and use the DataSet generated by Corelab tools works ok.
But if i try to use a generic dataset dont works.
Example:
In Derived form:
On load form:
this.oraDataSet = dataSetMenus1;
Assing Form dataset to base dataset.
On base form on button commit
this.bSource.EndEdit();
this.oraDataSet.Update();
this.oraDataSet.AcceptChanges();
this.oraConnection.Commit();
This way don't works because oraDataset.HasChanges() returns allways false.
Best regards
I make a few tests.
If I use a DataSet with tableadapter works perfectly but only works in the main class.
Example.
I have a form that it's derived from a base class that have the BindingSource, a base Dataset and the connection.
If I assing the bindingsource, connection and use the DataSet generated by Corelab tools works ok.
But if i try to use a generic dataset dont works.
Example:
In Derived form:
On load form:
this.oraDataSet = dataSetMenus1;
Assing Form dataset to base dataset.
On base form on button commit
this.bSource.EndEdit();
this.oraDataSet.Update();
this.oraDataSet.AcceptChanges();
this.oraConnection.Commit();
This way don't works because oraDataset.HasChanges() returns allways false.
Best regards
Also specify the versions of OraDirect .NET and Oracle server you use.Alexey wrote:Please send me small test project to reproduce the problem.
It is desirable to use 'scott' schema objects, otherwise include the definitions of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third-party components.