#!/usr/bin/env python
# -*- coding: utf-8 -*-
import pygtk
pygtk.require("2.0")
import gtk
from sql import *
import sys

class Onglets(gtk.Notebook):

	def __init__(self):
		self = gtk.Notebook()
		self.set_tab_pos(gtk.POS_TOP)
		

	def newTab(self, widget, style):
		switch = {
		"Produits": self.tabProduit
		}
		
		switch[style]()
	
		
		
	
	def tabProduit(self):
		req = Sql()
		result = req.query("SELECT ref, designation, stock, prix FROM produits")
		
			

		store = gtk.ListStore(str, str, int, str)
		
		

		for row in result:
			ref = row[0].decode('latin1').encode('utf-8')
			designation = row[1].decode('latin1').encode('utf-8')
			
			store.append([ref, designation, row[2], '%.2f €' % row[3]])

		treeView = gtk.TreeView(store)
		treeView.set_rules_hint(True)
		rendererText = gtk.CellRendererText()
		column = gtk.TreeViewColumn("Réf.", rendererText, text=0)
		column.set_sort_column_id(0)
		column.set_expand(True)  
		column.set_resizable(True)  
		treeView.append_column(column)

		rendererText = gtk.CellRendererText()
		column = gtk.TreeViewColumn("Désignation", rendererText, text=1)
		column.set_sort_column_id(1)
		column.set_expand(True)
		column.set_resizable(True)
		treeView.append_column(column)

		rendererText = gtk.CellRendererText()
		column = gtk.TreeViewColumn("Stock", rendererText, text=2)
		column.set_sort_column_id(2)
		column.set_expand(True)
		column.set_resizable(True)
		treeView.append_column(column)
		
		rendererText = gtk.CellRendererText()
		column = gtk.TreeViewColumn("Prix", rendererText, text=3)
		column.set_sort_column_id(3)
		column.set_expand(True)
		column.set_resizable(True)
		treeView.append_column(column)

		return treeView

self.onglets = Onglets()
...
conteneur.pack2(self.onglets, resize=True, shrink=False)