Python Forum
Changing the BG-color of the table
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Changing the BG-color of the table
#1
Hello,
who can help me with a line of code, where to change the background color of table 2(which is in white)
to anything else, for example "blue"

from tkinter import*
from tkinter import ttk # = for gender
import pymysql  #pymysql
class Student:
    def __init__(self,root):
        self.root=root
        self.root.title("Student Management System")
        self.root.geometry("1500x760+0+0")

        title=Label(self.root,text="Student Management System",bd=10,relief=GROOVE,font=("times new roman",40,"bold"),bg="#15181A",fg="gray")
        title.pack(side=TOP,fill=X)
       
        # ========All Variables ========
        self.Roll_No_var=StringVar()
        self.name_var=StringVar()
        self.email_var=StringVar()
        self.gender_var=StringVar()
        self.contact_var=StringVar()
        self.dob_var=StringVar()
           
        # ========== Manage Frame ====
        Manage_Frame=Frame(self.root,bd=4,relief=RIDGE,bg="#1E2124")
        Manage_Frame.place(x=20,y=100,width=450,height=630)

        m_title=Label(Manage_Frame,text="Manage Students",bg="#1E2124",fg="white",font=("times new roman",30,"bold"))
        m_title.grid(row=0,columnspan=2,pady=20)

        lbl_roll=Label(Manage_Frame,text="Roll No.",bg="#1E2124",fg="white",font=("times new roman",20,"bold"))
        lbl_roll.grid(row=1,column=0,pady=10,padx=20,sticky="w")

        txt_Roll=Entry(Manage_Frame,textvariable=self.Roll_No_var,font=("times new roman",15,"bold"),bd=5,relief=GROOVE)
        txt_Roll.grid(row=1, column=1, pady=10, padx=20, sticky="w")

        lbl_name = Label(Manage_Frame, text="Name", bg="#1E2124", fg="white", font=("times new roman", 20, "bold"))
        lbl_name.grid(row=2, column=0, pady=10, padx=20, sticky="w")

        txt_name = Entry(Manage_Frame,textvariable=self.name_var,font=("times new roman", 15, "bold"), bd=5, relief=GROOVE)
        txt_name.grid(row=2, column=1, pady=10, padx=20, sticky="w")

        lbl_Email = Label(Manage_Frame, text="E-mail", bg="#1E2124", fg="white", font=("times new roman", 20, "bold"))
        lbl_Email.grid(row=3, column=0, pady=10, padx=20, sticky="w")

        txt_Email= Entry(Manage_Frame,textvariable=self.email_var,font=("times new roman", 15, "bold"), bd=5, relief=GROOVE)
        txt_Email.grid(row=3, column=1, pady=10, padx=20, sticky="w")

        lbl_Gender = Label(Manage_Frame, text="Gender", bg="#1E2124", fg="white", font=("times new roman", 20, "bold"))
        lbl_Gender.grid(row=4, column=0, pady=10, padx=20, sticky="w")
        
        combo_gender=ttk.Combobox(Manage_Frame,textvariable=self.gender_var,font=("times new roman",15,"bold"),state='readonly')
        combo_gender['values']=("male","female","other")
        combo_gender.grid(row=4,column=1,padx=20,pady=10)

        lbl_Contact = Label(Manage_Frame, text="Contact", bg="#1E2124", fg="white", font=("times new roman", 20, "bold"))
        lbl_Contact.grid(row=5, column=0, pady=10, padx=20, sticky="w")
        
        txt_Contact = Entry(Manage_Frame,textvariable=self.contact_var,font=("times new roman", 15, "bold"), bd=5, relief=GROOVE)
        txt_Contact.grid(row=5, column=1, pady=10, padx=20, sticky="w")

        lbl_Dob = Label(Manage_Frame, text="D.O.B", bg="#1E2124", fg="white",font=("times new roman", 20, "bold"))
        lbl_Dob.grid(row=6, column=0, pady=10, padx=20, sticky="w")
        
        txt_Dob = Entry(Manage_Frame,textvariable=self.dob_var,font=("times new roman", 15, "bold"), bd=5, relief=GROOVE)
        txt_Dob.grid(row=6, column=1, pady=10, padx=20, sticky="w")

        lbl_Address = Label(Manage_Frame, text="Address", bg="#1E2124", fg="white", font=("times new roman", 20, "bold"))
        lbl_Address.grid(row=7, column=0, pady=10, padx=20, sticky="w")
        
        self.txt_Address=Text(Manage_Frame,width=20,height=4,font=("",10))
        self.txt_Address.grid(row=7,column=1,pady=10,padx=20,sticky="w")

        ##-----------------Button Frame
        btn_Frame=Frame(Manage_Frame,bd=4,relief=RIDGE,bg="#1E2124")
        btn_Frame.place(x=10,y=550,width=420)

        Addbtn=Button(btn_Frame,text="Add",width=8,command=self.add_students).grid(row=0,column=0,padx=10,pady=10)
        updatedbtn = Button(btn_Frame, text="Update", width=8).grid(row=0, column=1, padx=10, pady=10)
        deletebtn = Button(btn_Frame, text="Delete", width=8).grid(row=0, column=2, padx=10, pady=10)
        Clearbtn = Button(btn_Frame, text="Clear", width=8).grid(row=0, column=3, padx=10, pady=10)

        ##-----------------Detail Frame
        Detail_Frame=Frame(self.root,bd=4,relief=RIDGE,bg="#1E2124")
        Detail_Frame.place(x=500,y=100,width=980,height=630)

        lbl_search = Label(Detail_Frame, text="Search By", bg="#15181A", fg="white", font=("times new roman", 20, "bold"))
        lbl_search.grid(row=0, column=0, pady=10, padx=20, sticky="w")

        combo_search = ttk.Combobox(Detail_Frame, font=("times new roman", 15, "bold"), state='readonly')
        combo_search['values'] = ("Roll", "Name", "Contact")
        combo_search.grid(row=0, column=1, padx=20, pady=10)

        txt_Search = Entry(Detail_Frame, font=("times new roman", 16, "bold"), bd=5, relief=GROOVE)
        txt_Search.grid(row=0, column=2, pady=10, padx=20, sticky="w")

        searchbtn = Button(Detail_Frame, text="Search", width=8).grid(row=0, column=3, padx=10, pady=10)
        showallbtn = Button(Detail_Frame, text="Show All", width=8).grid(row=0, column=4, padx=10, pady=10)
        # --------------Table Frame   farbe  rechts  ?
        Table_Frame = Frame(Detail_Frame, bd=4, relief=RIDGE, bg="yellow")
        Table_Frame.place(x=10, y=80, width=950, height=530)

        scroll_x=Scrollbar(Table_Frame,orient=HORIZONTAL)
        scroll_y = Scrollbar(Table_Frame, orient=VERTICAL)
        self.Student_table=ttk.Treeview(Table_Frame, columns=("roll","name","email","gender","contact","dob","Address"),xscrollcommand=scroll_x.set,yscrollcommand=scroll_y.set)
        scroll_x.pack(side=BOTTOM,fill=X)
        scroll_y.pack(side=RIGHT,fill=Y)
        scroll_x.config(command=self.Student_table.xview)
        scroll_y.config(command=self.Student_table.yview)
        self.Student_table.heading("roll",text="Roll No.")
        self.Student_table.heading("name", text="Name")
        self.Student_table.heading("email", text="Email")
        self.Student_table.heading("gender", text="Gender")
        self.Student_table.heading("contact", text="Contact")
        self.Student_table.heading("dob", text="D.O.B")
        self.Student_table.heading("Address", text="Address")
        self.Student_table['show']='headings'
        self.Student_table.column("roll",width=30)  ####Breite ############
        self.Student_table.column("name", width=100)
        self.Student_table.column("email", width=100)
        self.Student_table.column("gender", width=80)
        self.Student_table.column("contact", width=100)
        self.Student_table.column("dob", width=100)
        self.Student_table.column("Address", width=100)
        self.Student_table.pack(fill=BOTH,expand=1)
        self.fetch_data()
    def add_students(self):
        con=pymysql.connect(host="localhost",user="root",password="N.....80#",database="stm")   #pymysql
        cur=con.cursor()
        cur.execute("insert into students values(%s,%s,%s,%s,%s,%s,%s)",(self.Roll_No_var.get(),
                                                                         self.name_var.get(),
                                                                         self.email_var.get(),
                                                                         self.gender_var.get(),
                                                                         self.contact_var.get(),
                                                                         self.dob_var.get(),
                                                                         self.txt_Address.get('1.0',END)
                                                                        ))
        con.commit()
        self.fetch_data()
        con.close()

    def fetch_data(self):
        con=pymysql.connect(host="localhost",user="root",password="N.....80#",database="stm")
        cur=con.cursor()
        cur.execute("select * from students")
        rows=cur.fetchall()
        if len(rows)!=0:
                self.Student_table.delete(*self.Student_table.get_children())
                for row in rows:
                    self.Student_table.insert('',END,values=row)
                con.commit()
        con.close()

