Visual Basic Login with Online Database Part 1

MySQL Registration at db4free.net
http://www.db4free.net/index.php?cont...

MySQL Connector/Net 6.0
http://dev.mysql.com/downloads/connec...

MySQL Administrator + MySQL Query Browser + MySQL Migration Toolkit
http://dev.mysql.com/downloads/gui-to...

This tutorial will show you how to make a Login using Visual Basic and a Online database it's easy and simple a little bit long but works 100% Please Rate Subscribe and comment.

╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗ ║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣ ╠╗║╚╝║║╠╗║╚╣║║║║║═╣ ╚═╩══╩═╩═╩═╩╝╚╩═╩═╝

My xFire ID is:
syko456

My Email Address For Requests is:
Personal Email:
Rain.Disaster@hotmail.com

The Source Code Link:
http://ultimate-scripters.co.cc/showt...

---

Closed Caption:

hey youtube this psycho AKA ran disaster
today I'm going to show you guys how to
make a login using visual basic and an
online database
ok what you want to do is want to go to
TV for free . net and then
to apply for mysql account all the links
will be in the description box soon as
normal ok what you want to do is you
want to make your database name i'm
spending minds
youtube to make it to 13 or make it
underscored 213 you can name yours
whatever you'd like
my name is going to be admin to make
that underscored 213
ok password let's make our password the
password verify that leave everything
else the same and now you want to do is
want to put in your email
and then you want to click the checkbox
and click the apply for my school
account and you should get a
confirmation message like this and what
you going to do next is go to your email
and you should get a message like this
she's gonna click on that open it and
you should get a profile link right here
click on that right there and
click OK now you should see something
very similar to this you can do now is
we're going to login so then use our
reasoning which was admin underscore 213
and our password was password
okay and you're going to see something
somewhere this opportunity to get over
here and click databases usually takes a
little while to open something positive
video all this opens okay your database
is open
you're gonna go over here and click on
your database which whatever you named
onions my new tube on the score 213
okay now you're going to create a table
we're going to call our table users it's
going to have our users and it going to
make three fields 1-4 your ID and what
their ID there's nothing there password
okay then you're gonna see something
like this going to do is you make this
an INT let's make the length but like /
value ok and
going to make this field ID this field
name in this field password and we make
this into something the same then you're
gonna make this about 25 characters
because I'm really think I was going to
turn that character password or username
so that is ok you're going to this
checkbox make this index primary and
then you can click Save we're ok now you
should see something like this after
that you can go to click insert and you
should see something like this
okay we're gonna put one here and we
make this make using an attachment or
username admin to make the password
password for now okay and then when you
click OK you should see something like
this and what you doing over here and
click browse after you click browse you
should see something like this over here
the idea which was one and their names
the password which was password ok now
what else I need you to do is to go to
mysql calm and go and click on the
download tab and scroll down go to your
connectors and scroll down again then go
to connect to slash that scroll down to
six . up and then again scroll down and
you should sit down
yeah you should see download to hear
download the Windows binaries zip them
as I installer download that and install
it real easy real quick
also what else you can download is go
back to MySQL dot com go to your
downloads step and then over here and
click on your gy tours and you can
scroll down and you can see as because
mysql administrator over here to your
database and you can use the quarry
browsers to edit your users on the
database just go down here download the
windows x86 file down on that install it
and that's it
ok now we're going to do is minimize
this real quick okay we're going to do
an open for visual basic to go ahead and
create new project and make sure to
windows forms application i'm gonna name
mine you to the login
okay you're done you should see
something like this was going to change
a couple things
we're gonna go over here to make this
census our members area
this room do we're going to make this
startup in the center screen to go up
here and make next month's box follows
change this fixed a single resize this
right here to add a label but you know
this symbolic our form too so it's just
a label to let you know this is our from
tuna success that database ripped or the
login worked with this little bit bigger
is over
don't you can be going to right-click
over here you're gonna add new item
click login form you can name it
whatever you'd like you can t minus log
in
I need to get something similar to this
is we're gonna do is get over here right
click and then click properties and
unity shutdown mode from one started
from closes 21 last form closes and you
can exchange your startup form to login
you're also going to click references
you can add a reference and click this
add tab is add button right here and you
should get something like this scroll
down till you see my SQL . data which is
right here this is what came with the
connectors installer that you download
from is cool calm just click that and
then click ok ok don't you want to just
save this real quick close list tab now
you can go over here and
right click this and it'll be co and you
can take out the screen text it's not
really needed
ok now we're going to put in some code
go to the top-performing typing imports
system.data SQL client
ok no no it's going to type imports
again for the mine rescue day at my
school client and the top of your screen
on their public clouds going to take the
dim my SQL connection
my SQL connection
ok and then you get down here and take
this out this is not needed
ok we're going to do is going to type in
mysql connection closed new mysql
connection and
they're gonna take them secure
connection . kind of constraining equals
to put protection marks server chicos
db4 free.net which is what we're using
and then put a little semicolon there
and you type in there for number which
one piece 3306 or three of seven any
typing months and be calling and
reserved space is your ID equals admin
underscored 213 is what we put and then
we deliver some cold and then put space
password equals the we put password so
take that and again and then after that
again for another semicolon space type
in database equals what we put we put
you to underscore 213
ok you're going to do is enter the minus
QL connection that open and take me Tim
my adapter and mysql data adapter or
sorry my limit as new my school data
adapter given them SQL glory and
sorry equals rotation marks select star
from users which is what we need back
tables for our table where username
equals this application works you put
and user textbox1.text another and then
you type in which marks and another hand