Login coding

Ive created a form(VB.net) for logging in and made a command Login. What coding can i write to check wether the correct logins have been inputed.I made a table on Access called Users and it has 2 fields UserID being the primary key and Password.

Please help!!!!!!!!!!!

Comments

  • : Ive created a form(VB.net) for logging in and made a command Login. What coding can i write to check wether the correct logins have been inputed.I made a table on Access called Users and it has 2 fields UserID being the primary key and Password.
    :
    : Please help!!!!!!!!!!!
    :
    :

    Hi !!
    You can go through following few things :
    - Create a OLEDBDataAdapter Object with MS-Access DB connection.
    - Create a Dataset, Right-clicking on Adapter object on Form.
    - When You call Login, you
    - First call "Fill" method of Adapter.
    - Then create object for BindingManagerBase.
    - Get objBMB = Me.BindingContext(DatasetName,TableName)
    - Keep track of objBMB.position while checking Username & Pwd with updating position.

  • : : Ive created a form(VB.net) for logging in and made a command Login. What coding can i write to check wether the correct logins have been inputed.I made a table on Access called Users and it has 2 fields UserID being the primary key and Password.
    : :
    : : Please help!!!!!!!!!!!
    : :
    : :
    :
    : Hi !!
    : You can go through following few things :
    : - Create a OLEDBDataAdapter Object with MS-Access DB connection.
    : - Create a Dataset, Right-clicking on Adapter object on Form.
    : - When You call Login, you
    : - First call "Fill" method of Adapter.
    : - Then create object for BindingManagerBase.
    : - Get objBMB = Me.BindingContext(DatasetName,TableName)
    : - Keep track of objBMB.position while checking Username & Pwd with updating position.
    :
    : Thanks,

    But can you help me with a bit of the coding, thing is i'm new in this .Net environment.

    Thanks in advance.



  • You can go through following few things :
    - Create a OLEDBDataAdapter Object with MS-Access DB connection.
    - Create a Dataset, Right-clicking on Adapter object on Form.
    - When You call Login, you
    - First call "Fill" method of Adapter.
    - Then create object for BindingManagerBase.
    - Get objBMB = Me.BindingContext(DatasetName,TableName)
    - Keep track of objBMB.position while checking Username & Pwd with updating position.
  • If you are wanting to do specific credentials, you could just make a code to check the textboxes for user name and password...I dont' know if this will help but:

    if textbox1.text = "MyUser" and textbox2.text = "MyPassword" then
    msgbox ("Welcome to the system!",MsgBoxStyle.Information,"Welcome")
    ElseIf Textbox1.text = "MyUser2" and TextBox2.text = "MyPassword2" then
    Msgbox ("Your user has been restricted",MsgBoxStyle.Critical,"Notice")
    End If

    And so on
    ----------
    Mess with the Best, Die like the Rest!
    ----------
    http://www.graalonline.com
    Get started today!

  • : not knowing how many users are stored in the database and their passwords

    //retrieve the details first
    OledbDataAdapter.fill(d_set)

    //declare a dataTable to store the dataSet contents
    d_set

    dim dataTable as DataTable = d_set.Tables("TableName")

    'compare retrieved values from the controls and the ones in the database

    if dataTable.Rows.Count > 1 then //this is only to avoid throwing an exception by the program if you just go straight to testing.

    dim counter as integer

    for counter = 0 to dataTable.Rows.Count -1

    //the first argument of the Rows method is a row and the second one is a column so you can specify the column name as in your Table
    if dataTable.Rows(counter)("UserName") = "Username" AndAlso dataTable.Rows(counter)("Password") = "Password"

    Messaagebox.show("Login Authorized")
    next

    end if

    //i hope this will solve your problem




Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories