To all:
Is there anyway to add a System.Data.DataColumn instance to the
PrimaryKey System.Data.DataColumn[] in IronPython??
Please see following code
Thanks in advance..
Anthony
IronPython 0.7.2 on .NET 2.0.40607.42
Copyright (c) Microsoft Corporation. All rights reserved.
>>> import sys
>>> sys.LoadAssemblyByName('System.Data')
>>> #--
()
>>>
()
>>> from System import Type, Console
>>> from System.Data import DataSet, DataColumn
>>> dataset = DataSet('MySet')
>>> dataset.Tables.Add('Order')
Order
>>> dataset.Tables['Order'].Columns.Add('OrderID',
... Type.GetType('System.Int32'))
...
OrderID
>>> dataset.Tables['Order'].Columns.Add('CustomerFirstName',
... Type.GetType('System.String'))
...
CustomerFirstName
>>> dataset.Tables['Order'].Columns.Add('CustomerLastName',
... Type.GetType('System.String'))
...
CustomerLastName
>>> dataset.Tables['Order'].PrimaryKey
System.Data.DataColumn[]()
>>> dataset.Tables['Order'].Columns['OrderID']
OrderID
>>> dataset.Tables['Order'].PrimaryKey[0] = dataset.Tables['Order'].Columns['Ord
erID']
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at System.Array.InternalSetValue(Object value, Int32 index1, Int32 index2, In
t32 index3)
at System.Array.SetValue(Object value, Int32 index)
at IronPython.Objects.ArrayOps.SetIndex(Array a, Object index, Object value)
at IronPython.Objects.Ops.SetIndex(Object o, Object index, Object value)
at IronPython.Objects.Ops.SetIndexStackHelper(Object value, Object o, Object
index)
at input_13.Run(Frame frame)
at IronPython.Hosting.PythonEngine.DoOneInteractive(Frame topFrame)
at IronPython.Hosting.PythonEngine.RunInteractive()
>>>
_______________________________________________
users-ironpython.com mailing list
users-ironpython.com@lists.ironpython.com
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
