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; } }