I cannot figure out what is going wrong here.
I get the error.
PK_RequestID is not a parameter for procedure sp_InsertRequestID.
Here is my SP
Here is my Code to call itCode:ALTER PROCEDURE sp_InsertRequestID ( @User varchar(50), @Request varchar(50), @PK_RequestID int OUTPUT ) AS Insert INTO TBL_Requests (LoginID, Request) Values (@User, @Request) Select @PK_RequestID=@@Identity Return
And here is my declarationsCode:Dim intReturnID Me.SqlConnection1.Open() Me.SqlCommand1.Parameters.Item("@Request").Value = Me.TextBox1.Text Me.SqlCommand1.Parameters.Item("@User").Value = Session("MyID") Me.SqlCommand1.ExecuteNonQuery() intReturnID = SqlCommand1.Parameters("@PK_RequestID").Value Me.SqlConnection1.Close()
Code:Me.SqlCommand1.CommandText = "[sp_InsertRequestID]" Me.SqlCommand1.CommandType = System.Data.CommandType.StoredProcedure Me.SqlCommand1.Connection = Me.SqlConnection1 Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("PK_RequestID", SqlDbType.Int, ParameterDirection.Output)) Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Request", System.Data.SqlDbType.Text, 16, "LoginID")) Me.SqlCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@User", System.Data.SqlDbType.VarChar, 50, "UserName"))




Reply With Quote