I don’t understand where possibly goes wrong. I can insert the members but I want it to redirect the members to another page to show their particulars which they have entered just now. The problem lies here: CustID = objCmd.Parameters("OUTPUT").Value

I’m creating a store procedure to insert customer. The coding in my asp.net goes something like this:

objParam = objCmd.Parameters.Add("OUTPUT", SqlDbType.Int)
objParam.Direction = ParameterDirection.Output

objCmd.ExecuteNonQuery()

Dim retval As Integer
Dim CustID As Integer

retval = objCmd.Parameters("RETURN_VALUE").Value

If retval = -200 Then
lblError.Text = "User Name already exists!"
Else
'lblError.Text = "Record successfully added."
CustID = objCmd.Parameters("OUTPUT").Value
Session("Search") = CustID
Response.Redirect("Admin_Member.aspx")
End If

And this are the sql codes :

ALTER PROC spAddMember
(@CustName varchar(50), @CustNricNo char(9), @UserName varchar(20), @MemEmail varchar(50),
@MemPwd varchar(20), @MemDOB smalldatetime, @MemGender varchar(7), @MemJoinDate smalldatetime,
@CustID int OUTPUT)
AS

INSERT INTO CUSTOMER (CustName, CustNricNo) Values(@CustName, @CustNricNo)
INSERT INTO Member (CustID, UserName, MemEmail, MemPwd, MemDOB, MemGender, MemJoinDate, MemRewardPt)
Values(@@IDENTITY, @UserName, @MemEmail, @MemPwd, @MemDOB, @MemGender, @MemJoinDate, 1)

Select @@IDENTITY AS CustID

-- @@IDENTITY returns the last inserted identity value
SET @CustID = @@IDENTITY


RETURN