Firstly i'd like to apologise if any of what i am about to write sounds vague or silly but i am fairly new to this
I am trying to create a login using an existing database so asp:Login control i do not think will work.
This is what i have so far.
My stored procedure:
USE [BillyNicClothing]
GO
/****** Object: StoredProcedure [dbo].[bnc_CheckUser] Script Date: 10/10/2014 12:12:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Michael Griffiths
-- Create date: 07/10/2014
-- Description: check if user exists
-- =============================================
CREATE PROCEDURE [dbo].[bnc_CheckUser]
-- Add the parameters for the stored procedure here
@UserName nvarchar(254),
@Password varchar(20),
@OutRes int OUTPUT
AS
set @OutRes = (SELECT count(*) FROM CustomerDetails.MembershipDetai ...
Go to the complete details ...