or you can use a python standard dbapi to get to your SQL data. <br><a href="http://adodbapi.sourceforge.net/">http://adodbapi.sourceforge.net</a><br> <br><br>On Tue, Mar 3, 2009 at 9:07 AM, Dody Gunawinata <<a href="mailto:empirebuilder@gmail.com">empirebuilder@gmail.com</a>> wrote:<br>
> values = System.Array.CreateInstance(System.Object, reader.FieldCount)<br>><br>><br>> On Tue, Mar 3, 2009 at 6:03 PM, Bernd Viehmann<br>> <<a href="mailto:bernd.viehmann@ascom-ac.de">bernd.viehmann@ascom-ac.de</a>> wrote:<br>
>> Hi,<br>>><br>>> I have a question regarding a typed array.<br>>><br>>> Basically I want to use IronPython and <a href="http://ADO.NET">ADO.NET</a> to get some data from a<br>>> stored procedure. My first idea was to use a SQL DataReader to get all the<br>
>> lines of my result table into an array. Csharp way looks like this:<br>>><br>>> *ArrayList rowList = new ArrayList();*<br>>> SqlDataReader reader = storedProcCommand.ExecuteReader();<br>>> while (reader.Read())<br>
>> {<br>>> *object[] values = new object[reader.FieldCount];*<br>>> *reader.GetValues(values);*<br>>> *rowList.Add(values);*<br>>> }<br>>><br>>> My problem is to generate an array of type object to feed<br>
>> *reader.GetValues(values) with it. Any ideas how this can be done?<br>>><br>>> Kind regards from Germany<br>>><br>>> Bernd<br>>><br>>> *<br>>> _______________________________________________<br>
>> Users mailing list<br>>> <a href="mailto:Users@lists.ironpython.com">Users@lists.ironpython.com</a><br>>> <a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br>
>><br>><br>><br>><br>> --<br>> <a href="http://nomadlife.org">nomadlife.org</a><br>> _______________________________________________<br>> Users mailing list<br>> <a href="mailto:Users@lists.ironpython.com">Users@lists.ironpython.com</a><br>
> <a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br>><br><br>