character..

[techker]

hey guys i have just one thing left to finish in my code and i can't seem to find the keyboard shortcut..

Command.CommandText = "SELECT * FROM [members] WHERE Username= '" HEREUsernameTextBox.textHERE "' AND Password='" HERE PasswordTextBox.text HERE"'; "

its like a revers quote?

[VBNetDude]

What exactly is your question?

[jmcilhinney]

It's not a reverse single quote (`) or whatever it's called that you need there. To join strings together you use an ampersand (&), which is on the 7 key on a standard QWERTY keyboard. That said, you shouldn't be using string concatenation to insert values into SQL statements. You should be using parameters:

Command.CommandText = "SELECT * FROM [members] WHERE Username = @Userame AND [Password] =@Password"
Command.Parameters.AddWithValue("@Username", UsernameTextBox.Text)
Command.Parameters.AddWithValue("@Password", PasswordTextBox.Text)

[techker]

wow.a forum with strait answers..thx

my login form does not seem to work..it doest even show when i build it?

Dim Connection As New SqlClient.SqlConnection
        Dim Command As New SqlClient.SqlCommand
        Dim Adaptor As New SqlClient.SqlDataAdapter
        Dim Dataset As New Database1DataSet
 
        Connection.ConnectionString = ("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True")
        Command.CommandText = "SELECT * FROM [members] WHERE Username = @Userame AND [Password] =@Password"
        Command.Parameters.AddWithValue("@Username", UsernameTextBox.Text)
        Command.Parameters.AddWithValue("@Password", PasswordTextBox.Text)
        Connection.Open()
 
        Command.Connection = Connection
        Adaptor.SelectCommand = Command
        Adaptor.Fill(Dataset, "0")
 
        Dim count = Dataset.Tables(0).Rows.Count
        If count > 0 Then
            Form3.Show()
            Me.Hide()
        Else : MsgBox("incorect login", MsgBoxStyle.Critical)
            UsernameTextBox.Clear()
            PasswordTextBox.Clear()
 
 
        End If

[jmcilhinney]

Follow the CodeBank link in my signature and you'll find a thread dedicated to displaying a login dialogue.