What I'm trying to do is have a login type windows form to take a user name and password then compare these with data in the db then open an admin type form. I've been trying to get this to work for a few days now with no luck, about 90% of the code below is a peice together from various forums trying to get it to work.
i no longer get an error 26 connection cant be made or what may have you, but now i get "Login failed for user ''.", not quite should what this means or how to go about it
Private Sub LoginB_Click(sender As System.Object, e As System.EventArgs) Handles LoginB.Click Try Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;Database=C:\tcdb\tcdb.sdf;") Dim cmd As New SqlCommand("SELECT Username, Password FROM(Users) WHERE (Username = '" & UserTXT.Text & "') AND (Password = '" & PassTXT.Text & "')", con) con.Open() Dim sdr As SqlDataReader = cmd.ExecuteReader() ' If the record can be queried, it means passing verification, then open another form. If (sdr.Read() = True) Then MessageBox.Show("The user is valid!") Admin.Show() Me.Hide() Else MessageBox.Show("Invalid username or password!") End If con.Close() Catch ex As Exception MessageBox.Show(ex.Message) End Try
ps. sdf db has no user/pass needed to open... i think
i didnt set one and the whole app doesnt use one and loads binded data within another form without any problem whatsoever
thanks in adv