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

[@jhoevenengcong2845]

For all the KZbin tutorial how to display data from the database, This is the only video that is working for me

[@thurmanjenner1745]

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.

[@jerlynpaguio8860]

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

[@oshonewman7066]

you are awesome, brilliant. Incredible is your way to explain, ur knowledge. thanx thanx thanx a thousand times...

[@Iarksys]

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.

[@jerrylopez6240]

Hi good sir . Thank you so much about this tutorial . it help me so much .. I hope u dont stop uploading Videos.

[@mohamedelahbibbourhroum6127]

Franchement , tu 'es le meilleur , respect pour toi , et à ta manière d'expliquer :)

[@abithakp3073]

Thank u so much... This was really helpful❤

[@OfficialLogisharp]

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

[@MJB94]

Hi ... Thank you ... your tutorials Are so good for me ;) you explain every thing very well .... please keep going .

[@HaredMeza]

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

[@ProgrammingKnowledge]

[@pravinhirani7422]

hi there, can we add into labels instead of using a datagrid

[@volikoto]

Thank You, you saved my dilemma.

[@kennethlaunceconsimino7948]

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!

[@knutanders95]

"Dim SDA As MySqlDataAdapter" will only set the datatype for SDA. Maybe you should try "Dim SDA As New MySqlDataAdapter" or "Dim SDA As MySqlDataAdapter = new MySqlDataAdapter" instead? =)

[@kennethlaunceconsimino7948]

thank you sir i already solve this problem, i use form class as a connection for my datagrid, but i really appreciate your response, sir maybe you can help me with my problem in my thesis, my system is attendance monitoring using RFID Scanner, my problem is the condition on how to get the time in and time out in ever tap of ID and also to save and retrieve Picture in my SQL database.. hope you can help me with this matter.. thank you

[@knutanders95]

I dont know to mach about this subject, maybe you should try stackowerflow?

[@TechNicksGaming]

How did u solve this problem? I have this problem too.... help me please thanks...

[@Iarksys]

jerico olino : Dim SDA As New SqlDataAdapter

[@sarragarobert25]

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

[@ajsantos3739]

How about if I just want the table to appear right away after opening the Form? Is possible without the 'Load Table' button? Please answer

[@joffpascual]

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

[@michaeljeromemamauag2836]

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!!!

[@zazafeur3467]

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

[@mohammedradman4575]

how i can conuct the database oracle 10g with vb.net in network. please help meet do that.

[@iamelyhk3578]

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

[@rahulchaturvedi9094]

This is really helpful..thanks!

[@MhikzTatz]

can you load access mdb instead of sql sir?

[@2009Edifer]

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.

[@premdangle4801]

sir why u use sda.update(dbDataset)

[@nicolascapistrano6813]

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

[@moniquenoche]

My error is column count doesn't match value count at row 1. this is my code ---- Query = "INSERT INTO sampledatabase.sampletable (id, name, place) values(' ', ' ', ' ');" is this correct? bec you didnt show the right side of the vids. Thank you

[@salwahamim531]

Can i show the database tables without the button clicking "Load data"?

[@atheistapostate7019]

I keep getting an error "cannot find column" For my textbox used... ' Search Box for searching MICR Results Dim DV As New DataView(dbDataSet) DV.RowFilter = String.Format("CompanyName like '%{0}%'", TextBox21.Text) DataGridView1.DataSource = DV And "Dim dbDataSet As New DataTable" declared under Public Class Form 2 where the code is. I have my system.data.sqlclient (Using SQLClient over MySql)

[@sakethk3487]

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

[@manuelcuevas3115]

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 !!!!!!

[@thurmanjenner1745]

Manuel Cuevas You would need to load the dataGridView with Excel first, then have a button to save (insert) data to mysql. To connect with excel you will need something like the following... If Textbox1.Text = Nothing Then Dim Xconn As OleDbConnection Dim str As String Dim cmd As OleDbCommand Dim da As OleDbDataAdapter Dim table As DataTable = New DataTable() Xconn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test\jobcardreg.xlsm;Extended Properties=""Excel 12.0 Macro;HDR=YES"";") ' str = "Select * From [Sheet1$]" cmd = New OleDbCommand(str, Xconn ) da = New OleDbDataAdapter(cmd) Xconn .Open() da.Fill(table) Me.DataGridView1.DataSource = table Else Dim dt As New DataTable() dt = TryCast(DataGridView1.DataSource, DataTable) If dt IsNot Nothing Then dt.DefaultView.RowFilter = String.Format("fieldname = '{0}'", Trim(Textbox1.Text)) End If End If

