ProdateCodes

step 1: Creating Database import sqlite3 conn = sqlite3.connect('product.db') conn.execute('''CREATE TABLE PRODUCTS          (ID INT PRIMARY KEY     NOT NULL,          NAME           TEXT    NOT NULL,          PRICE            INT     NOT NULL );''') conn.close() Step 2: Inserting Values import sqlite3 conn = sqlite3.connect('product.db') conn.execute("INSERT INTO PRODUCTS (ID,NAME,PRICE) \       VALUES (1, 'SAMSUNG', 20000.00 )"); conn.commit() conn.close() Step 3: TKinter Code from tkinter import * from tkinter import ttk import sqlite3 conn = sqlite3.connect('product.db') root = Tk() root.geometry('600x500') tree = ttk.Treeview(root,column=("c1","c2","c3"),show='headings',height=8) tree.column("#1",anchor=CENTER) tree.heading("#1",text ="ID") tree.column("#2",anchor=CENTER) tree.heading("#2",text ...

Insert And Retrieve Images From SQlite Database using Tkinter and Python Firstly need to create database  import sqlite3 conn = sqlite3.connect('test8.db')  conn.execute('''CREATE TABLE PHOTO          (ID INT PRIMARY KEY     NOT NULL,          IMAGE           BLOB   NOT NULL,                     );''')    conn.close() Secondly Inserting Method import sqlite3 conn = sqlite3.connect('test8.db') image = open("Home.png","rb")  ////IMAGE FILE TO UPLOAD conn.execute('INSERT INTO PHOTO (ID,IMAGE) VALUES(1,?)',[sqlite3.Binary(image.read())]) conn.commit() conn.close() Retrieve Images From Database Using Tkinter import sqlite3 from tkinter import * root = Tk() root.geometry('300x400') conn = sqlite3.connect('test8.db') cursor = conn.cursor() cursor = conn.execute("""SELECT * FROM PHOTO WHERE ID = 3 """...