Example #1
0
        /// <summary> Ejecuta sentencias de INSERT, DELETE y UPDATE
        /// </summary>
        /// <param name="tipoComando">Tipo de comando a Ejecutar</param>
        /// <param name="query">Instruccion SQL a Ejecutar</param>
        /// <returns>Un entero con el numero de registros Afectados</returns>
        public Int32 ExecuteNonQuery(CommandType tipoComando, String query)
        {
            VerificarComando();
            Commando.Connection  = Conexion;
            Commando.CommandType = tipoComando;
            Commando.CommandText = query;
            Int32 nRowsReturn;

            try
            {
                nRowsReturn = Commando.ExecuteNonQuery();
            }
            catch (MySqlException ex)
            {
                nRowsReturn  = -1; //
                ErrorMessage = ex.Message;
            }
            catch (Exception ex)
            {
                nRowsReturn  = -1; //
                ErrorMessage = ex.Message;
            }

            return(nRowsReturn);
        }