CRM App With Treeview and SQLite3 - Tkinter Projects 16

[@TkinterPython]

▶ Watch TTKBootstrap Playlist ✅ FREE Tkinter Widget Book
bit.ly/3hphbwA bit.ly/3K4qlZC
▶ See More At: ✅ Subscribe To My UA-cam Channel:
Tkinter.com bit.ly/3Pk1By4
▶ MASSIVE TKINTER.COM DISCOUNT ✅ Join My Facebook Group:
30% off with coupon code: youtube bit.ly/2GFmOBz
▶ Get The Code For This Video ✅ Watch The 200 Video Tkinter Playlist
bit.ly/3LQklWT bit.ly/3HAqZOd

[@PascalChapier]

Many thanks for this video, I learned a lot.
If you are still looking for idea, you could add a sort function triggered when the user click in one treeview header:
- first click in one header sort the record according to the colume content in ascending direction,
- second click sort in descending direction and so on.
- Click in a different header cell will restart by ascending sort for the new column selected.
- The state is not preserved for the next program run.

[@JoaoNeto-oj9cn]

This data editing solution is very good, thank you very much for sharing these solutions. However, when it comes to DateEntry in the ttkboostrap package I can't get it to work. The date field does not show the record date and keeps the default date. The same happens with cleaning this field to edit a new record. What solutions can you suggest to solve this problem?
Working dates in a database is not easy, at least for me.

[@stevew9945]

excellent work, taught me a lot

[@TkinterPython]

Glad to hear it!

[@Rulzan]

John, you're simply the best

[@TkinterPython]

thanks!

[@moris933]

Thanks, great job. If you want I have more ideas for this channel, for example some applications when we can mark a place on Google maps and put some description for example for delivery company or interest place and share online. What you think?

[@TkinterPython]

we'll see. :-)

[@makhlouflazhar24]

Thanks in advance,
I would like you to give us an example of extracting a PDF file from the database by exploiting data from the database

[@davidsbdavid7769]

Hi, good job. Is there a way to get the files used in the live?

[@TkinterPython]

huh?

[@code-to-learn]

Awesome tutorial sir

[@TkinterPython]

Glad you enjoyed it!

[@biotyana945]

can you do the same project with ttkbootstrap

[@TkinterPython]

As I said in the video...use the exact same code, just define the treeview like we did in last week's video where I discussed ttkbootstrap's treeview.

[@bigrevkev55]

You are the man!

[@TkinterPython]

Thanks!

[@tomkmb4120]

Is it possible to add numeric filtering to the columns in Tkinter?

[@TkinterPython]

Sure

[@tomkmb4120]

@@TkinterPython Is that covered in a specific video?

[@TkinterPython]

@@tomkmb4120 Not sure, it might be in this one somewhere, you can check the tkinter playlist on my codemy.com youtube channel

[@manfredbaum2510]

I do not find the code. Where is it. Excuse my bad english

[@Codemycom]

It is linked in the pinned comment.

[@pablo20237]

Very excellent, thank you sir

[@TkinterPython]

Welcome!

[@digitalmachine0101]

Good information

[@TkinterPython]

Thanks!

[@vladmakrov8394]

Nice job Sir. Thanks. Where can i find the source code?

[@TkinterPython]

pinned comment, as always

[@lemartien25000]

Invalid column index ???? When running this code I got the following error: Invalid column index. This happens in the treeview column definition. is this a problem in python interpreter I should reinstall python? I have version 3.12

[@Codemycom]

No it's not a problem with python, you just messed up the code somewhere.

[@lemartien25000]

@@Codemycom import tkinter as tk
from tkinter import ttk
import sqlite3
def afficher_resultats_requete(table_name):
# Créer une fenêtre
fenetre = tk.Tk()
fenetre.title(f"Résultats de la requête pour la table {table_name}")
# Établir la connexion avec la base de données
conn = sqlite3.connect('agrements.db')
cursor = conn.cursor()
# Exécuter la requête SELECT *
cursor.execute(f"SELECT * FROM {table_name}")
rows = cursor.fetchall()
# Créer un Treeview
tree = ttk.Treeview(fenetre)
# Configurer la colonne cachée (d'index)
tree.column("#0", width=0, stretch=tk.NO) # Largeur à 0 pour la cacher
tree.heading("#0", text="", anchor=tk.W) # Texte vide pour la colonne cachée
# Configurer les colonnes en fonction du nom des colonnes dans le résultat de la requête
for col_name in cursor.description:
tree.heading(col_name[0], text=col_name[0])
tree.column(col_name[0], width=100)
# Insérer les données dans le Treeview
for row in rows:
tree.insert("", "end", values=row)
# Ajouter le Treeview à la fenêtre
tree.pack(expand=True, fill="both")
# Démarrer la boucle principale
fenetre.mainloop()
# Appeler la fonction pour afficher les résultats pour la table 'nom_table'
afficher_resultats_requete('nom_table')

[@TkinterPython]

I don't review code

[@biotyana945]

thanks in advance ❤

[@TkinterPython]

just define your treeview using ttkbootstrap, the rest is the same.

[@MAH1MOUMA]

Thanks

[@TkinterPython]

Welcome!

[@ken4edwards]

where is the code?

[@TkinterPython]

In the pinned comment, as always.

[@ken4edwards]

Thanks, I did no know about pinded comments and I did not know I would have to click show more to find it.

[@sadyaz64]

Thanks

[@TkinterPython]

Welcome!