Filling DataSet with OracleDataAdapter - VARRAY in table!

[ABeam]

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)

[Paul]

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.

[ABeam]

Hi Paul!

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

With best regards,

Andreas