try it
ds.Tables["AddressBook"].Rows[0][1]
or
for dr in ds.Tables[AddressBook].Rows:
dr[1]


2007/4/26, kostas daglas <[EMAIL PROTECTED]>:

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
[email protected]
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com




--
这两年来慢慢习惯了光说不练.
_______________________________________________
users mailing list
[email protected]
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com

Reply via email to