How to Create User Registration Form in VB.NET using SQL Server Database?

watch c'mon guys this is Madonna and welcome to the new video tutorial in this video tutorial I'm going to show you how to create user registration form in vb.net using SQL Server database that means when the user filled the form and click that register button what we need to do is we need to save the user information into the database so let's do it open up visual studio go to file click on new and then click on project select Visual Basic under the visual basics like windows windows form application and then give the name of your project and then click OK now expand that form little bit and select the form and go to the property of your form and you can change the text of this form use your registration and you can also change the background color so go to property and change the back color you and this one now from the tool box drag and drop some labels like 8 levels you you you you now where is this level you now drag and drop some textbooks here goes takes box one yo goes textbox to that goes textbox three L goes takes box for our goal sticks box 5 and then here goes textbox 6 now we need to drag and drop some combo box now select each control and go to the property and save the takes so here goes nem Peugeot's address you our goods and ER and ER goes phone you your goods email you here goods concrete here goes username and finally here goes pass or you can also increase the font of his control so select all control and go to the font property and there you can see the size property you can give any sides or whatever you and what I am NOT going to do that you can do that again drag-and-drop one button and change the text of this button I'll go to the register now select each text box and since the name of each text box so that while you are writing the code we can remember which text box is associated with the which label so elbows txt damn there goes txt it brace you here goes txt phone here goes txt mail here goes txt user and finally here goes txt pass now slick the ad combo box and go to the property of that combo box and change the name CMD gender again slick into the combo box and go to the property here was CMB country now select that gender combo box and go to the property and find the item property and click that colleague son and here goes male female and father's then click OK again go to Country combo box and good to item property there goes and you can insert as many you want so I am going to insert on it to country click OK now this is the simple either registration form now what we need to do is we need to clear the database in our SQL Server so open up SQL Server management studio right-click over database click on new database and then give the database name and then click OK now expand that database three acti scroll down and find recently created database you can expand that database now right-click over table and click that table now here we are going to design one table in data ball we are going to give some column names Oh name Bearcat address bearcat gender character and then phone bear care email bad care country character and then I used your damn bear cat password Bear Cat now simply place ctrl + S from your keyboard and get the table lamp user register and then click ok now go back to visual studio we need to connect this application with the database so go to server Explorer right click about data connection click on add connection says the data source to SQL Server and then click OK now or you need to give the server name here you have two option either you can click that drop-down icon you will see your server name or you can simply type our server name over here and then select your database and then click okay now select that recently connected data connection and go to the property copy the connection string now we are going to write the code so double click that register button but before writing the code what we need to do is we need to import some hemisphere so that we can use the classes like SQL connection class SQL a common class which enable us to running this application with the database in execute the SQL query show input system dot data import system dot data dot SQL clients now inside the clicking event of that button we are going to write the course or deem connection is SQL connection is equal to new SQL connection and here was our connection listing that we recently copied to paste that now deem command is SQL command is equal to new SQL command rather we need to write our SQL coil in order to clear the user registration form what we need to do is we need to save the user information into the database that means we need to insert the data into our database so go back to SQL Server expand that table right click about table and econ escape table is insert two new query simply copy that SQL query and then go back to visual studio paste that query now here we are going to provide the Palo so here single quotes inside two single quotes two double quotes inside double quotes two plus sign here was txt name dot text similar process txt address dot text you here it goes CMB gender dot selected item dot twist ring you and then txt phone dot text you txt email dot text CMB country dot selected item dot two string you txt user dot txt you you txt Pass dot txt now let me check one two three four five six seven eight there you go now finally here good connection now we need on the connections to connection dot upon and we need to execute the SQL query so CMD dot execute non Phi D and then finally we need to display the message to the user so message box dot so you have register successfully and here good information the message box button dot okay message box icon dot information now we need to close the connection connection dot clothes that's it now simply save your frigate execute your program now here goes some information you so and then click register message to display you have register successful now let's stick without our instructed data eg stored in our database are not so go to SQL server right-click over your table and click on eg top 200 words variable name is e store address gender for email country username password so that's in this video tutorial guides if you like this video share this video with your friends so that they can know about this tutorial and give thumbs up which really motivates us to create such programming video and stay connected with this channel in order to easting connected with this channel you need to subscribe this channel so subscribe this channel and thank you once again for watching this video I will see you in the next video tutorial until that time have a good day bye bye

Channel: RunCodes

Views: 84,493

Keywords: user regsitration form in vb, user registration form in vb using database, user registration form in vb.net using sql server database, user registration form with sql database in vb, user registration form in vb with sql database, user registration window in vb using database, user registration vb, user registration vb.net, user registration in vb source code, source code of user registration in vb, code for user registration vb, vb.net user registration code, ranbk, tech sup nep

Id: TEjyc0vYl6E

Length: 13min 47sec (827 seconds)

Published: Wed Oct 23 2019