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 Preparing the database
15:34 Creating your application
26:35 Building your SQL Control Class
1:06:00 Using the SQL Control Class
1:09:10 Query SQL to a DataGridView
1:16:33 Building a parameterized search with wildcard support
1:24:04 Populate a ComboBox with SQL Query results
1:30:30 Error Testing
PROJECT SOURCE CODE:
https://www.dropbox.com/s/80025odtkctqwza/SQLTutorial%20PT1.zip?dl=0
Thank you for your support!
Amazon Auto Links: No products found.
nice a new video 🙂
Thanks for these videos!! I’ve been using them for my job and they’ve helped me tons!! you’re the best!
Thank you for nice tutorial.
I just discovered your channel and Holy adsadjaskdsajd you are saving my life now. I wonder why you don’t get million of views! Thank you so much bro
Hi, im getting this errror Login Failed for User ‘tutorial’… can you help me with this error.. thank you
Your BACK!!! Wonderful videos!!!
Thanks for posting them… So helpful.
Thanks for sharing knowledgeable video. You are an Erudite Person. Can you please help in to use the program to get multiple return parameters.
Excellent material and presentation. Helping me quite a bit. Quick question: Do you have a video showing how to convert the ExecQuery sub into an ExecSP (stored procedure) sub? I have toyed with it a bit, seems that the trick is to change the command object and to handle the parameters. i seem to be deficient with regard to the latter.
Hi, thanks very much for sharing your work! It’s incredibly helpful. Do you if you could use your SQLControl class for an ODBC connection?
Thanks!
dude i love you so much right now, you just saved me from the fucking assignment. thank godness i find you here
awesome tutorial! thanks so much
What can I do here to use this code as a transaction? I am facing problems in implementing rollback and commit.
Hi, i need to store an integer value from one of the cells to a variable. I need to use Execute Scalar but i cant understand how to call that using the SQLControl class. Can someone help please?
So good your video… thank you so much…
Need your help …
What should be following code like if there is more than 1 search field, eg search by firstName (Like) and lastName (Like) and age eg between 20 and 30 … all at the same time.
*******************************************************************************************************************************
Private Sub FindItem()
SQL.AddParam(“@item”, “%” & txtSearch.Text & “%”)
LoadGrid(“SELECT PartNo,PartDesc FROM Products WHERE PartNo LIKE @item;”)
End Sub
Hi VBToolbox. i have a problem with the login. I connect the sql db with windows authentication, everything looks good , but when the code run and try to DBCon.Open() takes a fault “Login Failed foe user….” any suggestion?
Hi .. I.m facing problem in executing query in my DataGrid.. Error Mesage “Object reference not set to an instance of an object” …. I tried to replace the table name from my own SQL table against your sample but it seems not identified….Can you provide any help how I can connect to my data table. Thanks
How come you don’t have many views? your video is all i needed; Thanks man,. I dont know how to thank you, i have struggled alot to create. One bit you need to explain is how to use the Combo box to narrow the results in the grid
Hi VBToolBox ,when i use this code—— Params.ForEach(Sub(p) DBCmd.Parameters.Add(p)) and Params.Add(NewParam)
but ForEach give error i used vb.net 2012 Plz solve the problem thanks
Hey! I am facing a problem when I try to connect to my server using an IP address. Error pops up saying- “The server was not found or was not accessible”. Is there anything wrong in the connection string?
Awsome!! I’ve litteraly just finished Part5, and was a little sad to miss the “User Manager” -part. And then the Updated version you mentioned 10 months ago, suddenly pops up.
Thanks – your tutorials are really useful & informative. I’m learning a lot from you!.
Nice… SSMS generates a random password if i choose SQL-Authentication, any help?
At 42:00 you give us the option to change the connection string, but I don’t see any examples of how to actually do it. I am using other parts of your code and it’s been flawless so far, but I’m at a point where I need to connect to a different SQL server. Can you provide any direction on how to do this?
So clean and nice code! This was very helpful, thanks a lot.
can i get the code used in this tutorial?
GREAT tutorial, dude you have saved my application. I haven’t done much newer VB but was pretty awesome with VB6. I’ve got my application together but for the life of me cannot get the “built in” stuff to work with the logic I need. I had realized that the default controls were not going to be much help but it’s not like you see their code so there is nothing to change. Tableadapters seem to be a nightmare. This sqlcontroller class is EXACTLY what I was missing.
JAW
Very nice stuff, just what I was looking for. I need to convert a semi large project in Visual Fox Pro to something new(er). This combination of Visual Studio and SQL server should be a way to make everything look and feel the same for the users.
awesome and really helpful code for learners.
Thanks a lot, It’s really awesome 🙂 so clean and simple.
Don´t know why Search does not work me.
Private Sub finditem()
SQL.Addparam(“@item”, “%” & TextBox1.Text & “%”)
loadGrid(“Select * from asukkaat where Nimi LIKE @item;”)
End Sub
Private Sub Inventory_Load(sender As Object, e As EventArgs) Handles MyBase.Load
MdiParent = Form1
loadGrid()
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
finditem()
End Sub