[IronPython] DataSet.Tables not callable

[东子]

in Python, "() " means a CALL, if you want a INDEX, try "[]" .

like this:

txtFirstName.Text = ds.Tables["AddressBook"].Rows[0].Item[1]

2007/4/26, kostas daglas <daglask at gmail.com>:
>
> hi all ! this is my first post and i am new to database programming
> generally.
> Anyway i would appreciate your help..
>
> i made an Addressbook table with 5 rows (myfriends!) and every row has
> items (name, surname etc.)i called it AddressBook.mdb
>
> I made  a form with a button and a TextBox contorl
> i want to show when i click the button the first item of a given row in my
> textbox.
> i did:
>             con = OleDb.OleDbConnection()
>             ds = DataSet()
>
>
>
>             con.ConnectionString = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;Data
> Source = C:\AddressBook.mdb'
>             con.Open()
>             sql = 'SELECT * FROM tblContacts'
>
>             da=OleDb.OleDbDataAdapter(sql, con)
>             da.Fill(ds, "AddressBook")
>
> in c# i could do :
>             txtFirstName.Text = ds.Tables("AddressBook").Rows(0).Item(1)
>             how can i do that in IronPython?   ( i tried  it  but :
> "DataTableCollection object is not callable.". )
>
>  Thanks in advance for your help !
>
> Kostas
>
>
>
>
> _______________________________________________
> users mailing list
> users at lists.ironpython.com
> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>
>


-- 
只要人间真情在, 何必在意路泥泞
时风日下,和谐需要靠暴力达到!!!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20070426/207230bb/attachment.html>