Search Database Treeview By Last Name - Python Tkinter GUI Tutorial 182

Поділитися
Вставка
  • Опубліковано 5 лют 2025

КОМЕНТАРІ • 51

  • @Codemycom
    @Codemycom  3 роки тому +5

    ▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My UA-cam Channel:
    bit.ly/2UFLKgj bit.ly/2IGzvOR
    ▶️ See More At: ✅ Join My Facebook Group:
    Codemy.com bit.ly/2GFmOBz
    ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt!
    Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN
    ▶️ Get The Code
    bit.ly/3vMPT4G

  • @markal3023
    @markal3023 3 роки тому +2

    Brilliant, thanks John. Your courses have made such a difference to my bumbling programming skills. I actually managed to make a treeview search function work albeit different way to yours just from bits from your different courses. Thank you for passing on your skills

  • @scott8940
    @scott8940 3 роки тому

    Starting to look like an old Cobol program 😄 from back in the days.
    How about a report button and a print command? Thanks for all the Tkinter help John !

  • @donizeteaugustini348
    @donizeteaugustini348 3 роки тому

    Congratulations. Great videos.

  • @Hydratic1778
    @Hydratic1778 3 роки тому +1

    Thank you for your tutorials! I am creating an app with multiple search entry boxes. I would like the app to ignore the entry boxes that are left empty and only search the inputs the user keyed in. And similarly if all entry boxes are empty, the app should return all the records in my database. How do I do that? Any help is appreciated!

  • @giuseppegadola1243
    @giuseppegadola1243 3 роки тому

    I just love how you are genuinely excited about what you do 😊. Can we also have a sort column feature like in file explorers? Thanks

  • @Abdelaalielkhaoua
    @Abdelaalielkhaoua 3 роки тому +1

    Thanks 🙏

  • @chrispieczora7049
    @chrispieczora7049 Рік тому

    Great Video John, thanks. However getting an error, is there somewhere the complete code for the "Search"?

    • @Codemycom
      @Codemycom  Рік тому

      as I say in the video, the code is in the pinned comment.

    • @chrispieczora7049
      @chrispieczora7049 Рік тому

      Thanks and solved the issue

  • @DifferentThinker
    @DifferentThinker 2 роки тому

    Hats off sir 😍😍 how can we make this programme executable. i tried pyinstaller but it gives errors... can you make a video to make it possible to make executable database programms......

  • @sushilchettri8572
    @sushilchettri8572 3 роки тому

    John sir thanks for the series ...I have been able to complete my project by your videos . Thanks alot . I wanted a lil bit help , actually I wanted the data to be printed in a CSV file ,can you please tell how can I do that ?

    • @Codemycom
      @Codemycom  3 роки тому

      I have a course for sale at Codemy.com that teaches how to create excel spreadsheets with python.

  • @theexpert8320
    @theexpert8320 3 роки тому +2

    You should use ttk Widgets it looks modern like, ttk.Button() ttk.Entry() But it has a point that you cannot change fg nor bg of them as they have their own style..

    • @Codemycom
      @Codemycom  3 роки тому +2

      I like doing it the way that I do it.

    • @codeKeshav
      @codeKeshav 3 роки тому

      No, we can change the bg and fg of ttk widget using ttk.style()

  • @isolated.8976
    @isolated.8976 2 роки тому +1

    Is there a way to use a search bar without clicking a button? Then, once you type in stuff, it would automatically start removing the unwanted data.

    • @Codemycom
      @Codemycom  2 роки тому

      Do you mean through telepathy? You can use bindings. I have lots of videos on binding.

  • @gopinathsonu
    @gopinathsonu 3 роки тому +1

    How to do dynamic search in the list?

  • @askpatti
    @askpatti 2 роки тому

    Okay. So I'm working on my treeview with my book database. I was trying to add a combobox instead of entry boxes in a couple of places. I've got the combobox on the screen, I can select an item and print it to the screen, but I haven't been able to get the selected item to the database. And as I was doing this, using update record, I realized adding a new record would have different code. Can you do a video on this? Thanks!

    • @Codemycom
      @Codemycom  2 роки тому

      Pretty sure I have a video on adding a record already

  • @extra_humano
    @extra_humano 2 місяці тому

    Can you do a search bar for tkinter app using a excel?

  • @MMMEHTA99
    @MMMEHTA99 Рік тому

    Brilliant sir,Sir Can u make SQL data fatch only first name who space appier between two words combobox ,I make it but it's show error of () after fatch

  • @theexpert8320
    @theexpert8320 3 роки тому +3

    1st

  • @sparshsaxena7507
    @sparshsaxena7507 3 роки тому

    Can i also use this for text files

  • @waitwhat7164
    @waitwhat7164 2 роки тому

    how do I change the search to wildcard si if they search for 'a' only all last names with a will appear. I am stucked

    • @Codemycom
      @Codemycom  2 роки тому

      In the normal sqlite way. Google: sqlite wildcard search

  • @bybmsfr770
    @bybmsfr770 2 роки тому +1

    Hi Sir,
    This treeview project help me a lot in py project but I have an issue.
    When I add a data from the button and i want immediatly to make a research on this data that return me nothing, like this in my terminal : [ ]
    I dont know from where this issue is coming from but if you can help on this that will save me :)
    Thx for all of your videos and have a good day.

    • @maxprofane2
      @maxprofane2 2 роки тому

      I have the same issue and couldn't find a solution yet.

    • @kevinhougesen1473
      @kevinhougesen1473 2 роки тому

      @@maxprofane2 Same problem. Anyone found a fix?

    • @kevinhougesen1473
      @kevinhougesen1473 2 роки тому

      @@maxprofane2 Apparently it somewhat works ? I can search for records, but it has to be precise. For some reason it seems to ignore 'LIKE' function

    • @kevinhougesen1473
      @kevinhougesen1473 2 роки тому

      found this to solve the problem: c.execute("SELECT * FROM project_table WHERE projectname LIKE '%"+lookup_record+"%'")

  • @tanishgambhir6679
    @tanishgambhir6679 3 роки тому

    Hey, can you start a series on robotics with Python, can't find good tutorials for the same, so asked you if you can?

  • @codeKeshav
    @codeKeshav 3 роки тому

    For John, Python Programming Language is *pudding* 🍮

  • @doc9897
    @doc9897 3 роки тому

    Awesome but how do we do for live search

    • @Codemycom
      @Codemycom  3 роки тому

      What do you mean by live search? All searches are live

    • @doc9897
      @doc9897 3 роки тому

      @@Codemycom the way you did it using the list box,
      I want it if u can do it using treeview e.g.
      Lets assume am searching a certain name from the treeview i need that to be done like if there's the name Toshiba, Mitsubishi in the table rows. If i press T on my keyboard, the system should be able to respond by showing matching characters and hiding unmatching characters.
      I hope am clear now

  • @yahyaa4499
    @yahyaa4499 3 роки тому

    Hey Sir, Can you do tutorials on Visual Basic?
    Thx

    • @Codemycom
      @Codemycom  3 роки тому

      That's not really a thing anymore is it? Didn't Microsoft announce they're pulling the plug on it?

  • @joeyblaq9952
    @joeyblaq9952 3 роки тому

    👌

  • @anontough6907
    @anontough6907 2 роки тому

    wth, why you didn't go OOP with tkinter ?