Commit Data with DataSet

Commit Data with DataSet

Postby tonydoval » Sun 03 Jun 2007 18:10

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
tonydoval
 
Posts: 7
Joined: Sun 03 Jun 2007 18:04

Postby Alexey » Mon 04 Jun 2007 07:33

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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby tonydoval » Mon 04 Jun 2007 09:23

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
tonydoval
 
Posts: 7
Joined: Sun 03 Jun 2007 18:04

Postby Alexey » Mon 04 Jun 2007 10:36

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.
Also specify the versions of OraDirect .NET and Oracle server you use.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby tonydoval » Mon 04 Jun 2007 11:11

OraDirect 4.0.13 and Oracle Server 10.2.0.3

Best regards
tonydoval
 
Posts: 7
Joined: Sun 03 Jun 2007 18:04

Postby Alexey » Mon 04 Jun 2007 11:33

Have you already sent me the test project?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle