D
DotNetJunkies User
I run the following code in an aspx page. The problem is, I can not get the output parameter.
I use Data Access Application Block 2. The same works fine in Windows Form.
Somebody plz help.
SqlParameter [] arParms1 = new SqlParameter[8];
arParms1[0] = new SqlParameter("@MRID", SqlDbType.Int);
arParms1[0].Direction=ParameterDirection.Output;
arParms1[1] = new SqlParameter("@RequestFor", SqlDbType.SmallInt);
arParms1[1].Value=cmbFor.SelectedValue;
arParms1[2] = new SqlParameter("@RequestType", SqlDbType.SmallInt);
arParms1[2].Value=cmbType.SelectedValue;
SqlHelper.ExecuteNonQuery(dbConn, "MaterialRequestInsert", arParms1);
int MRID=arParms1[0].Value;
The SP goes like this:
CREATE PROCEDURE [MaterialRequestInsert]
(
@MRID int out,
@RequestFor smallint,
@RequestType smallint,
)
AS
SET NOCOUNT OFF;
insert into MaterialRequest
(RequestFor, RequestType)
Values(@RequestFor, @RequestType);
select @MRID=@@identity
GO
I use Data Access Application Block 2. The same works fine in Windows Form.
Somebody plz help.
SqlParameter [] arParms1 = new SqlParameter[8];
arParms1[0] = new SqlParameter("@MRID", SqlDbType.Int);
arParms1[0].Direction=ParameterDirection.Output;
arParms1[1] = new SqlParameter("@RequestFor", SqlDbType.SmallInt);
arParms1[1].Value=cmbFor.SelectedValue;
arParms1[2] = new SqlParameter("@RequestType", SqlDbType.SmallInt);
arParms1[2].Value=cmbType.SelectedValue;
SqlHelper.ExecuteNonQuery(dbConn, "MaterialRequestInsert", arParms1);
int MRID=arParms1[0].Value;
The SP goes like this:
CREATE PROCEDURE [MaterialRequestInsert]
(
@MRID int out,
@RequestFor smallint,
@RequestType smallint,
)
AS
SET NOCOUNT OFF;
insert into MaterialRequest
(RequestFor, RequestType)
Values(@RequestFor, @RequestType);
select @MRID=@@identity
GO