Filling DataSet with OracleDataAdapter - VARRAY in table!

Filling DataSet with OracleDataAdapter - VARRAY in table!

Postby ABeam » Wed 29 Jun 2005 10:13

Hi!

I want to display the content of a table in a DataGrid, so I fill the underlaying DataSet with an OracleDataAdapter using the Fill() method.
That table contains a custom VARRAY row which I need to access and display as well.
Right now, that row is displayed but just with a "0" in it.

Any idea how to display all the components of that VARRAY in the table so that I can display and update every single component?

Your help is greatly appreciated!

Best regards,

Andreas (using OraDirect .NET 2.50 Prof. with VC++ .net 2003)
ABeam
 

Postby Paul » Mon 04 Jul 2005 09:34

VARRAY is passed as IDataReader type to DataGrid. You can see it as a link to the nested table if DataGrid.AllowNavigation=true. You cannot edit VARRAY in DataGrid with OraDirect .NET 2.50.

You can display and edit VARRAY in DataGrid with OraDirect .NET 3.0. This is possible if you use OracleDataTable component. Please see ObjectView demo project in OraDirect .NET 3.0.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Thx for the help!

Postby ABeam » Wed 06 Jul 2005 10:07

Hi Paul!

Thx for the hint! I'll ask my boss to get me the newest version. I guess you'll like that idea... :wink:

With best regards,

Andreas
ABeam
 


Return to dotConnect for Oracle