private void CargaDatos() { var xcodmes = "99"; var xtipoplanilla = "."; var sorted = default(SortOrder); var xnomcolumna = string.Empty; if (cboMes.SelectedValue != null) { xcodmes = cboMes.SelectedValue.ToString(); } if (cboTipoplanilla.SelectedValue != null) { xtipoplanilla = cboTipoplanilla.SelectedValue.ToString(); } if (Examinar.SortedColumn != null) { xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name; sorted = Examinar.SortOrder; } var BL = new tb_plla_rubrosafectosleyestrabemplBL(); var BE = new tb_plla_rubrosafectosleyestrabempl(); BE.perianio = spnperiodo.Value.ToString(); BE.perimes = xcodmes; BE.tipoplla = xtipoplanilla; Tabla = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; Examinar.AutoGenerateColumns = false; Examinar.DataSource = Tabla; }