Hello.
I need to build a primary key (DataTable.primaryKey) programmatically,
but it has more then one column.
I didn't find any method for doing that.

How can I do that ?

Thanks

Am 08.07.2010 17:26, schrieb Mr. X.:
The type of DataTable.primaryKey is an array. An array can contain
more items.

--
Armin

Yes, I know.

but I did something like this :
myTable.PrimaryKey = New DataColumn() {}
myTable.PrimaryKey.SetValue(New DataColumn("aKey"), 0)

.... and I get out of bounds on the second line.
What is the correct syntax?

Thanks


"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote

Am 08.07.2010 19:53, schrieb Mr. X.:
myTable.PrimaryKey = New DataColumn() {firstcolumn, secondcolumn}

Otherwise you assign an empty erray and SetValue fails because
there is no space in the array.

--
Armin

I don't know how much columns will be on first time, and I want dynamically
to change it (I don't know if there are two, or ten,
so {firstColumn, secondColumn} may not be the best solution.

Thanks

"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote

Am 08.07.2010 22:24, schrieb Mr. X.:
You can always assign a new array to the PrimaryKey property.


--
Armin

The situation :
I am doing a loop, and each time I can add only one element to the
primaryKey,
so I must resize the array, without clearing it, but I don't know how to do
that.

Thanks

"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote

Am 08.07.2010 22:51, schrieb Mr. X.:
In the loop, collect the columns in a List(Of DataColumn).
After the loop, set the PrimaryKey to YourList.ToArray.



--
Armin

Thanks

"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote

One little problem.
MyTable.PrimaryKey = MyList.toArray
I got the exception : column must belong to a table.

"Armin Zingler" <az.nospam (AT) freenet (DOT) de> wrote