VB Toolbox
VB Toolbox
  • 50
  • 2 396 520
VB.NET Tutorial - Using SQL Stored Procedures - PART 5
In this VB.NET database tutorial, I will demonstrate how to use parameterized SQL stored procedures with your SQLControl class in your Visual Basic .NET application.
PART 5 PROJECT SOURCE CODE:
www.dropbox.com/scl/fi/62r9kltm4d194x4f3cl2v/SQLTutorial-PT5.zip?rlkey=e60ij41lefzl47qf4jtt466gb&dl=0
Thank you for supporting this channel! :-)
Переглядів: 3 530

Відео

VB.NET Tutorial - DELETE Records From a SQL Server Database - Part 4
Переглядів 17 тис.7 років тому
In this VB.NET database tutorial, I will demonstrate how to delete records from a Microsoft SQL Server Database using your Visual Basic .NET application. Additionally, we will learn how to dynamically generate a parameterized batch deletion command using a CheckedListBox control. SHORTCUTS: 5:05 - Creating a Delete command 10:00 - Building a dynamic parameterized command generator PROJECT SOURC...
VB.NET Tutorial - UPDATE a SQL Server Database - Part 3
Переглядів 23 тис.7 років тому
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: www.dropbox.com/s/k3lvnlcgrmi8djz/SQLTutorial PT3.zip?dl=0 Thank you for your continued support! :-)
VB.NET Tutorial - INSERT records into a SQL Server Database - Part 2
Переглядів 41 тис.7 років тому
In this VB.NET Database Tutorial, I will demonstrate how to INSERT records into a Microsoft SQL Server database from your Visual Basic .NET application. For illustration, we will begin building a simple user management system. I will also explain various methods of returning the identity value of the last inserted record. SHORTCUTS: 9:58 Creating a parameterized INSERT method 24:00 Error testin...
VB.NET Tutorial - Connect & Query a Microsoft SQL Server Database - Part 1
Переглядів 223 тис.7 років тому
In this VB.NET Database Tutorial, I will show you how to connect and query a Microsoft SQL Server database from your Visual Basic .NET application. We will build an improved connection control class for simplified access to our database. Additionally, we will create a database search feature with wildcard support and populate a DataGridView and ComboBox with a database query. SHORTCUTS: 0:25 Pr...
VB.NET MDI Forms Tutorial - Forms within a Form
Переглядів 82 тис.8 років тому
In this beginner vb.net tutorial I will demonstrate how to use the Multi Document Interface, or "MDI Forms" to create a form within a form effect in your application. Additionally, I will demonstrate how these forms can communicate with each other and how you can access the mdiContainer to manipulate batches of child forms. Project Source Code: www.dropbox.com/s/eqz2ejbvlgyt3i9/mdiTut.zip?dl=0
VB.NET Tutorial - Dynamic Queries With An Access Database
Переглядів 21 тис.8 років тому
In this VB.NET database tutorial, I demonstrate how to use OleDB's GetSchema method to construct dynamic database queries and gather database information. As a bonus, I also demonstrate how to Create and Drop tables in an Access database using Visual Basic .NET. PROJECT SOURCE CODE: www.dropbox.com/s/fwhe9kgh2cosekh/MSAccessDynamicQuery.zip?dl=0 Thank you for supporting this channel!
VB.NET Tutorial - Drag and Drop
Переглядів 27 тис.8 років тому
In this Visual Basic .NET tutorial, I will show you how to easily add Drag and Drop functionality to your application and how to use Drag and Drop to create a simple program and file launcher. PROJECT SOURCE CODE: www.dropbox.com/s/bgpmjw8e6ziims4/DragDropTut.zip?dl=0 Thank you for supporting this channel! :-)
VB.NET Tutorial - Update Records In An Access Database
Переглядів 32 тис.8 років тому
Series Part 4 - In this VB.NET tutorial I will show you how to edit and update records in a Microsoft Access Database. I will also demonstrate how to load database results into textboxes and other form controls and cycle through your record set. PROJECT SOURCE CODE: www.dropbox.com/s/x1r3xqa2cn9gzf5/MSAccessUPDATE.zip?dl=0 Thank you for supporting this channel!
VB.NET Tutorial - Delete Records From a Microsoft Access Database
Переглядів 19 тис.8 років тому
This is Part 3 in my VB.NET series on working with a Microsoft Access Database. In this tutorial I will be demonstrating how to Select and Delete records in your MS Access Database using a DataGridView as well as a ComboBox control. Project Source Code: www.dropbox.com/s/s1y6uyq0caiwpju/MSAccessDELETE.zip?dl=0 Thank you for supporting this channel!
VB.NET Tutorial - INSERT Records Into a Microsoft Access Database
Переглядів 39 тис.8 років тому
This is Part 2 in my series on working with a Microsoft Access Database in Visual Basic .NET. In this tutorial we will design a simple form to easily insert records into our database. PROJECT SOURCE CODE: www.dropbox.com/s/i5bd1i6qoj2o533/MSAccessINSERT.zip?dl=0 PART 1 - Connect & Query Microsoft Access With VB.NET: ua-cam.com/video/q19OXha1jDw/v-deo.html Thank you for supporting this channel! :-)
VB.NET Access Database Tutorial [SEGMENTED] Connect & Query MS Access Database [4 of 4]
Переглядів 4 тис.8 років тому
[SEGMENTED TUTORIAL - PART 4] In this VB.NET database tutorial, I will show you how to connect to and query a Microsoft Access database and return your query results to a DataGridView and a ComboBox. Additionally, I will show you how to create a Wildcard search engine for your database. FULL TUTORIAL: ua-cam.com/video/q19OXha1jDw/v-deo.html PROJECT RESOURCES: Access Database Engine 2010 Redistr...
VB.NET Access Database Tutorial [SEGMENTED] Connect & Query MS Access Database [3 of 4]
Переглядів 4 тис.8 років тому
[SEGMENTED TUTORIAL - PART 3] In this VB.NET database tutorial, I will show you how to connect to and query a Microsoft Access database and return your query results to a DataGridView and a ComboBox. Additionally, I will show you how to create a Wildcard search engine for your database. FULL TUTORIAL: ua-cam.com/video/q19OXha1jDw/v-deo.html PROJECT RESOURCES: Access Database Engine 2010 Redistr...
VB.NET Access Database Tutorial [SEGMENTED] Connect & Query MS Access Database [2 of 4]
Переглядів 5 тис.8 років тому
[SEGMENTED TUTORIAL - PART 2] In this VB.NET database tutorial, I will show you how to connect to and query a Microsoft Access database and return your query results to a DataGridView and a ComboBox. Additionally, I will show you how to create a Wildcard search engine for your database. FULL TUTORIAL: ua-cam.com/video/q19OXha1jDw/v-deo.html PROJECT RESOURCES: Access Database Engine 2010 Redistr...
VB.NET Access Database Tutorial [SEGMENTED] Connect & Query MS Access Database [1 of 4]
Переглядів 9 тис.8 років тому
[SEGMENTED TUTORIAL - PART 1] In this VB.NET database tutorial, I will show you how to connect to and query a Microsoft Access database and return your query results to a DataGridView and a ComboBox. Additionally, I will show you how to create a Wildcard search engine for your database. FULL TUTORIAL: ua-cam.com/video/q19OXha1jDw/v-deo.html PROJECT RESOURCES: Access Database Engine 2010 Redistr...
VB.NET Tutorial - Connect & Query a Microsoft Access Database [FULL]
Переглядів 142 тис.8 років тому
VB.NET Tutorial - Connect & Query a Microsoft Access Database [FULL]
VB.NET Tutorial - Mass Property Changes on Form Controls
Переглядів 9 тис.9 років тому
VB.NET Tutorial - Mass Property Changes on Form Controls
VB.NET Beginner Tutorial - Start and Kill Programs and Processes (Visual Basic .NET)
Переглядів 27 тис.9 років тому
VB.NET Beginner Tutorial - Start and Kill Programs and Processes (Visual Basic .NET)
VB.NET Tutorial - INSERT Images Into a SQL Server Database (SHORT)
Переглядів 10 тис.9 років тому
VB.NET Tutorial - INSERT Images Into a SQL Server Database (SHORT)
VB.NET SQL Tutorial - Insert Images Into A SQL Server Database And Read (Visual Basic .NET) (Full)
Переглядів 24 тис.9 років тому
VB.NET SQL Tutorial - Insert Images Into A SQL Server Database And Read (Visual Basic .NET) (Full)
VB.NET Tutorial - Transparent and Windowless Forms With Movement (Visual Basic .NET)
Переглядів 12 тис.9 років тому
VB.NET Tutorial - Transparent and Windowless Forms With Movement (Visual Basic .NET)
VB.NET Tutorial - SQL Database Search Form With Wildcards (Visual Basic .NET)
Переглядів 16 тис.9 років тому
VB.NET Tutorial - SQL Database Search Form With Wildcards (Visual Basic .NET)
VB.NET Beginner Tutorial - Subs vs Functions & Building a Real-Time Calculator (Visual Basic .NET)
Переглядів 14 тис.9 років тому
VB.NET Beginner Tutorial - Subs vs Functions & Building a Real-Time Calculator (Visual Basic .NET)
VB.NET Tutorial - Create and Handle Custom Events (Visual Basic .NET)
Переглядів 38 тис.10 років тому
VB.NET Tutorial - Create and Handle Custom Events (Visual Basic .NET)
VB.NET Database Tutorial - Update a Database From a DataGridView (Visual Basic .NET)
Переглядів 93 тис.10 років тому
VB.NET Database Tutorial - Update a Database From a DataGridView (Visual Basic .NET)
VB.NET Database Tutorial - Fill ComboBox From SQL Database & Dynamic Query (Visual Basic .NET)
Переглядів 61 тис.10 років тому
VB.NET Database Tutorial - Fill ComboBox From SQL Database & Dynamic Query (Visual Basic .NET)
VB.NET Tutorial For Beginners - Simple Picture / Image Viewer (Visual Basic .NET)
Переглядів 10 тис.10 років тому
VB.NET Tutorial For Beginners - Simple Picture / Image Viewer (Visual Basic .NET)
VB.NET Database Tutorial - Prevent SQL Injection With Parameterized Queries (Visual Basic .NET)
Переглядів 21 тис.10 років тому
VB.NET Database Tutorial - Prevent SQL Injection With Parameterized Queries (Visual Basic .NET)
VB.NET Tutorial - Dynamic Arrays (Visual Basic .NET)
Переглядів 16 тис.10 років тому
VB.NET Tutorial - Dynamic Arrays (Visual Basic .NET)
VB.NET Tutorial - Create a DLL / Class Library (Visual Basic .NET)
Переглядів 86 тис.10 років тому
VB.NET Tutorial - Create a DLL / Class Library (Visual Basic .NET)

