<br><font size=2 face="sans-serif">Dobry den, </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
Skusal ste niekto pristup do databazy cez ADO.NET a IronPython? </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
Napr. toto citanie pomocou Readeru mi funguje:</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
----- priklad -----</font><font size=3> </font><font size=2 face="Courier New"><br>
...</font><font size=3> </font><font size=2 face="Courier New"><br>
### Pouzitie ADO.NET</font><font size=3> </font><font size=2 face="Courier New"><br>
import clr</font><font size=3> </font><font size=2 face="Courier New"><br>
import System</font><font size=3> </font><font size=2 face="Courier New"><br>
clr.AddReference("System.Data")</font><font size=3> </font><font size=2 face="Courier New"><br>
import System.Data</font><font size=3> </font><font size=2 face="Courier New"><br>
from System.Data.OleDb import OleDbConnection as dbconnection</font><font size=3>
<br>
</font><font size=2 face="Courier New"><br>
# Connection String</font><font size=3> </font><font size=2 face="Courier New"><br>
connectstr='PROVIDER=IBMDA400.DataSource.1;DATA SOURCE='+csebk+'; USER
ID='+userid+'; PASSWORD='+pwd</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
# Vytvorit spojenie</font><font size=3> </font><font size=2 face="Courier New"><br>
dbcon=dbconnection(connectstr)</font><font size=3> </font><font size=2 face="Courier New"><br>
dbcon.Open()</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
# Vytvorit SQL Command</font><font size=3> </font><font size=2 face="Courier New"><br>
dbcmd = dbcon.CreateCommand()</font><font size=3> </font><font size=2 face="Courier New"><br>
dbcmd.CommandText = "SELECT * FROM r000100T.r000270V"</font><font size=3>
<br>
</font><font size=2 face="Courier New"><br>
# Citat data</font><font size=3> </font><font size=2 face="Courier New"><br>
reader = dbcmd.ExecuteReader()</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
count=0</font><font size=3> </font><font size=2 face="Courier New"><br>
while reader.Read():</font><font size=3> </font><font size=2 face="Courier New"><br>
count +=1 </font><font size=3> </font><font size=2 face="Courier New"><br>
print "%10s %10s %10s %10s" % (reader[0], reader[1], reader[2],
reader[3]) </font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
print "pocet viet v tabulke je: %d" % count</font><font size=3>
<br>
</font><font size=2 face="Courier New"><br>
# zavret reader</font><font size=3> </font><font size=2 face="Courier New"><br>
reader.Close()</font><font size=3> </font><font size=2 face="Courier New"><br>
</font><font size=3> </font><font size=2 face="Courier New"><br>
# Ukoncit spojenie</font><font size=3> </font><font size=2 face="Courier New"><br>
dbcon.Close()</font><font size=3> </font><font size=2 face="Courier New"><br>
----- koniec prikladu -----</font><font size=3> <br>
<br>
<br>
</font><font size=2 face="sans-serif"><br>
Ked ale skusim pouzit dataadapter a dataset, t.j. zhruba takto </font><font size=3><br>
</font><font size=2 face="Courier New"><br>
----- priklad -----</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
...</font><font size=3> </font><font size=2 face="Courier New"><br>
from System.Data.OleDb import OleDbConnection as dbconnection</font><font size=3>
</font><font size=2 face="Courier New"><br>
from System.Data.OleDb import OleDbDataAdapter as dbdataadapter</font><font size=3>
</font><font size=2 face="Courier New"><br>
from System.Data import DataSet as dataset</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
# Connection String</font><font size=3> </font><font size=2 face="Courier New"><br>
DSN='PROVIDER=IBMDA400.DataSource.1;DATA SOURCE='+csebk+'; USER ID='+userid+';
PASSWORD='+pwd</font><font size=3> </font><font size=2 face="Courier New"><br>
print DSN</font><font size=3> </font><font size=2 face="Courier New"><br>
conn=dbconnection(DSN)</font><font size=3> </font><font size=2 face="Courier New"><br>
conn.Open()</font><font size=3> <br>
</font><font size=2 face="Courier New"><br>
dataadapter = dbdataadapter("SELECT * FROM r000100T.r000270V",
conn)</font><font size=3> </font><font size=2 face="Courier New"><br>
#rs = System.Data.DataSet("MyDataSet")</font><font size=3> </font><font size=2 face="Courier New"><br>
rs=dataset("MyDataSet")</font><font size=3> </font><font size=2 face="Courier New"><br>
dataadapter.Fill(rs,"MyTable")</font><font size=3> </font><font size=2 face="Courier New"><br>
#print rs</font><font size=3> </font><font size=2 face="Courier New"><br>
row= rs.Tables(0).Rows(0)</font><font size=3> </font><font size=2 face="Courier New"><br>
...</font><font size=3> </font><font size=2 face="Courier New"><br>
----- koniec prikladu -----</font><font size=3> <br>
</font><font size=2 face="sans-serif"><br>
dostanem na poslednom uvedenom riadku chybu <br>
"DataTableCollection object is not callable"</font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
Mate niekto funkcny priklad jak pouzit DataSet v IronPythone?</font><font size=3>
</font><font size=2 face="sans-serif"><br>
<br>
Mgr. Ing. Roman MIKLÓ© <br>
Prvá stavebná sporiteµňa a.s. <br>
Bajkalská 30, P. O. Box 48 <br>
829 48 Bratislava 25 <br>
Tel.: +421/ 2 / 582 31 174 <br>
Fax: +421/ 2 / 582 31 109</font>
<br><font size=2><tt><br>
Mgr. Ing. Roman MIKLÓ© <br>
Prvá stavebná sporiteµňa a.s. <br>
Bajkalská 30, P. O. Box 48 <br>
829 48 Bratislava 25 <br>
Tel.: +421/ 2 / 582 31 174 <br>
Fax: +421/ 2 / 582 31 109 <br>
</tt></font>