Window Frame with scrollbar , Canvas using grid positioning

DJANGO

 

        zresult = Tk()
        
        canvas = Canvas(zresult)
        canvas.grid(row=0,column=0,sticky="news")

        frame = Frame(canvas)
        scrollbar = Scrollbar(zresult,orient=VERTICAL,command=canvas.yview)
        canvas.configure(yscrollcommand=scrollbar.set)
        scrollbar.grid(row=0,column=1,sticky='ns')

        canvas.create_window((0, 0), window=frame, anchor='nw')
        def onFrameConfigure(canvas):
            '''Reset the scroll region to encompass the inner frame'''
            canvas.configure(scrollregion=canvas.bbox("all"))
        frame.bind("<Configure>", lambda event, canvas=canvas: onFrameConfigure(canvas))

        sql_99 = 'select * from R1_TCD'
        zoutput = self.dbreport.execute(sql_99)
        i = 0
        for zrec in zoutput:
            i = i + 1
            for j in range(0,len(zrec)):
                l1 = Label(frame,text = zrec[j])
                l1.grid(row=i,column=j,sticky='news')
        
        zresult.mainloop()

 

            Related