Anthony,
Yes, there is a way. With few changes your code is essentially correct:
import sys
sys.LoadAssemblyByName('System.Data')
from System import Type, Console, Array
from System.Data import DataSet, DataColumn
key = Array.CreateInstance(DataColumn, 1)
dataset = DataSet('MySet')
dataset.Tables.Add('Order')
dataset.Tables['Order'].Columns.Add('OrderID',
Type.GetType('System.Int32'))
dataset.Tables['Order'].Columns.Add('CustomerFirstName',
Type.GetType('System.String'))
dataset.Tables['Order'].Columns.Add('CustomerLastName',
Type.GetType('System.String'))
dataset.Tables['Order'].PrimaryKey
dataset.Tables['Order'].Columns['OrderID']
key[0] = dataset.Tables['Order'].Columns['OrderID']
dataset.Tables['Order'].PrimaryKey = key
The PrimaryKey property is property of type "DataColumn[]" which
suggests that you should be
able to index it, but upon creation the array is that of length 0. The
primary key array
needs to be created separately:
key = Array.CreateInstance(DataColumn, 1)
key[0] = dataset.Tables['Order'].Columns['OrderID']
dataset.Tables['Order'].PrimaryKey = key
and then things work.
Martin
>>> Anthony Tarlano Wrote:
>>> To all:
>>> Is there anyway to add a System.Data.DataColumn instance to the
>>> PrimaryKey System.Data.DataColumn[] in IronPython??
_______________________________________________
users-ironpython.com mailing list
[email protected]
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
