[python] IronPython & ADO.NET

[Roman Miklos]

Dobry den, 

Skusal ste niekto pristup do databazy ADO.NET a IronPython? 

Napr. toto citanie pomocou Readeru mi funguje:

----- priklad -----
...
### Pouzitie ADO.NET
import clr
import System
clr.AddReference("System.Data")
import System.Data
from System.Data.OleDb import OleDbConnection as dbconnection

# Connection String
connectstr='PROVIDER=IBMDA400.DataSource.1;DATA SOURCE='+csebk+'; USER 
ID='+userid+'; PASSWORD='+pwd

# Vytvorit spojenie
dbcon=dbconnection(connectstr)
dbcon.Open()

# Vytvorit SQL Command
dbcmd = dbcon.CreateCommand()
dbcmd.CommandText = "SELECT * FROM r000100T.r000270V"

# Citat data
reader = dbcmd.ExecuteReader()

count=0
while reader.Read():
  count +=1 
  print "%10s %10s %10s %10s" % (reader[0], reader[1], reader[2], 
reader[3]) 

print "pocet viet v tabulke je: %d" % count

# zavret reader
reader.Close()
 
# Ukoncit spojenie
dbcon.Close()
----- koniec prikladu -----



Ked ale skusim pouzit dataadapter a dataset, t.j. zhruba takto 

----- priklad -----

...
from System.Data.OleDb import OleDbConnection as dbconnection
from System.Data.OleDb import OleDbDataAdapter as dbdataadapter
from System.Data import DataSet as dataset

# Connection String
DSN='PROVIDER=IBMDA400.DataSource.1;DATA SOURCE='+csebk+'; USER 
ID='+userid+'; PASSWORD='+pwd
print DSN
conn=dbconnection(DSN)
conn.Open()

dataadapter = dbdataadapter("SELECT * FROM r000100T.r000270V", conn)
#rs = System.Data.DataSet("MyDataSet")
rs=dataset("MyDataSet")
dataadapter.Fill(rs,"MyTable")
#print rs
row= rs.Tables(0).Rows(0)
...
----- koniec prikladu -----

dostanem na poslednom uvedenom riadku chybu 
"DataTableCollection object is not callable"

Mate niekto funkcny priklad jak pouzit DataSet v IronPythone?

Mgr. Ing. Roman MIKLÓŠ 
Prvá stavebná sporiteľňa a.s. 
Bajkalská 30, P. O. Box 48 
829 48  Bratislava 25 
Tel.: +421/ 2 / 582 31 174 
Fax: +421/ 2 / 582 31 109 
------------- další část ---------------
HTML příloha byla odstraněna...
URL: http://www.py.cz/pipermail/python/attachments/20060919/142ca46c/attachment.htm