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