Hello Everyone,
I am Newbie in Python and i want some help
I already created DB and in glade two Text Entry Box and one button
and i want when i put some value in text entry it must be stored in db
here is my code:
import gi
gi.require_version('Gtk', '3.0')
from gi.repository import Gtk
import sqlite3
import sys
class Handler:
def insert_sqlite():
connection = sqlite3.connect('mydatabase')
cursor = connection.cursor()
sql ="INSERT INTO person_info (name,lastnm) VALUES ('%s','%s')"
cursor.execute(sql)
data = cursor.fetchall()
for d in data:
print(d)
connection.commit()
connection.close
def display_details():
connection = sqlite3.connect('mydatabase')
cursor = connection.cursor()
sql = "SELECT * FROM person_info "
cursor.execute(sql)
data = cursor.fetchall()
for d in data:
print(d)
connection.commit()
connection.close
builder = Gtk.Builder()
builder.add_from_file("cool.glade")
builder.connect_signals(Handler())
window = builder.get_object("window1")
window.show_all()
Gtk.main()
I also set signal in glade
clicked signal( insert_sqlite)
on save button
but data is not save in Database
Please Help me guys
--
Thanks & Regards,
Sangram Kakade <http://www.sangramkakade.com>
Python/Django Developer
Mob.No. 9975159162 / 8796535503
_______________________________________________
gtk-app-devel-list mailing list
gtk-app-devel-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gtk-app-devel-list
