VB.NET Tutorial - Using SQL Stored Procedures - PART 5

[@k1ng50]

Thanks for the nice presentation. It has been 5-6 years since I last created stored procedures, so this jostled my brain and shook off some of the cobwebs. Thanks!

[@GeorgeArmfield]

Hes back!

[@jeffmurphy2208]

Your tutorials helped me so much. They opened the door to a ton of knowledge and allowed me to advance my career in a major way. Thank you!!

[@VBToolbox]

It always makes me happy to read comments like this. Thank you, Jeff! I'm very glad the tutorials have been helpful. 🙂

[@mrzaboor]

Glad to hear you again

[@raizriyal84]

Wow, nice to see ur videos again.. thank u

[@macrobody]

Thanks, still using your SQLControl example. Guess I need to update my code now with stored procedures.

[@PauloDoutel]

Hi.. I love your tutorials... Thanks from Portugal... Huge hug... 🤗🤗🤗

[@VBToolbox]

Thank you, Paulo! I'm glad the tutorials are helpful. 😀

[@earavichandran]

Wow.... Welcome back sir....

[@VBToolbox]

Thank you, Ravichandran!

[@jmgacousticmusic]

Great to get a new notification. Hope you are well

[@VBToolbox]

I'm busy but doing well. Thank you, James!

[@BijuVarghese]

Superrrrr. Pls continue making vdo in this series

[@aymanabdullah813]

Glad to see you back 😍

[@pw3111]

Welcome back!

[@abastein2000]

Wellcome back !

[@VBToolbox]

Thanks, abastein2000!

[@mohammadnoman9591]

welcome back

[@FernandoSLima]

Glad to hear you again...

[@serkancanbaz1]

Heyy welcome bro. We miss you.🎉❤

[@VBToolbox]

Thank you, Serkan! 🙂

[@johnnyhermes]

Yessssss.... he is back!

[@johnnyhermes]

I am already looking forward to the next video!

[@VBToolbox]

I'm not even sure what I'm going to do yet. It's been so long since I've done this and I'm super rusty. 😅

[@BijuVarghese]

You are just awesome

[@rayt6867]

Hello and many thanks for these exceptional videos, you are the only one that I know off that makes a DBControl class to handle database operations. I didn't know the ExecuteQuery handles CRUD operations. Now I know thanks to you. Please, could it be possible that you can create a video(s) using two or more tables with 1-to-many relationships using DBControl. It will be greatly appreciated.

[@VBToolbox]

I'm very sorry for the super late reply. I didn't receive a notification about your question. By now, you have likely already figured out how to do this, but the DBControl as is will handle table joins within your query string. It is, however, preferred that this be done within your Stored Procedure instead of within the query string.

[@vinnypassmore5657]

Thankyou so much :), thanks for sharing.👌

[@VBToolbox]

Sure thing, Vinny! 😁

[@dimzt]

Thank you sir!

[@aymanabdullah813]

Can you give us a web api tutorial i love ur ways in teaching

[@borisslezinger474]

Do you have tutorial to use SQL Store Procedure with output parameters?

[@iwakmangot214]

long time no see :) thanks to your video long time ago, i've won 3 competition, first is regional using vb, then state/province using the evolved vb that is c#, and last one is national using c# and kotlin. and now im an aspiring programmer on college(⁠ ⁠╹⁠▽⁠╹⁠ ⁠) once again thanks a lot!

[@VBToolbox]

Wow! Congratulations on your many successes! I'm so glad the videos were a helpful start for you.

[@BijuVarghese]

Also make vdo on How to make a ini file to paramaterize the connection string to connect sql server .

[@BijuVarghese]

Is there any way we can modify to use sqlcontrol module for "BeginTransaction" Commit / rollback transaction?

[@VBToolbox]

So sorry for the way late reply. For some reason I didn't get notified. I'm fairly certain I tested this years ago and it worked, but is probably best implemented within your stored procedure. Unfortunately, I don't have any examples as I haven't tested this for years.

[@shaktidevelops]

Please update dropbox link. It's not working.

[@VBToolbox]

Hi there, @shaktidevelops! I have updated the Dropbox link with the Part 5 source code: www.dropbox.com/scl/fi/62r9kltm4d194x4f3cl2v/SQLTutorial-PT5.zip?rlkey=e60ij41lefzl47qf4jtt466gb&dl=0 I hope it helps!

[@derrickwalker3018]

Thanks for the video. I'm having trouble getting to the download for this session. Is it possible you can take a look at it because I'm having some trouble getting it to work?

[@VBToolbox]

Hi, Derrick! Sorry, I just noticed that the download link on the video is for Part 4. I didn't add a download for this video. Unfortunately, my internet is down and I'm awaiting replacement parts. Are you having trouble with any part in particular?

[@derrickwalker3018]

@@VBToolbox I think that I figured it out :-). I would like some help using the New Connection string, however. I can't seem to figure that part out. BTW, a donate button would be cool because you're helped me greatly and I wouldn't mind donating to your continued success.

[@doreymorre6035]

Promo*SM 😁