hi im new to vb.net and i was wondering if anyone can help me. i have a backend database in sqlserver2000, and a windows form developed in vb.net to access the data. i need a login script so only a selective few users can access the application.

 I have a table in my database called 'login' which has username and password fields.

Am having the similar prob... & i am new to vb.net. I have tried below coding.... but its showing ("Invalid user name/password.")even i typed the right username and password and type. Anyone can advise me?

rivate Sub ENTER_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_enter.Click
        Dim conn As New SqlClient.SqlConnection("Data Source= (local); Initial catalog= CRS; user id=sa; pwd=sa")
        conn.Open()

        'Create a command object
        Dim mycommand As New SqlClient.SqlCommand("Select Username, Password, Type from Logindata Where Username = '" & txtUsername.Text & "' AND Password = '" & txtPassword.Text & "' AND Type= '" & Combotype.Text & "'", conn)

        'Execute the command
        Dim dr As SqlClient.SqlDataReader = mycommand.ExecuteReader()
        dr.Read()

        ' See if we got anything.
        If dr.Read = True Then
            Dim Frm2 As New Form2
            Frm2.Show()
        Else
            MsgBox("Invalid user name/password.")
        End If

        dr.Close()
        conn.Close()
    End Sub

OKie.Surprisingly its working now. I just remove dr.Read() in the coding and its working fine. I do not know the reason ?? but its working hmm..