PR
Calendar
Keyword Search
Category
Free Space
# AddReference で参照してから、import
import clr
clr.AddReference("System.Data")
from System.Data.SqlClient import *
# SQL Server への接続
conn = SqlConnection()
conn.ConnectionString = "Server=(local)\sqlexpress;Database=pubs;User ID=sa;Pwd=password"
conn.Open()
# コマンドの作成と実行
cmd = conn.CreateCommand()
cmd.CommandText = "select count(*) from titles"
count = cmd.ExecuteScalar()
print count
cmd.CommandText = "select title, type from titles"
dr = cmd.ExecuteReader()
while dr.Read():
print "title=%s type=%s" % (dr[0], dr[1])
dr.Close()
cmd.CommandText = "insert into titles values ('ironbk', 'Programming IronPython',
'programming', '0736', 2800, 0, null, null, null, '2007/3/31')"
count = cmd.ExecuteNonQuery()
print count
# 接続を閉じる
conn.Close()
参考: 『IronPython の世界』
「IronPythonでのnullは? 」と尋ねられて… 2009.04.11
IronPython 2.0 Beta 2 2008.05.03
新しい出版の形と IronPython 本 2008.04.28 コメント(1)