[wxPython] database + wxpython

This is a simple example of wxGrid that I use.
This has a fixed number of rows and cols and the SetData method uses a
list of lists as argument to update de values.

#- <00>

···

-----------------------------------------------------------------------
# Archivo : TranfeGrid.py -- 0.1 -- 19/02/01

from wxPython.wx import *
from wxPython.grid import *

#---------------------------------------------------------------------------

class TranfeGrid(wxGrid):
    def __init__(self, parent,ta_lista,tc_lista,size):
        wxGrid.__init__(self,
parent,-1,size=size,style=wxSIMPLE_BORDER|wxSUNKEN_BORDER)

        self.cols = 12
        self.rows = 10
        self.CreateGrid(self.rows, self.cols)

        self.SetGridLineColour(wxColour(128,128,128))
        self.EnableEditing(false)
        self.SetSelectionMode(wxGrid.wxGridSelectColumns)
        
        MYFONT = wxFont(8,wxROMAN,wxNORMAL,wxNORMAL,0,"Tahoma")
        self.SetLabelFont(MYFONT)
        self.SetDefaultCellFont(MYFONT)
        self.SetDefaultCellAlignment(wxRIGHT,wxCENTER)
        self.SetRowLabelAlignment(wxCENTER,wxCENTER)
        self.SetColLabelAlignment(wxCENTER,wxCENTER)
        self.SetColLabelSize(20)
        self.SetRowLabelSize(50)
        self.SetCellHighlightColour(wxBLACK)

        for i in range(self.cols):
            self.SetColLabelValue(i,"%.1f" % tc_lista[i])
            self.SetColSize(i,50)
        for i in range(self.rows):
            self.SetRowLabelValue(i,"%.1f" % ta_lista[i])
    
    def SetData(self,data):
        for row in range(len(data)):
            for col in range(len(data[row])):
                if data[row][col] == 0.0:
                    _val = ""
                else:
                    _val = "%.1f" % data[row][col]
                self.SetCellValue(row,col,_val)

-----Original Message-----
From: Jake Tyler [SMTP:jakes_97@yahoo.com]
Sent: Friday, April 06, 2001 12:43 PM
To: wxpython-users@lists.wxwindows.org
Subject: [wxPython] database + wxpython

Does anyone have an example of how to fill a wxPython
grid with large amounts of data from a database?

I'm completely lost.

Thanks!

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

_______________________________________________
wxpython-users mailing list
wxpython-users@lists.wxwindows.org
http://lists.wxwindows.org/mailman/listinfo/wxpython-users