I've use this code for login form, but it display error 'Invalid object name 'dbo.CLM_User' at line 14. Please check for me because I'm new in ASP.Net,thank you.
Protected Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click sql = "SELECT * FROM dbo.CLM_User WHERE CLM_loginID = '" & Me.txtUserId.Text & "' AND CLM_loginPWD = '" & Me.txtPassword.Text & "'" Dim result As Integer = 0 dbconn = New OleDb.OleDbConnection(strCon) dbcomm = New OleDbCommand(sql, dbconn) dbcomm.Parameters.AddWithValue("", Me.txtUserId.Text) dbcomm.Parameters.AddWithValue("", Me.txtPassword.Text) dbconn.Open() Session("User") = Me.txtUserId.Text result = DirectCast(dbcomm.ExecuteScalar(), Integer) If fnExec(sql, tEdit) = 1 Then setMsg(Me, msgBoxSaved, "strKey1") Else setMsg(Me, msgBoxSaveFailed, "strKey1") End If If result > 0 Then Response.Redirect("frmWebForm2.aspx") Else setMsg(Me, "Wrong Id or Password", "strkey1") End If End Sub
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)