КОМЕНТАРІ

  • @dickevans1427
    @dickevans1427 8 днів тому

    This is an excellent video but I am using Visual Express 2022 and using Imports System.Data.SqlClient, but SqlConnection does not show up.

  • @10Uwatch
    @10Uwatch 8 днів тому

    Thank you for giving out simple instructions for easy understanding. I really like your channel.

  • @revram79
    @revram79 Місяць тому

    I Really Like Your Tutorial, it's very easy to understand. especially for beginners. Thank you.. and I hope your channel will grow even more

  • @dylanobrien462
    @dylanobrien462 Місяць тому

    It doesn't seems to be working for me the client says connected but the text never makes it to the server i also tried downloading the code files here and they were exactly the same where the text when away but never ended up at the server

  • @jansterenborg
    @jansterenborg 3 місяці тому

    Not working here.. Question what or where can I find a working internal or private IP address?

  • @leansixsigmabusinessoperat4833
    @leansixsigmabusinessoperat4833 3 місяці тому

    Thank you so much .................................!! You're doing a great help to the generations of learners

  • @shaktidevelops
    @shaktidevelops 4 місяці тому

    Please update dropbox link. It's not working.

    • @VBToolbox
      @VBToolbox 4 місяці тому

      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!

  • @k1ng50
    @k1ng50 5 місяців тому

    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!

  • @k1ng50
    @k1ng50 5 місяців тому

    Awesome tutorial! Very helpful and fun.

  • @k1ng50
    @k1ng50 5 місяців тому

    Thank you very much for a well-organized, clear tutorial. I did a lot of VB4 programming in the 1990s but none since. I retired a few years ago and wanted to resurrect and continue a project I did back then. This video served as a great refresher and I am ready to continue your series.

  • @RXY7
    @RXY7 6 місяців тому

    Thank you so much. I hope you are doing very well.

  • @TheFaximana
    @TheFaximana 7 місяців тому

    great video - I've got a question: I have quite the same task, but my "drop-button" is inside of a a panel which is inside of a tab-control inside the form.. just when dragging the file over the form/tab-control/panel the mousepointer changes to a prohibition sign - my question is if I Do have do declare the whole form/tab-control/panel as "allow drop"?

  • @pw3111
    @pw3111 7 місяців тому

    As Visual studio no longer supports local database in Add, New Item, Data, and System.Data.sqlserverce is not on the Reference list, it took a bit of working out to get a sdf file written but perseverance paid off. Thanks again for your efforts.

  • @pw3111
    @pw3111 7 місяців тому

    Welcome back!

  • @pw3111
    @pw3111 7 місяців тому

    Just started this SQL series of videos after your Access ones. Excellent and a lot to learn😊

  • @pw3111
    @pw3111 7 місяців тому

    I've got a problem with the delete by dgvData_CellClick method. If I click off the actual values I get the following error message System.InvalidCastException: 'Conversion from type 'DBNull' to type 'String' is not valid.' I was under the impression that your " ' PREVENT OUT OF INDEX RANGE ERRORS If e.RowIndex < 0 Or e.ColumnIndex < 0 Then Exit Sub" would handle it but it doesn't seem to be. Any suggestions?

    • @VBToolbox
      @VBToolbox 7 місяців тому

      Hi, @pw3111! The index out of range prevention is only to handle errors when clicking to the far top or left where a negative index value was produced. The casting error you're seeing seems more related to the actual data in your dgv or database where it's trying to translate or do something with a NULL record from your table. Are you using this for another project or just copying the tutorial? It's a little tricky to troubleshoot without seeing the code and data and I'm a little rusty, but if it's a small project you could share, I can see if I can figure out the issue.

    • @pw3111
      @pw3111 7 місяців тому

      @@VBToolbox on my access data base, there is a blank row at the bottom with a * on the far left. This is where a new entry will go and is present on all Access databases I build. It’s when I Click into this row that the error occurs. On your “delete “ example program, there is no blank line at the bottom of your database so there is nothing to click into to cause the error. How did you accomplish this as all my databases have this empty bottom row? I can hide this bottom row by choosing “Addaddition=false” in the database properties but then I can’t enter a new record. Thanks for any help.

    • @pw3111
      @pw3111 7 місяців тому

      Problem solved!, On datagridview for my delete forms, I clicked on the top right hand corner of the datagridview and unchecked the “enable adding” option. I left it checked on the any forms where I wanted to add data. Once again your videos have been very educational and your replies have been very helpful as well as they point me in the right direction and make me think. Thanks.

    • @VBToolbox
      @VBToolbox 7 місяців тому

      @@pw3111 Hello! Sorry I wasn't able to get back earlier. That is great news that you were able to resolve the issue! Thank you for sharing the resolution. It may be helpful in the event that someone else encounters something similar. :-)

  • @trollstrings
    @trollstrings 7 місяців тому

    Only 6 words! Thank you! Thank you! Thank you! 👍👍👍

    • @VBToolbox
      @VBToolbox 7 місяців тому

      You're very welcome! 😀 I'm happy that the videos were helpful.

  • @pw3111
    @pw3111 7 місяців тому

    Thanks you for a great series of videos. I’ve used your methods on a number of programs I use at home. Is it possible to set up a DBControl Class using Excel instead of Access as I’d like to replicate your programs for my daughter but using an Excel Spreadsheet as that’s what she receives from the head company. She doesn’t have the ability to change to Access Thanks for any advice

  • @lifeonearth7040
    @lifeonearth7040 8 місяців тому

    Most of tutorials on UA-cam have videos where written items on screen are not clear that makes difficult for beginners

  • @user-kb6zw4ip1i
    @user-kb6zw4ip1i 10 місяців тому

    I do so much appreciate your tutorials .. you are a Excellent Teacher .. thank you

  • @aymanabdullah813
    @aymanabdullah813 11 місяців тому

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

  • @mohammadnoman9591
    @mohammadnoman9591 11 місяців тому

    welcome back

  • @aymanabdullah813
    @aymanabdullah813 Рік тому

    Glad to see you back 😍

  • @rowanlidbury
    @rowanlidbury Рік тому

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

  • @Chris-by8eh
    @Chris-by8eh Рік тому

    when starting out I never know what namespaces I should be added in. like in this example the drawing space ? is there a cheat sheet on namespaces and what they are used for ?

  • @technousr
    @technousr Рік тому

    This was an awesome tutorial as I appreciate the details that you go through. I did have one follow up question regarding the AuthUser variable and how it would be used. After the user has been authenticated, what would you need to use the AuthUser variable for since you are using a system account to execute any SQL with the database?

  • @truediamant777
    @truediamant777 Рік тому

    can you make the background image transparent? i want a base project that is an invisible window which will display content, maybe using another rectangle object would do?

  • @jasonport6691
    @jasonport6691 Рік тому

    This is fantastic. Could you please do a family tree structure?

  • @hemendrapadia7709
    @hemendrapadia7709 Рік тому

    great

  • @bdeealmamry9557
    @bdeealmamry9557 Рік тому

    please install vedio for this

  • @bdeealmamry9557
    @bdeealmamry9557 Рік тому

    how to connect sql server client/server application host data base

  • @ericamaya1449
    @ericamaya1449 Рік тому

    Excellent , very usefull👍

  • @doreymorre6035
    @doreymorre6035 Рік тому

    Promo*SM 😁

  • @BurkhardusX
    @BurkhardusX Рік тому

    Its enough to set the form boderless, you dont need to make the control box and the text disappear all separately.

  • @BijuVarghese
    @BijuVarghese Рік тому

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

    • @VBToolbox
      @VBToolbox 4 місяці тому

      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.

  • @gopalvarshney7126
    @gopalvarshney7126 Рік тому

    Kripya data reader ke bare mai bataye

  • @morelearna2101
    @morelearna2101 Рік тому

    ua-cam.com/video/M2jBvTUHXM0/v-deo.html

  • @derrickwalker3018
    @derrickwalker3018 Рік тому

    Great work! How do you call the new connection string?

  • @rayt6867
    @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
      @VBToolbox 4 місяці тому

      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.

  • @derrickwalker3018
    @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
      @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?

  • @Mark-kh1ny
    @Mark-kh1ny Рік тому

    I laughed like a small boy when you wrote pubic. I don’t know what’s wrong with me. Maybe I never will really grow up 😆

    • @VBToolbox
      @VBToolbox Рік тому

      Hah! Then you're in good company. I refuse to grow up!

  • @macrobody
    @macrobody Рік тому

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

  • @BijuVarghese
    @BijuVarghese Рік тому

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

  • @BijuVarghese
    @BijuVarghese Рік тому

    You are just awesome

  • @BijuVarghese
    @BijuVarghese Рік тому

    Superrrrr. Pls continue making vdo in this series

  • @mrzaboor
    @mrzaboor Рік тому

    Glad to hear you again

  • @baherwahby22
    @baherwahby22 Рік тому

    Good work

  • @baherwahby22
    @baherwahby22 Рік тому

    Any books name any tips any advice becsuse when i watch your videos like i got very delious meal , really i love your work

  • @baherwahby22
    @baherwahby22 Рік тому

    Man man very good staf right here