From: Howard Roberts <howardroberts@...>
Date: 2008-02-20T19:47:31+09:00
Subject: Re: [ComboBox] Populate from db table

Mattia Galati wrote:

> I have a sqlite3 database wich contains a table and I want to populate a
> Gtk::ComboBox with the data on it.

Hi,

if you have:

   rows= @db.execute("SELECT cat FROM table ORDER BY cat")

that should return an array of rows from your table. Each of these rows 
themselves be an array of the fields from that row. So you should be 
able to do something like this:

  rows.each{|r| @combo.append_text(r[0])}

For documentation on RubyGTK2 you may want to have a look at 
http://ruby-gnome2.sourceforge.jp/

There is also a list for RubyGTK2 here 
http://www.ruby-forum.com/forum/12

HTH,

Howard

-- 
Posted via http://www.ruby-forum.com/.