VB.NET Tutorial - UPDATE a SQL Server Database - Part 3

In this VB.NET Database Tutorial, I will demonstrate how to UPDATE records in a Microsoft SQL Server database from your Visual Basic .NET application. We will continue building our simple user management system.

SOURCE CODE:

Thank you for your continued support! :-)

[ninetaledgundamx]

You are fricking amazing. I'm so glad you do this.

[claudioabado]

You are a very patient teacher -- thank you so much for sharing your hard-earned knowledge so generously

[noahb]

I love you. Please make more videos - If you write a book, I will buy it. If you create a video course, I will buy it.

[roadie]

Thank you for part 3.

I know I'm coming to this late, but it's still very useful to me. And, by the way, I think that "update query", "insert query", etc. are completely legitimate terms. I don't think that I've been corrupted by almost 30 years (yikes!) of using Access. I'm sure that I've heard the terms in T-SQL documentation and several other places over the years. I've a vague memory of using the terms around 1978/79.

[radiantpixelz]

You are a great teacher A BIG THANK YOU! please do more tutorials! :)

[tohnyjohnson]

5 year old video, but still worth a shot. :) I love how you setup all the SQL connections to run via the SQLControl, however every other tutorial out there has the SQL controls slapped in the main .vb file that they are working in, not a separate one. This is fine, but when you try to merge what they are doing with what you majestically did I often find myself tripping over the code. Currently I'm trying to do a bit of data validation and trying to use a SqlDataReader so I can check to see if a value exists in a table before creating a record. Each time I try I get error after error. I'm not sure how to merge a SqlDataReader in with your SQLControl. Again I absolutely loved your videos, they were so clear and easy to understand. I agree with the others if you made a course I would most certainly sign up for it.

[justanotherposter]

I want to thank you for your wonderful tutorials!  Very well explained, and provided me with real-world skills.  Your are obviously well versed with programming and very self-less.

[derricknkwain]

Thank you very much. This was really inspirational.

[filosk]

Thanks A lot for this tutorial has been great help.

[philipb]

Ben Roland-- I had the same issue and I solved it by moving the call to the "FetchUsers" sub above the "MdiParent = Form1" line.

[josephairo]

Requesting how to search data using textbox and populate the data to textbox directly without using the grouplist

[rolandsison]

Thanks for your tutorials..could you please do a tutorial on how to capture image from a webcam and save it on an sql database..

[tetheredend]

If I ever meet you, I'm buying you a beer!

[josephairo]

Hi, I am an able to get filter data using textbox and populate directly to textbox, you can assist there.

[jeanalainrim]

please VB Toolbox do you have any video where you teach how to deal with crystal reports???

[Kicajz]

Thank you very much!! But One question - how can I get the value to the comboBox from the database and also keep other options in the dropdownlist? I mean I have a comboBox with access types and I want to load the value for the specific user + having the other values so I can change the accessType for the user :)

[nanaqhuacy]

Thanks so much for these videos. I do have a problem though. I'm implementing your class in manipulating a database of my own. However when I tried to assign the value of an index(auto number) value captured after an ExecQuery command to a variable, it just wouldn't budge. Anything to help me out?

[mikegerow]

interestingly I have an exception that I cant figure out. I used a MySQL database on a remote server to connect to for testing. the error I am getting is "guid should contain 32 digits with 4 dashes" any ideas would be greatly appreciated.

[derricknkwain]

Please is there part 4 of this tutorial?

[mdkrush]

Great videos! Thanks.
I have one question. I am using ODBC to oracle and got everything works through your video using the odbc intead of sql, however, the params do not work. I can pass them but they have no value... I can't figure it out...