|
-
Aug 6th, 2004, 11:37 AM
#1
Thread Starter
Junior Member
Help
What is wrong with this code i get a error everytime
rivate 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()
Dim iResult As Integer
' iResult = Convert.ToInt32(SqlConn)
If iResult <> 0 Then
SqlConn.Close()
Else
MsgBox("Invalid UserID or Password Please enter your UserName and Password")
End If
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|