Dobry den,
Skusal ste niekto pristup do databazy cez 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
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
_______________________________________________ Python mailing list [email protected] http://www.py.cz/mailman/listinfo/python
