private void CargaDatos() { var xcodmes = "99"; var xtipoplanilla = "."; var sorted = default(SortOrder); var xnomcolumna = string.Empty; if ((cboMesIni.SelectedValue != null)) { xcodmes = cboMesIni.SelectedValue.ToString(); } if ((cmbtipoplanilla.SelectedValue != null)) { xtipoplanilla = cmbtipoplanilla.SelectedValue.ToString(); } if ((Examinar.SortedColumn != null)) { xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name; sorted = Examinar.SortOrder; } var BL = new tb_plla_afectacionesctsBL(); var BE = new tb_plla_afectacionescts(); 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; }