Exemplo n.º 1
0
        /* Jorge Luis | 14/06/2018 | FEI2-752
         * Método para obtener los valores de una fila*/
        public List <string> GetFieldValuesById(string tabla, string idFieldName, string id)
        {
            List <string> values = new List <string>();

            try
            {
                string query = "SELECT TOP 1 * FROM " + tabla + " WHERE " + idFieldName + " = '" + id + "' ";
                cs_cmConexion.Open();
                OdbcDataReader reader = new OdbcCommand(query, cs_cmConexion).ExecuteReader();
                while (reader.Read())
                {
                    values.Add(reader.ToString().Trim());
                }
                cs_cmConexion.Close();
            }
            catch (Exception ex)
            {
                clsBaseLog.cs_pxRegistarAdd("clsBaseConexion cs_fxObtenerUnoPorId " + tabla + " " + ex.ToString());
            }
            return(values);
        }