![VB Toolbox](/img/default-banner.jpg)
- 50
- 2 396 520
VB Toolbox
Приєднався 30 вер 2013
Welcome to the VBToolBox - your favorite resource for VB.NET tutorials! Okay... 'favorite' might be a stretch... ;-)
VBToolBox is dedicated (mostly) to providing educational resources and assistance to aspiring VB.NET programmers.
If you'd like to help us survive his new adventure, you can use PayPal to send some love:
www.paypal.me/Aardaerimus
“We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.”
Much love and gratitude for the support and helping us along! :-)
VBToolBox is dedicated (mostly) to providing educational resources and assistance to aspiring VB.NET programmers.
If you'd like to help us survive his new adventure, you can use PayPal to send some love:
www.paypal.me/Aardaerimus
“We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.”
Much love and gratitude for the support and helping us along! :-)
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! :-)
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)
This is an excellent video but I am using Visual Express 2022 and using Imports System.Data.SqlClient, but SqlConnection does not show up.
Got it, thanks for looking
Thank you for giving out simple instructions for easy understanding. I really like your channel.
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
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
Not working here.. Question what or where can I find a working internal or private IP address?
Thank you so much .................................!! You're doing a great help to the generations of learners
Please update dropbox link. It's not working.
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!
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!
Awesome tutorial! Very helpful and fun.
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.
Thank you so much. I hope you are doing very well.
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"?
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.
Welcome back!
Just started this SQL series of videos after your Access ones. Excellent and a lot to learn😊
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?
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.
@@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.
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.
@@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. :-)
Only 6 words! Thank you! Thank you! Thank you! 👍👍👍
You're very welcome! 😀 I'm happy that the videos were helpful.
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
Most of tutorials on UA-cam have videos where written items on screen are not clear that makes difficult for beginners
I do so much appreciate your tutorials .. you are a Excellent Teacher .. thank you
Can you give us a web api tutorial i love ur ways in teaching
welcome back
Glad to see you back 😍
Sequel..? Like in a film.? As apposed to SQL.
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 ?
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?
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?
This is fantastic. Could you please do a family tree structure?
great
please install vedio for this
how to connect sql server client/server application host data base
Excellent , very usefull👍
Promo*SM 😁
Its enough to set the form boderless, you dont need to make the control box and the text disappear all separately.
Is there any way we can modify to use sqlcontrol module for "BeginTransaction" Commit / rollback transaction?
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.
Kripya data reader ke bare mai bataye
ua-cam.com/video/M2jBvTUHXM0/v-deo.html
Great work! How do you call the new connection string?
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.
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.
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?
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?
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 😆
Hah! Then you're in good company. I refuse to grow up!
Thanks, still using your SQLControl example. Guess I need to update my code now with stored procedures.
Also make vdo on How to make a ini file to paramaterize the connection string to connect sql server .
You are just awesome
Superrrrr. Pls continue making vdo in this series
Glad to hear you again
Good work
Any books name any tips any advice becsuse when i watch your videos like i got very delious meal , really i love your work
Man man very good staf right here