[@Rockajm]

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

[@kumarsanu8881]

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

[@kiriyusuna8046]

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!

[@kumaresanmurugan1262]

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

[@swapsoftnic7477]

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

[@suyashdongre]

Thank You So Much!

[@manojkumarravidas4981]

sir how can see your previous video

[@yoelbm]

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

[@thegreatplanet5024]

Make identify inset bro ...this will retrive next number of id automatically 😂..smile if you got me

[@rinceleung]

Thank you very much.

[@SAJITHMU]

I got error -The given key was not present in the dictionary.-

[@swapsoftnic7477]

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

[@thurmanjenner1745]

omkar fatale I do, with little performance drop. I have up to 12 images stored for each part (1000's) in my database. What I did was put all images into it's own Database so that it can be transferred to an additional deticated drive when I can get around to buying one of those handy 6tb drives for $250. So yes, I would also like to know how I can store images without having to go through a "addWithValues' routine. What you propose is not as easily done when you are running mysql on Ubuntu Server. Where would you put your images so they can be referenced? Keep in mind that I will be rewriting this in PHP as well so that it will be compatible for our Macs as too.

[@thurmanjenner1745]

Swap Softnic Take a look at this, see if it helps. (SPECIAL NOTE: Images must be set to no lower than MEDIUMBLOB in MySQL Datatype. Simply using BLOB will only give you the top pixels of an image, not the whole image.) Using MySqlConn As New MySqlConnection(connectionString) Dim Query As String Query = "INSERT INTO MOCA.photos (id,Link_id,img,Primary) " & "VALUES (@myid,@myLink_id,@myIMG,@myPrimary)" Dim mstream As New System.IO.MemoryStream() PictureBox1.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg) Dim arrImage() As Byte = mstream.GetBuffer() mstream.Close() Using COMMAND As New MySqlCommand() With COMMAND .CommandText = Query .Connection = MySqlConn .Parameters.AddWithValue('@myid', TextBoxID.Text) .Parameters.AddWithValue("@myLink_id", TextBoxLinkID.Text) .Parameters.AddWithValue("@myIMG", arrImage) Dim pi As Char If CheckBox1.Checked Then pi = "Y" Else pi = "N" .Parameters.AddWithValue("@myPrimary", pi) End With Try MySqlConn.Open() COMMAND.ExecuteNonQuery() Catch ex As Exception MsgBox("MySQL Exception has occured with message: " & ex.Message & vbCr & ex.Data.ToString & vbCr & "Line not added to dataset!") Finally MySqlConn.Close() MySqlConn.Dispose() End Try End Using End Using

[@jackdog2759]

help sir, "Unable to convert MySQL date/time value to System.DateTime

[@Mhajjar92]

i cant use BindingSource, you always dont mention how you declare your arguments and commands, if you can always show how u declare everything because beginners like me will not know how to do anytthing with ur code

[@charlitomondragon1451]

how to fetch all values in names column vb.net

[@twinkledawani450]

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

[@reactionvideo3395]

Why did you update in SDA.

[@deepakthapa9528]

Dim dbSetData as DataTable = New DataTable .... for avoiding warning.. :p

[@kenz1841]

I am having duplicate value in mydatagridview anyone help!!

[@jadesunga8876]

pre, pano mo nasolusyunan ?

[@janvidhonde3407]

I want the source code can u provide it?

[@flobamorabajawa8373]

erro SDA is not accessible help me

[@ShahriyarSaqif]

plz share the project file for practice...

[@carl348]

thanks bruh

[@itsjustme5022]

tnx man.. :)

[@330thSion]

It says that "The host localhost does not support SSL connections." Hellllllp

[@msihanj]

can you post the code

[@ManashSarma]

The video did not work my system

[@lorddraagon]

you pronounce "Data" in a funny way