VB.NET SQL Tutorial - Insert Images Into A SQL Server Database And Read (Visual Basic .NET) (Full)

[@GemSky-bc8lc]

I hope you doing well. You are amazing. Your tutorials never failed me. Thanks!

[@devindwight9272]

Luke, I find that one-liners are great, especially for huge projects with thousands of lines of code. When I code in any C language, I am forced to use strict coding habits such as multiLine if statments, I like that in VB I can consolidate those into one-liners. Also, lambda statements allow for powerful one-liner loops and such and take time to learn (and are useful once you do learn them!). All a matter of preference really. His coding habits are just fine lol. VB toolbox, thanks for another great video!

[@VBToolbox]

Devin Dwight Thanks, Devin! I always appreciate your feedback. :-D I do often find myself using some "bad practices", but that's what you tackle during the refining process, right? What programmer can possibly get it perfect the first time, 100% of the time? For me, I always strive to make my code smaller and in turn, more readable. One liners and lambdas are the cat's meow, if you ask me. :-D

[@terryk558]

Another great tutorial. Thank you very much for taking the time. Very informative. Glad you included the SQLConnect again, it is always helpful to repeat.

[@VBToolbox]

Terry K Thank you, Terry! :-) I appreciate the feedback and I'm happy that you found it helpful. I'm planning to do a second (short) release of this video for individuals that don't want an exhaustive app design video and just want the basic "How To" info.

[@김용재-r8i]

Thanks a lot for your kindness...But i was confused about SQLConnection because of missing the preprocessing course....control panel-fire wall... SQLSever attribute(security-server authorization -windows or SQLserver...restart SQL Server..)

[@johnday7362]

Really liked the FileStream info and demonstration. Although, I do not not think I will be putting binary image data into any databases in the future. I usually just upload the file to the server and reference the file path in the DB as you suggested.

[@benjohnlampitoc3947]

THIS IS GREAT! THANKS A LOT VBTOOLBOX! :)

[@bhathiyap]

HI., The lesson are really helpful ........ Thanks for sharing your knowledge and you will be a great great master with all blessings ....!!!

[@luisjoseruano5531]

Great video! Thanks for sharing. I need some advice from you. I want to fill the combobox but using the DataSource property because I usually use the .DisplayMember and .ValueMember properties in my projects and I found your SQL Querys methods easier than mine, so how do you fill the combobox using your SQLControl methods together with the DataSource, ValueMember, DisplayMember properties? Thanks for all.

[@dominicsarfo9894]

Please do cover Tutorials on other languages? like C# or ASP.net ? You guys are doing an awesome work!

[@johnday7362]

Mr. VB Toolbox. Would you please either zoom into the code or make the code font size bigger. It is very difficult for me to see the code as you are working on it. Thanks again for all of your hard work!

[@Rahul-lv8ip]

Wonderful tutorial & very useful. I am new to VB so surely would need your help to learn fast.

[@second-chance-tv-live]

Awesome tutorial. Kudos. I tried developing a similar project but with update images. When I change my picture and update, it updates only the first record image. Kindly assist me

[@MrAtlantis646]

Who can I do in the SQL connectionstring a dynamic user and password?

[@VBToolbox]

MrAtlantis646 You can easily modify or override the ConnectionString values. You can set the string as a public variable, or you can modify the Sub New() in the SQLControl to accept parameters and build it from there. Example: ' ALLOW CONNECTION STRING OVERRIDE Public Sub New(User As String, Pass As String) Dim strCon As String = String.Format("Server=MINECRAFT\SQLEXPRESS;Database=ImagesDB;User={0};Pwd={1};", User, Pass) DBCon = New SqlConnection(strCon) End Sub You can then call the New connection from your main form: Private SQL As New SQLControl("sa","Password1")

[@MrAtlantis646]

Thanks, that helped me :D

[@terchan1]

useful material!

[@VBToolbox]

I'm glad that you found it helpful, Terry. :-)

[@mustafa25804]

There is error message box says (ExecQuery Error: Login failed for user 'DBGuy') How can I solve it please ?

[@VBToolbox]

You need to use a user and password that have been granted access to your images database.

[@mustafa25804]

Thanks for your reply brother.

[@rowanlidbury]

Sequel..? Like in a film.? As apposed to SQL.

[@chinmaydixit9399]

Great Video. I have one problem. When database contains no image i.e. image column has a null value then I always get error : Parameter is not Valid. Kindly help me. Thank you in advance.

[@chinmaydixit9399]

Specifically , I got an Error in ms.readtimeout and ms.writetimeout.

[@socialtv8349]

great video fuckking keyboard sound :D

[@kenclemerbaltar532]

thank you for this tutorial another idea for my system project btw sir can u make a log in screen that blocks the task manager or other keys that can end a program like alt + f4 and such? continue the work appreciate it :)

[@VBToolbox]

Ken Clemer Baltar Sounds like a great idea for another tutorial or two! :-D I just made up a quick project and it's working well. I'm not sure about the login screen, however. Are you talking about an app login form or actual Windows login?

[@kenclemerbaltar532]

just a log in app a full screebed log in app VB Toolbox​

[@pokio55]

Do you have an email? I am a programmer that is learning the VB10 language and I hope I can ask you a few questions regarding VB codes and commands

[@VBToolbox]

michael pizzo I sure do. I can't always promise a rapid or complete response, but I will do my best to help as I'm able. :-) I'll PM you the address.

[@pokio55]

Thank you!

[@banodotaclips]

the sound is being heard in advance while the video is late

[@banodotaclips]

but still a great tutorial!

[@lukebrown2597]

No offence, but you have really really bad coding habbits. That your one line if statement is not good

[@VBToolbox]

Luke Brown Hello, Luke. I can certainly appreciate a differing approach to coding. I think that it depends heavily upon your school of thought. For me, personally, the benchmarks that I measure my code against are: *Functionality* - Does it work? *Efficiency* - How elegant is the code and how fast does it run? *Readability* - Does this make it more or less readable? I always first strive to "make it work" and then I try to revise the code to make it smaller, more efficient, and more readable. Of course that doesn't necessarily mean that my way is the best way. I love one-liner IFs and I feel that they're effective and very readable so long as you don't cram too many statements into a single line.

[@lukebrown2597]

VB Toolbox I understand, your one line Ifs are fine, but it's when you extend them by using ":" that's when it's not so good. But nether the less, great videos, I used to learn a lot from you before when I started programming and when I needed help with SQL stuff, one of the videos you did in the past really helped me understand things like CustomEvents, SQL Server stuf. Keep it up. One suggestion though.. Make your videos much shorter, 2hours is too much for the average guy. Try something that's a little under 10 minutes. Just break them down into segments, like part 1, part 2, part 3 etc. Anyway good luck :)

[@VBToolbox]

Luke Brown I do try my best to be discerning about how I use the one-liners (not cramming too much into one line, extending off the side, etc.). Using it for short messages, exits, etc. is great and can dramatically reduce the number of lines in larger projects and help keep things readable. As for the video length, this is something I really struggle with and it's sort of a catch 22. I've had many viewers tell me that the tutorials are too long and at the same time others who tell me they're too short and I didn't explain enough. 2 hours is definitely insane, so my plan was to release a short "quick and dirty" version of this video with just the essential parts. I really do appreciate the constructive criticism and feedback! :-)

[@dominicsarfo9894]

Please do cover Tutorials on other languages? like C# or ASP.net ? You guys are doing an awesome work!