I am trying to add a parameter to my cmd object but keep getting this error message. Can someone clue me in where I am going wrong.
Thanks
Kenny
int ReferralId = 0;
SqlConnection GetRefIdConn;
GetRefIdConn = new SqlConnection();
GetRefIdConn.ConnectionStr
ing = ConfigurationManager.Conne
ctionStrin
gs["12312C
onnectionS
tring"].Co
nnectionSt
ring;
SqlCommand cmd;
GetRefIdConn.Open();
cmd = new SqlCommand("GetCurrentRefe
rralID", GetRefIdConn);
cmd.CommandType = CommandType.StoredProcedur
e;
// Input Parameters
cmd.Parameters.Add(new SqlParameter("@pType", SqlDbType.VarChar, 100).Value = "Referral Queue ID"); ---- Error occurs here
cmd.Parameters.Add(new SqlParameter("@pIncrement"
, SqlDbType.Int, 4).Value = 5);
// Output Parameters
cmd.Parameters.Add(new SqlParameter("@pNewId", SqlDbType.Int, 4));
cmd.Parameters["@pNewId"].
Direction = ParameterDirection.Output;
// execute the command and read the current Referral ID
cmd.ExecuteNonQuery();
//get the value out
if (cmd.Parameters["@pNewId"]
.Value != DBNull.Value)
{
ReferralId = Convert.ToInt32(cmd.Parame
ters["@pNe
wId"].Valu
e);
cmd.Parameters.Add("@REFER
RAL_QUEUE_
ID", SqlDbType.Int).Value = ReferralId;
}
else
ReferralId = 0;
if (GetRefIdConn != null)
{
GetRefIdConn.Close();
}
Start Free Trial