Thursday, April 2, 2009

Insert value in sql server using stored procedure and output parametter

SqlParameter[] Param = new SqlParameter[2];

Param[0] = new SqlParameter("@ParentId", lblSponsorID.Text.Trim().ToString());
Param[1] = new SqlParameter("@LRPosition", iposition);
Param[2] = new SqlParameter("@OutEG_ID", SqlDbType.Decimal);
Param[2].Direction = ParameterDirection.Output;


Boolean bflag = objExecuteSQLClass.dbAddUpdateParSP(Param, "InsertMemberDetails");

if (Param[2].Value != null)
{
string aa = Param[2].Value.ToString();
}