G
Guest
Here's my code:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Dim db As New SqlConnection
Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
txtUsername.Text & "'"
Dim ds1 As DataSet = New DataSet()
db.ConnectionString = "Data Source=.\SQLExpress;Integrated
Security=True;User
Instance=True;database=permit50;AttachDBFilename=|DataDirectory|aspnetdb.mdf;"
db.Open()
Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter(strSQL, db)
mySqlAdapter.Fill(ds1, "users")
If ds1.Tables("strUsername").Rows.Count = 0 Then
lblError.Text = "Invalid Username"
Else
If ds1.Tables("USers").Columns("strPassword").Caption <> Not
txtPassword.Text Then
lblError.Text = "Invalid Password"
Else
Session("tblUsersID") =
ds1.Tables("Users").Columns("tblUsersID").Caption
Session("strFirstname") =
ds1.Tables("Users").Columns("strFirstname").Caption
Session("strUsername") =
ds1.Tables("Users").Columns("strUsername").Caption
Response.Redirect("welcome.aspx")
End If
End If
End Sub
My Error is on the part that goes: mySqlAdapter.Fill(ds1, "users")
My error message is:System.data.SqlClientException: Invalid pbject name
'users'.
Users does exist in my database. I am using SQL Server 2005 Express.
Any Ideas? Any Questions?
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Dim db As New SqlConnection
Dim strSQL As String = "SELECT * FROM users WHERE strUsername = '" &
txtUsername.Text & "'"
Dim ds1 As DataSet = New DataSet()
db.ConnectionString = "Data Source=.\SQLExpress;Integrated
Security=True;User
Instance=True;database=permit50;AttachDBFilename=|DataDirectory|aspnetdb.mdf;"
db.Open()
Dim mySqlAdapter As SqlDataAdapter = New SqlDataAdapter(strSQL, db)
mySqlAdapter.Fill(ds1, "users")
If ds1.Tables("strUsername").Rows.Count = 0 Then
lblError.Text = "Invalid Username"
Else
If ds1.Tables("USers").Columns("strPassword").Caption <> Not
txtPassword.Text Then
lblError.Text = "Invalid Password"
Else
Session("tblUsersID") =
ds1.Tables("Users").Columns("tblUsersID").Caption
Session("strFirstname") =
ds1.Tables("Users").Columns("strFirstname").Caption
Session("strUsername") =
ds1.Tables("Users").Columns("strUsername").Caption
Response.Redirect("welcome.aspx")
End If
End If
End Sub
My Error is on the part that goes: mySqlAdapter.Fill(ds1, "users")
My error message is:System.data.SqlClientException: Invalid pbject name
'users'.
Users does exist in my database. I am using SQL Server 2005 Express.
Any Ideas? Any Questions?