Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New SqlConnection("user id=sa;password=siva;server=192.168.76.122;Initial Catalog=Travel") Dim cmd As New SqlCommand("Tra_login ", con) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.AddWithValue("@UserName", txtusername.Text) cmd.Parameters.AddWithValue("@PassWord", txtpassword.Text) cmd.Parameters.AddWithValue("@result", 0) cmd.Parameters("@result").Direction = ParameterDirection.Output con.Open() cmd.ExecuteNonQuery()// error got here .Invalid object name 'login'. con.Close() If cmd.Parameters("@result").Value = 0 Then MsgBox("Please enter correct password and username") Else HttpContext.Current.Response.Redirect("mypage.aspx") End If End Sub End Class
LOGIN
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)