• Thursday , 4 June 2020

MySQL VB.NET Tutorial 12 : Show database values in Table or DataGridView

Code Canyon



VB.NET – How to get user entered data from datagridview to windows Visual Basic Insert, Update and Delete from DataGridView to sql server,MySql Sql …

Original source

3d Ocean

Related Posts

34 Comments

  1. thirdy bacus
    September 15, 2017 at 18:20

    i try this code but my datagridview is not refreshing.. the table are duplicating.

  2. nosreffoj00
    September 15, 2017 at 18:20

    hi ive just follow your code and after ive save my data in the database its duplicating may data in the table and for me to see the updated table i just need to click the load table button again. what should i do? thanks

  3. Nicolas Capistrano
    September 15, 2017 at 18:20

    hi sir , i watched all your tutorials regarding this topic and somehow i am stuck at this problem when you click on load button theres an error says you cant connect to this mariadb server, can you please tell me how to solvee this

  4. Kumaresan Murugan
    September 15, 2017 at 18:20

    thanks man really helpful . can you upload video, VB.NET WPF : How to Link ListBox and ComboBox with Database.?

  5. K Saketh
    September 15, 2017 at 18:20

    thanks for all the vedios. all are awsome, can you make the same using the sql server management studio instead of mysql that would be helpful even though most of the code looks the same

  6. Windows Pc Dersleri
    September 15, 2017 at 18:20

    proje source ?

  7. elyhk
    September 15, 2017 at 18:20

    hi .. i'd follow the things you did but i've got this kind of error : the selectCommand property has not been initialized before calling 'FILL'.. Can you help me fix this error?! thank you very much in advance

  8. Abel Camilo Yi Martínez
    September 15, 2017 at 18:20

    good!, but now, How can i delete multiple records?

  9. Cycloneaire Aire
    September 15, 2017 at 18:20

    hey can you display it in another form ?? i mean create new form using codes only?? not adding using the toolbox and display there the data or record thanks in davance!!!

  10. rinceleung
    September 15, 2017 at 18:20

    Thank you very much.

  11. arjun more
    September 15, 2017 at 18:20

    Thank u sir , can u tell me how to search exact value in datagridview

  12. Riaan Pretorius
    September 15, 2017 at 18:20

    Hello there , foirst of all I would like to thank you for your help Could you please show me how to import date from MySQL to show in DATGRIDVIEW when selecting combox.

  13. Rey Praning
    September 15, 2017 at 18:20

    tnx man.. 🙂

  14. Kenneth Paglinawan
    September 15, 2017 at 18:20

    I am having duplicate value in mydatagridview anyone help!!

  15. Logisharp
    September 15, 2017 at 18:20

    Help me, Error at "Command = New MySqlCommand(Query, MysqlConn)

  16. Hared Meza
    September 15, 2017 at 18:20

    Excellent man… It works great, thanks for explaining. Keep it up.

  17. Kumar Sanu
    September 15, 2017 at 18:20

    if i have 2000 daya with image so datagrid view table shown all record in second?

  18. Manoj Kumar Ravidas
    September 15, 2017 at 18:20

    sir how can see your previous video

  19. Buddhi Adhikari
    September 15, 2017 at 18:20

    you pronounce "Data" in a funny way

  20. Twinkle Dawani
    September 15, 2017 at 18:20

    I wrote this code but i am not getting any output please help me.

  21. Manash Sarma
    September 15, 2017 at 18:20

    The video did not work my system

  22. Kiri Yu Suna
    September 15, 2017 at 18:20

    Sir! How to view multiple tables? I have 3 tables and I want to view it individually in datagridview.. How do I do that? SIR PLEASE REPLY!

  23. zaza feur
    September 15, 2017 at 18:20

    thank you sir
    i have a probleme with valus null afffiche message d'erreur/les donnees sont null cette méthode ou proprieté ne peut pas etre appellée sur des valeurs null
    please help me

  24. Jerlyn Paguio
    September 15, 2017 at 18:20

    thank you sir in advance.. i really need it for our thesis

  25. volikoto
    September 15, 2017 at 18:20

    Thank You, you saved my dilemma.

  26. Yoel Briceño Mallma
    September 15, 2017 at 18:20

    Thank you ProgrammingKnowledge for your videos. 
    I want to display a Boolean column from Mysql Database as a checkbox column in the datagridview. 

    Can someone help me please? I'm a beginner

  27. Karvin Poon
    September 15, 2017 at 18:20

    Greetings sir! I am a big fan of yours and I kinda trying to make my own program which is base from your teachings. Well the problem is I do not know how to make report base on database. I tried to watch different videos with regards to report viewer but I still fail to do what I want. Please make some tutorial with regarding my problem. Thanks in advance sir. God bless

  28. Thurman Jenner
    September 15, 2017 at 18:20

    Excellent. I must have watched this series 10 times now. It would be grand if you could use  a broader scope of database variables instead of just using strings. Why not a date, or blob example added in. That would have made me drool over your tutorial.

  29. msihan rahuman
    September 15, 2017 at 18:20

    can you post the code

  30. Irfan Ahmed
    September 15, 2017 at 18:20

    Just in case anyone is using WPF, [DataGridView1.DataSource] will not work.
    Use [DataGridView1.ItemSource] instead. 

    thank you uploader for sharing. your videos are very helpful.

  31. Swap Softnic
    September 15, 2017 at 18:20

    how can we a setup of thıs also plz tell me.. and how to connect a database whıle setupıng

  32. Swap Softnic
    September 15, 2017 at 18:20

    how to store the ımage ın database and dısplay ıt….
    plz tell me plz……

  33. Manuel Cuevas
    September 15, 2017 at 18:20

    thanks you so much for share yours khowledge

    I want export worksheet excel to mysql database since visual basic

    how can do it  ?????

    please help me !!!!!!

  34. Kenneth Launce Consimino
    September 15, 2017 at 18:20

    Good day sir i was trying to do the things you said in this video, once i run the system there is statement said that " Object reference not set to an Instance of an object"

    here is the code

     Private Sub Load_table()
            MySqlConn = New MySqlConnection
            MySqlConn.ConnectionString = "server=localhost;userid=root;password=;database=student_attendance"

            Dim dbDataset As New DataTable
            Dim bSource As New BindingSource
            Dim SDA As MySqlDataAdapter

            Try
                MySqlConn.Open()
                Dim Query As String
                Query = "Select * from student_attendance.student"
                COMMAND = New MySqlCommand(Query, MySqlConn)
                SDA.SelectCommand = COMMAND
                SDA.Fill(dbDataset)
                bSource.DataSource = dbDataset
                DGStudent.DataSource = bSource
                SDA.Update(dbDataset)

                MySqlConn.Close()

            Catch ex As Exception
                MessageBox.Show(ex.Message)

            Finally
                MySqlConn.Dispose()

            End Try

    also the SDA has an error said that " variable SDA is used before it has been assigned a value. a null reference exception could result at runtime.

    so i put the Dim SDA as Mysqldataadapter in GLobal the error was gone, but the " Object reference not set to an Instance of an object" is still the problem please help me to solve this case thank you so much!

Leave A Comment

You must be logged in to post a comment.