C# MS Access Database Tutorial 2 # Create Login Form with Microsoft Access Database

Login Program for C# with MS Access Database
Access Login Database - Microsoft Access
How To Make A MS Access Login Form
How to create login form in Microsoft Access 2010, 2007
Visual C# - Login Form Tutorial Microsoft Access
c# - How can I close a login form and show the main form
Login Form using C# and SQL Microsoft Access
C# Login Form with MS Access
Login Form using c# and ms access as database..?‎
closing Login form after a successful Login in C# form‎
create a login form using c# Microsoft Access
C# program to connect to MS Access Database ysql
php login code MS Access Database Microsoft Access
Login Source Codes Microsoft Access
Code for login form in c#
C# Login form Searches related to c# login form
java login form
visual basic login form
visual studio login form
c# login form template
c# login form access database
c# login form example
c# login form code
c# login form sql
create login page contain user id,password,buttons
MS Access Database C# sample code

---

Closed Caption:

hello guys welcome once again in the
last video i have shown you how you can
create your post project in the shop and
connected to the microsoft access
database so we have written a simple
coat
whenever are formed lords and if the
connection is successful we will be able
to see this connection such as full of
label here now in this video I'm going
to show you how you can create a simple
login form and a check or validate your
daughter against to your database so in
the last video i have shown you that i
have this employ in your database in
which i have this table called employ
data and I have these columns in this
database
i have added two more field to this
database or username and password and
this user name and password we are going
to validate using our tea shop form
so let's go to our form here and this is
the good i have shown you in the last
video to connect to the access database
so in case you don't know how I have
done the connection with the actual
database using the shop just bought my
last video now in this i'm going to
change this code a little bit so that we
can use this connection
globally or a everywhere in the class
so what I'm going to do is this all the
code i have written it in the form load
event in the last video right
but if we want to use the same
connection in other events for example
up whenever we click login button or
other other the button click events then
this has to be a our global variable to
this class
so what we can do to this code
well DB collect connection is equal to
new connection just
copy and cut this code and paste it
inside your form one class just below
this declaration of your form one class
here and we are going to make it private
so that this led to make the connection
is private to our form one only and no
other phone will be able to use this
connection
ok now for this connection string
this is also going to be common for our
form one so we don't need to connect
again and again to the single form so
what we can do is just copy and cut this
connection strength and go to the
constructor of form one
so can circle from one is just the name
of for the class itself and this method
and here you will find
initializecomponent vigils automatically
generated by C shop for you and just
below that just make some space and
paste your connection . connection
string and whatever your connection
string is this have i have shown you in
the last with you right
so what we have done we have a declared
our wedding connection has a drawable
variable be described it to the class
form1 it is our home one and we have a
pasted this connection string to the
constructor of this form one class
ok and now in this form load event we
only have the connection open and
connection closed so whenever we need to
this use this connection
we will just open the connection and go
the connection and we don't need to you
know right declare this connection and
the connection string again and again in
the button click event
ok now look let's check it out it was ok
open it works connection successful
now let's design our home for a login
page
ok so go to this design you i will open
my own box from him and in here what I'm
going to do is I will take two labels
and i will take two xboxes xbox one xbox
- and I'm going to take about
ok and I can in close these three key
things in a group box so it looks so
ok so what i can do is we go here and i
will right click and I say send to back
ok so this will be our arm
login page so i will just change the
title of the scroll box as
login and haven't changed the title of
these labels as the so go to the
property of the label and change the
text as a user name and second label
text is password and we can change the
text box names also select your text box
and go to text box name and if the
change the name as txt on this or
username so that you know that this text
boxes for you the name and same we will
do for the second bird second text box
and we will name it as d XD
underscore password
ok and this button name i will change
this but named as be the and under
school
login and the text of this button I will
change that as login
ok so
all the things are done let's change the
font signs of all the the controls so
that we can see them
so we just select all and i will go to
the property called . board and let's
say sixty so now our tools are a little
bit visible
ok so i resize all the buttons and text
boxes and labels and now it feels fine
now what I'm going to do is I'm just
going to double click this login button
here and in here in the button click
event i'll write the code to check
whether username and password is present
in my access database and if its present
i was i'm going to show some message
that username and password is correct
right now in this button given people
the first open the connection with the
database and go that a connection with
the database as the I are shown you in
the last video connection open and
connection closed and this connection is
object of our oledbconnection if you
remember right so i will just the copy
and paste this connection open and
connection closed the cords from our
last video
so what we have in this kind of the
login button click event connection open
and connection goes and in this
connection and got open and connection
closed
we want to create a command which we can
execute so that it can relate our four
are from arteries
so what I'm going to do is I we create
our oh le debe command object which will
be our command command is equal to nu
oledbcommand and now we want to give
this command the connection the
connection is this or this the
connection object right so this command
has to know on which connection
it has to execute the command right so i
will just copy this connection object
and i will say not
not this but i will copy that command
object which is this one . and i will
see connection is equal to my command
right so not command but the connection
right so now our command North that we
have this connection and you need to you
you need to use this command for this
connection which we have created this
temperature right now in the next line
what I'm going to do is I'm going to
create a creddie
so I want to give a are ready text i
will give you this command object once
again and I will say command text is
equal to this command takes is a string
or a quality which we want to execute
so just give these double quotes and in
here we will write a ready to ready the
start of is right
so here I'm going to write a ready
select as tricks district means a wild
card which will give you all the column
data from your database so select as
tricks from your database name
so what's your daughter is named employ
in for
write and write the name of my database
employ in your database right and what I
want to validate against my database
username and password
ok and let's see all the columns in the
database username and password . text
feels right
so i will say in my code select start
from employee in for
where username username is the column
name of the user name is equal to and
then just give up this
I'll show you so is equal to give to
single quotes or double quotes but to
single quotes single quotes and single
quotes and inside those to a single God
give these to double quotes and then
inside the double court give to this
plus sign + symbol and India we are
going to pass our and the name of values
a name
Eckstein so our new username text me Liz
text you the name
so i'll pass in these two plus bracket
hour plus and i will say . text
I'll explain the quality once again so
don't worry
and and so just give em here
this will be a quote the first and just
give and and then copy your password
column name which is password and is
equal to once again single code in
between double code and between plus
plus and copy the name of your password
field name
it is the text password
God text
ok so now are already looks like this
select districts from your database name
where username is equal to whatever you
be enter in the username text balls
so this is this one and your password is
equal to whatever we enter in the
password text box
okay now this is just the Declaration of
the query but we need to execute are
very also right
so what we are going to do here is we
want to execute it
so we will write command . execute
non-credit right so non credi is the
quality whenever you will use this non
credi with your command whenever you
want to get some data from the database
so for example you want to sorry once
again
so whenever you write
command . for example non query it will
give you the insert or you want to
update or you want to delete something
which will not return you anything
then you will use non ready with the
command and if you want to read some
data from the database for example in
the case of select committees
then you need to use execute ready or
executed reader which will give you some
some values and if you will read these
values from this institute reader so in
our case we use select credit so we will
use execute reader in our case but
whenever you want to insert or update or
delete you will use execute non-greasy
so let's use the magical creature and
not and select
ready case and then i'll give the same
equal so whenever we execute a command
to give you some data we need to read
some of this data from oledb reader
objects all right
oledb leader
let's see where this oledb data reader
is so just search for already . the
reader and we will see the start of the
object moves reader is equal to our
command whatever we execute now this
reader will contain the data which comes
from the execution of this quality
so we want to read the doctor right and
how we can read the data using this
while loop and we will say reader
while the reader thought next of the
reader . read thought read then we want
to do something in the why you
ok so we will just give this curly
braces and this reader . read will give
you our boolean little so until and
unless it gives you true leader daughter
gives you the reader give you through
this move will continue our in the loop
right
and in here we want to read the data
so what they are used we are creating
the login page right so what i will do
is we create a variable in TF turn
declare our into account is equal to 0
there's a variable to count the values
of which are coming and i will say count
is equal to
count plus 1
ok you can do it like this also but I
think you already know the basics
ok so you can do it like this count + +
also you can do count plus it doesn't
matter if you do counties in gun , + 11
are countless one
ok now go outside the your wine loop and
check the value of town so just killed
if and just check the value of count if
count is equal to 1 is equal to one then
we will say
username and password is correct and i
will tell you why I'm doing this
in a moment when I complete my code and
we will just check if our count is the
greater than one and we will also check
if found is not is equal to one and not
greater than one then you will so the
else condition
now in this if count is equal to one
will show the message message box . show
and we will show the message that our
username and password district name and
password is correct
now if the count is greater than 1 that
means it has found duplicate entry in
the database so i will say duplicate
duplicate username and password
ok
and it else our username and password is
correct
not correct so I'm saying
username and password is a not correct
now we give you the demo why i have
written this code
so why
I declare this count variable to count
the number of results which are coming
from the execution of this quality and
if discount
is equal to 1 that means we have only
single entry in our database for
whatever the user name and password user
has entered so this for example he
enters admin and whatever is the
password and with if admin is the
username admin and password
a a b c d e is present in our database
only once or only for one employee then
only we want to show that our username
and password is correct
otherwise if this admin and password is
duplicated and use for other employees
also will show this message that the
country is duplicate and then it cannot
be true
so let's try and run the program post
and let's check whether it really works
a lot so we have our connection
successful and we have this form
let's go to our database we I opened my
database and let check against the
starter
so for the employee one mark
we have username admin and this password
so i will write the username admin and
the password is ABC
ed maybe see the deed and when I say
login
hopefully i will get the result but it's
showing microsoft access database cannot
find input so let's see what is the
problem
so the this table name is not correct
and that's too because i have given the
database name but not the table name
type select star from database but this
party is not cool
we want to give the table named employee
. ah right
so we just change this database name
from the table name
employed data and let's try to run at
once again and I will give a the
username at once again I have the men
and maybe see Ed which is the password
login once again and now you can see
user name and password is correct
ok and username and password is correct
and
and once again for example this employ
one user name is duplicated
add two places and this password is
duplicated at two places in the database
right and i will save this and let's try
and check once again I'll run the
program and i will give this user name
and password which is present in the
data base 2 times
so what happens
tmb one user name and password is one
two three four five
and when I say that you see the message
comes duplicate username and password
that means that if your credit points
any duplicate username and password will
show this message once again to placate
username and password
right so what we have done we have
created a login page for our project
which validates against your username
and password in the database
so that's it for this video in the next
video I will show you some some more
things in this project so stay tuned and
please rate comment and subscribe and
bible enough