use following code to call Store Procedure
Dim strConnString As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
Dim con As New SqlConnection(strConnString)Dim cmd As New SqlCommand()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "SP_IsEmailExists"
cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = txtEmail.Text.Trim()
cmd.Connection = conTry con.Open()
Dim IsEmailExists As bool = cmd.ExecuteScalar()
if IsEmailExists=="true" then lblMessage.Text = "Email already exists"
end Catch ex As Exception Throw exFinally con.Close()
con.Dispose()End Try