root=Tk()
ob=Student(root)
root.mainloop()
Reply
#2
Hi,
According to this bug tracking there is an issue in Tkinter. It is fixed in tkinter v8.6.10 but in my Python 3.9.1 there is only 8.6.9.
https://bugs.python.org/issue36468

I think it should work the following ways:

self.style = ttk.Style()
self.style.configure("mystyle.Treeview", background="black", fieldbackground="black", foreground="white", highlightthickness=0, bd=0, font=('Calibri', 11)) # Modify the font of the body
self.style.configure("mystyle.Treeview.Heading", font=('Calibri', 13,'bold')) # Modify the font of the headings
self.style.layout("mystyle.Treeview", [('mystyle.Treeview.treearea', {'sticky': 'nswe'})]) # Remove the borders
self.Student_table=ttk.Treeview(Table_Frame, style="mystyle.Treeview", columns=("roll","name","email","gender","contact","dob","Address"), xscrollcommand=scroll_x.set,yscrollcommand=scroll_y.set)

or with tags
self.Student_table.insert("", "end", values=('1','XY','[email protected]'), tags=('odd',))
self.Student_table.insert("", "end", values=('2','JD','[email protected]'), tags=('even',))
self.Student_table.tag_configure('odd', background='#E8E8E8')
self.Student_table.tag_configure('even', background='#FFFF00')

but currently it doesn't work. Maybe it is the Tkinter issue. We should wait v8.6.10
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020