filling a strongly typed dataset with data that contains a varray
Posted: Wed 04 Jan 2006 15:49
Hi
I have a strongly typed dataset that I would like to populate with some data using oradirect 3.01. The data contains a varray.
I have worked out how varrays work with vb.net (for those who dont already know):
You get a main table with a column that contains, instead of the varray, an autoincrement. You also get a child table called Table. For example if the column with a varray was called Readings, you would get a child table called TableReadings.
This table contains 2 columns, one has the same name as the table, and then other is just called 'Column1'. The first column contains the key from the parent table and the second column contains your actual array values. There is a relationship based on the columns mentioned above.
So my question is, how do I create that in a strongly typed dataset? I have tried duplicating the above, but I get the helpful error message saying it couldnt enable the constraints. Then I took the constraint between parent and child out, and now it says:
"Hierarchical chapter columns must map to an AutoIncrement DataColumn." google brings up no results. I have tried adding and removing keys to no avail.
The documentation is pretty poor regarding this, in fact generally I would say this product needs more documentation and examples. Can someone from corelab provide one please?
I would to use a regular .net dataset and table please.
Many thanks
Kevin
I have a strongly typed dataset that I would like to populate with some data using oradirect 3.01. The data contains a varray.
I have worked out how varrays work with vb.net (for those who dont already know):
You get a main table with a column that contains, instead of the varray, an autoincrement. You also get a child table called Table. For example if the column with a varray was called Readings, you would get a child table called TableReadings.
This table contains 2 columns, one has the same name as the table, and then other is just called 'Column1'. The first column contains the key from the parent table and the second column contains your actual array values. There is a relationship based on the columns mentioned above.
So my question is, how do I create that in a strongly typed dataset? I have tried duplicating the above, but I get the helpful error message saying it couldnt enable the constraints. Then I took the constraint between parent and child out, and now it says:
"Hierarchical chapter columns must map to an AutoIncrement DataColumn." google brings up no results. I have tried adding and removing keys to no avail.
The documentation is pretty poor regarding this, in fact generally I would say this product needs more documentation and examples. Can someone from corelab provide one please?
I would to use a regular .net dataset and table please.
Many thanks
Kevin