-
help please
this is the error i get
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
the code is
Private Sub log_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles log.Click
Dim strCommandText As String = "SELECT COUNT(*) as USRMATCH FROM USER WHERE " & _
"USERNAME = '" & Me.user.Text & "' AND PASSWORD = '" & Me.pass.Text & "'"
Dim sqlconn As New SqlConnection _
("data source = localhost; initial catalog=ICS; user ID=sa;password=xxx")
sqlconn.Open()
-
Put your code in a try catch ex as system.data.sqlclien.sqlexception statement. The error will be explained there.
Thanks
Josh