MySQL VB.NET Tutorial 6 : Insert/Save data to database

How to: Insert New Records into a Database
Database Access with Visual VB.NET.NET
sql server - Insert Data into database in VB.NET
How to insert Data to Ms SQL server 2008 using VB.NET.net
.net - VB.NET insert data into SQL table
Using Visual VB.NET and SQL cannot insert data into table..‎
VB.NET import data from text file into sql databse line by line‎
store xml in SQL Server 2008 from VB.NET‎
Using SQL in VB.NET - Cannot insert data into SQL table
visual VB.NET - Could not Insert the data using V VB.NET in MYSQl
Add, save & retrieve data in SQL
insert data in sql 2005 from excel file through VB.NET asp.net‎
insert data into SQL table from pre filled boxes in VB.NET 4.0‎
insert into database unsing ado.net and VB.NET Visual Basic
Insert DateTime into SQL Server using VB.NET Visual Basic
Searches related to VB.NET insert data into sql Visual Basic
VB.NET insert data into sql table Visual Basic
VB.NET insert data into sql server Visual Basic
inserting data into sql table Visual Basic
insert query VB.NET
sql insert statement from another table

---

Closed Caption:

hello guys welcome once again in the
last few videos I have been showing you
how to create a login page using your
visual basic windows form application
and my skill database
so did not have shown you how to check
connection with the database and it
shows the message successfully
connection if our visual basic project
is connected to the database and
validate user name and password with the
database and the username and password
and when i click the login button and if
the username and password matches the
username and password in the database
it opens the second form now in this
video I'm going to show you how to save
your data in the database using these
text boxes and this but suppose you want
to add some data in the database using
your visual basic windows form
application in this video I will show
you exactly that
so let's get started so in the last
video itself i have shown you how to
create the second form right
and I also shown you how to create this
sign out button so that when you click
the sign up button it goes to the first
form the now
in this video just you need to add these
things
so what you need to do is add some
labels and top suppose I have this table
in the database right
I have the database and I have the table
in the database called e data and I have
this column
eid name surname and each another user
name password gender date of birth and
other things
suppose I want to end or some new data
for eid name her name and age
so till now I have 14 entries in the
database in employee ID 14
I want to add employee ID 15 using my
visual basic windows form application
so what I you need to do first is take
some labels to write your column named
dr. so I'm adding eid name her name and
age which is there which are already
there in the database
these are the columns eid names an image
and add some text boxes so that we can
enter the venues which we want to save
in the database and i will really change
the name of these text boxes
according to their
use so the first xbox is a text box and
this for the eid for employee ID second
text box is for Xbox name third text box
name is xbox wonderful s name which is
the surname and for Xbox name is expose
underscore age which is for age and just
take a button this button when we click
this button it should save the data in
the database right so that is for saving
the database now just double click this
button and in here we are going to write
the code to save the data in the
database but first as we have imported
this my school . my school client
we need to once again import this to our
second form so just add this line or add
this import to the second phone import
my school the dr. dogs my screen client
and we need to declare these two
variables so i would just copy it and
explain them at the top of your class
so after the declaration of public class
form to you can be clear these variables
one first variable is
them my script on corn as my school
connection into the connection to the
database which will
accomplish the connection to the
database and this is tim command as my
school command it will help you to
execute a creddie to the database
ok just add these two lines as you have
done in the form one if you don't know
how i have added these things and how
I've used these things you can watch my
last videos and you will be able to
understand what i have done him
now once again in this button click
event i want to write the code
so what I'm going to do is I'm going to
copy the code which I have written in
the
login button action perform
this is the code i have shown you when i
have shown you how to create a login
page right so i'm going to copy all the
data and because most of the things
would be repeated in saving the daughter
like the connection and the command so i
will copy this and i will show you step
by step what to change in this corner
right so first to fall
I will make it a little simple i'm going
to delete all this commands and i will
delete this and while loop and now I we
go to through the code and i will show
you how to write the code
so in this button click event just
create a new instance of your mysql
connection
so this is the variable which we have
declared my school connection and in
here you are creating the new instance
of my school connection so just right
you're my school connection which is
this variable is equal to Nu my school
connection right and then just copy this
my school corn here . connection string
is equal to
the connection to the server which is
your my school server this line I've
already described you
number of times in the last video this
line is used to create the connection
with your my school server now declare a
variable called them
reader as my school . a leader this will
read the doctor from the database to
declare this here and in the prank -
flock so just write a try and catch blog
just write diff
gallopin here which what basically do is
if any exception occurs while executing
your credit catches the exception and
shows the message and once the quality
is executed it disposes the connection
so that you are ready to use it for the
under connections to just write this
code and this try to catch exception
so if you can copy and so you can pause
the video and copy discord and this try
block from him
now in the tribal what we are going
what we are doing is we are opening the
connection with the database
I'm just copying this my school con .
open this open the connection to the
database and then I declare a string
variable which will hold my quality so I
decay of them crazy as string and I we
copy this ready here is equal to i will
write a new ready and order to insert
the data into the database so i will
delete my old
and I was right a new 20 here
and sit in thought
in team . . . so this database is the
name of my database which is this
database and data is my table names
database . . right
insert into database data and then i
will provide the column names in which i
want to add my daughter Post column name
is the ID second column name is called
name is and for all right so if you see
my column names
eid and if you're wondering why I have
all these things in small letters when
you are passing away it doesn't matter
if you write them in capital letters or
more little it is not you're ready to
the my school is not instance you can
write this the IBS capital also and
smalls
ok so my question now is inserted into
the database . data and in the bracket i
have entered the name of the column the
ID name her name and age
and i will write values and in the
bracket i will pass the values which I
we enter in the text box
so first well you will be the name of
the eid textbooks was the whole just
give single coat and in between just
give double booked and in between just
get this and side and in between
you need to give the name of your xbox
just right
xbox on this for
div which is the name of my text box
white xbox under both
yeah okay
benefit in the same way I me and door
name surname and he is also give obama
and i will copy and paste
sorry I'm copy and paste this spell on
you
yeah and , open peace once again and
come up in this once and I need to just
change
the value of these text boxes
so this is xbox name and bought the xbox
name then I thought
X the text from the dock and here also
in the text box for the ID you need to
give the name of the text box . x
and is my xbox important text and and
the four feet
xbox name is
xbox in age . text
ok so no my freddie is complete
so we go to the wedding
just right in sawed into data . and then
in the bracket just write the name of
the column in which you want to enter
the name and the name of my column in my
then night and spelling mistakes are
collected and in the bracket just tried
the name of your text box not text in
this white , name of the second xbox
Xbox name text , or text box of x , the
name of 4 or Xbox game which is talk
text right
this is ready
and just tried to mod you can I knew my
school command it is this command which
we have declared about write them come
on as my sweet come on if you continue
my schooling for mom and the bracket we
passed two arguments first and second is
the connection connection and then
declare vida
just copy this reader from him to come
on
execute reader right and this pound you
don't need it and now you can show the
message that you're not . i saved us a
message box . and .
ok so if your data is saved
this message will be shown and if
some exception of those and saving the
database if you get the exception here
and if you show the error message from
here
ok so this is the code to save the data
in the database
if you want you can pause the video and
just copy this hold from ok now I'm
going to run my program go to my first
home which is longing for home
I provide my username and password
correct and orphans the second form and
i will open my database and then now i
have employee ID so i have 14 employee
id's already day
now i want to enter the 15 employee ID
so i will add 15 Mary some name and
surname and and then i can see the
message that means . oh and check this .
what you need to be is who you are and
you need to refresh
what just click this button and now you
can see whatever you need . you have
entered here
15 mark and thus only signs and 854 end
and toured in now for example I want to
and or ads save up some more . in my
early 16
you name it
some name and surname is from sony and
45 and that'll be that I see if you see
this message
and once again i refresh my database and
you can see here the 16 and name is GE
and surnames videos and age is occupied
so in this way you can save the data
into the database using your visual
basic windows form application and mysql
database
I hope you have enjoyed this video p