private void llenadatos() { try { dgAnt.ItemsSource = null; ActDAL da = new ActDAL("dest"); DataTable dt = da.LeerTabla("bitacora"); dgAnt.ItemsSource = dt; } catch (Exception ex) { throw ex; } }
private void frmSelTabExcel_Load(object sender, EventArgs e) { DataTable dt; try { if (v.TbActual == string.Empty) { throw new Exception("Nombre de Tabla incorrecto"); } if (esnuevo) { ActDAL d = new ActDAL("org"); dt = d.LeerTabla(v.TbActual); if (dt != null) { if (dt.Rows.Count > 0) { var bte = v.Tabencript.Where(x => x.Tabla == v.TbActual); if (bte.ToList().Count == 1) { dt = Util.decriptTable(dt, bte.ToList().First()); } dt.TableName = v.TbActual; } } } else { var b = v.Modtables.Where(x => x.TableName == v.TbActual); dt = b.ToList().First(); } dtorg = dt; var bhist = v.TabHist.Where(x => x.Tabla == dt.TableName); if (bhist.ToList().Count == 1) { hist = bhist.ToList().First(); } dgTabla.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }