Mysql Login System - Auto Login Help?

[pancakesplatter]

Hello, I have made my login form that connects to a Mysql database to see if the details that you typed in are correct, and thats all working but I need help creating a option using a checkbox to Automatically login when the form loads. Here is my login code:

            Button1.Text = "Loading..."
            Mysqlconnection = New MySqlConnection
            Mysqlconnection.ConnectionString = "server=;Port=3306; user id=; password=; database="
            Mysqlconnection.Open()

            Dim Myadapter As New MySqlDataAdapter
            Dim sqlquary = "SELECT * From Users WHERE Username='" & TextBox1.Text & "' AND Password ='" & TextBox2.Text & "';"
            Dim Command As New MySqlCommand
            Command.Connection = Mysqlconnection
            Command.CommandText = sqlquary
            Myadapter.SelectCommand = Command
            Dim MyData As MySqlDataReader
            MyData = Command.ExecuteReader
            If MyData.HasRows = 0 Then
                Label4.Text = "Login Failed"
                Button1.Text = "Login"
            Else
                Form2.Show()
                Me.Hide()
            End If
        End If

[Niya]

Ummm ok so whats the problem you're having with your attempts at auto-login ?

[pancakesplatter]

Ummm ok so whats the problem you're having with your attempts at auto-login ?

I dont know how to setup Auto-Login. I tried one way but when the form loads it opens then closes and shows back up in 20 seconds. Can you provide a solution to my problem (code)?

[bensonsearch]

if I understand this right you could have say a checkbox1 that if ticked would log in automatically then in the form load event

if checkbox1.checked = true then
'all your code
end if

if its not checked then they must push the button

[Niya]

What form closes and shows back up in 20 seconds ?

[pancakesplatter]

if I understand this right you could have say a checkbox1 that if ticked would log in automatically then in the form load event

if checkbox1.checked = true then
'all your code
end if

if its not checked then they must push the button

I tried this, like i said recently, The login form needs to atleast show up before it automatically logs in, because that code logs in before the login form even shows up (annoying).

[pancakesplatter]

What form closes and shows back up in 20 seconds ?

The login form if I try to obove code that benson gave (I tried it before he posted it)

[pancakesplatter]

What form closes and shows back up in 20 seconds ?

The login form if I try the above code that benson gave (I tried it before he posted it)

[bensonsearch]

I tried this, like i said recently, The login form needs to atleast show up before it automatically logs in, because that code logs in before the login form even shows up (annoying).

Ok so when do you wish it to automatically run then? You could put a timer on the form. Stick your code into the tick event and set to 1 second. Then in form load start the timer (and stop it under the tick event as well so only fires once)

Otherwise the user would have to press or do something

[TysonLPrice]

As a side note that mechanism is just screaming "SQL injection attack!". Try this as the username:

' or 1 = 1 --

-- is the start of a comment in MS SQL. I don't know what it is for MySQL.

and you are in. That is one reason you will see so many posts about parameterized SQL here. Do a search on the forum for it. Also here is a basic article on SQL injection attacks to give you an idea of what I'm talking about.

http://en.wikipedia.org/wiki/SQL_injection

[pancakesplatter]

Hey, got the Auto-Login workiing but whenever I have Auto Login Checked it loads form2 but then lags like crazy. When ever I just click the Login button there is no lag, Can anybody tell me a solution to fix this?