public void COMBOPLANILLA()
 {
     cboTipoPlanilla.DisplayMember = "tipopllaname";
     cboTipoPlanilla.ValueMember = "tipoplla";
     var BL = new tb_plla_tab0100BL();
     var BE = new tb_plla_tab0100();
     cboTipoPlanilla.DataSource = BL.Quincenal_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0];
 }
        private BindingSource NewMethoTP()
        {
            var BL = new tb_plla_tab0100BL();
            var BE = new tb_plla_tab0100();

            var table = BL.Quincenal_CONSULTA(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
            var rows = table.Rows;

            object[] cell;
            var dic = new Dictionary<string, string>();
            var binding = new BindingSource();

            foreach (DataRow item in rows)
            {
                cell = item.ItemArray;
                dic.Add(cell[0].ToString(), cell[0].ToString() + " - " + cell[1].ToString());
                cell = null;
            }
            binding.DataSource = dic;
            return binding;
        }