code for insert values into database using stored procedures

[Sirisha]

Hi,

I am inserting values into databse using sqlserver stored
procedures. i wrote stored preocedure,but in codebehind file(.vb
file)
i dont know how to pass the parameters, i got error message like this
"System.Data.Sq lClient.SqlExce ption: Procedure or Function
'sp_insert'
expects parameter '@TestId', which was not supplied. at
System.Data.Sql Client.SqlConne ction"
I wrote Stored Procedure Like this:
ALTER PROCEDURE [dbo].[sp_insert]
(@TestId int output ,
@Name varchar(50),
@Number varchar(50),
@Date Datetime
)
AS
INSERT INTO Testtable(Name, Number,Date)
VALUES
(@Name, @Number,@Date)
SELECT @TestId=@@IDENT ITY.
This is My .vb code:
sqlcon = New
SqlConnection(S ystem.Configura tion.Configurat ionManager.AppS ettings("Connec *
tionstring"))
Try
sqlcon.Open()
sqlcmd = New SqlCommand("sp_ insert", sqlcon)
sqlcmd.CommandT ext = "sp_insert"
sqlcmd.Connecti on = sqlcon
sqlcmd.CommandT ype = CommandType.Sto redProcedure
sqlcmd.Paramete rs.Add("@Name", SqlDbType.VarCh ar).Value =
txtname.Text
sqlcmd.Paramete rs.Add("@Number ", SqlDbType.VarCh ar).Value
= txtnumber.Text
sqlcmd.Paramete rs.Add("@Date", SqlDbType.DateT ime).Value
=
txtdate.Text
param = sqlcmd.Paramete rs.Add("@RetunV alue",
SqlDbType.VarCh ar, 50)
param.Direction = ParameterDirect ion.Output
sqlcmd.ExecuteN onQuery()
lblstatus.Text = "successfullyin serted"
sqlcon.Close()
ReturnValue = param.Value
Catch ex As Exception
lblstatus.Text = ex.ToString
End Try.
Please check this code and find out my Error.

i dont know how to pass that output parameter, please write that
code .

Regards,
Sirisha.
Regards,
Sirisha.