protected static MEMBERS.SQlReturnInteger ExecuteProcedureReturnInteger(string ProcedureName, string[,] ParamValue)
{
try
{
MEMBERS.SQlReturnInteger returnval = new MEMBERS.SQlReturnInteger();
SqlCommand COMMAND = new SqlCommand();
COMMAND.CommandText = ProcedureName;
SqlConnection MYCON = new SqlConnection(mConnection.ConnectionString);
COMMAND.Connection = MYCON;
COMMAND.CommandType = CommandType.StoredProcedure;
SqlParameter[] param = new SqlParameter[ParamValue.GetUpperBound(0) + 1];
for (int i = 0; i < param.Length; i++)
{
param[i] = new SqlParameter("@" + ParamValue[i, 0].ToString(), ParamValue[i, 1].ToString());
}
COMMAND.Parameters.AddRange(param);
///Adds the output parameter
COMMAND.Parameters.Add("@OUTVAL", SqlDbType.Int).Direction = ParameterDirection.Output;
if (MYCON.State != ConnectionState.Open)
{
MYCON.Open();
}
COMMAND.ExecuteNonQuery();
MYCON.Close();
///Retrive value from output parameters to return value structure.
returnval.ValueFromSQL = int.Parse(COMMAND.Parameters["@OUTVAL"].Value.ToString());
return(returnval);
}
catch (Exception ex)
{
throw ex;
}
}
protected static MEMBERS.SQlReturnInteger ExecuteProcedureReturnInteger(string ProcedureName, SqlParameter[] param)
{
try
{
MEMBERS.SQlReturnInteger returnval = new MEMBERS.SQlReturnInteger();
SqlCommand COMMAND = new SqlCommand();
COMMAND.CommandText = ProcedureName;
SqlConnection MYCON = new SqlConnection(CONNECTION.ConnectionString);
COMMAND.Connection = MYCON;
COMMAND.CommandType = CommandType.StoredProcedure;
COMMAND.Parameters.AddRange(param);
///Adds the output parameter
COMMAND.Parameters.Add("@OUTVAL", SqlDbType.Int).Direction = ParameterDirection.Output;
if (MYCON.State != ConnectionState.Open)
{
MYCON.Open();
}
COMMAND.ExecuteNonQuery();
MYCON.Close();
///Retrive value from output parameters to return value structure.
returnval.ValueFromSQL = int.Parse(COMMAND.Parameters["@OUTVAL"].Value.ToString());
return(returnval);
}
catch (Exception ex)
{
throw ex;
}
}
