public fLocalHolidays() { InitializeComponent(); var iniYear = DateTime.Now.Year - 1; var yearRange = 11; cboYear.DataSource = Enumerable.Range(iniYear, yearRange).ToList(); cboCOD3.Source($"Select valor from dbo.Split((Select COD3 from SISTEMAS.dbo.Users where UserCode='{conn.User}'),'|') order by Valor", conn); var _mainCOD3 = new StaticRS($"Select MainCOD3 from SISTEMAS.dbo.Users where UserCode='{conn.User}'", conn); _mainCOD3.Open(); cboCOD3.Update(); cboCOD3.Value = _mainCOD3["MainCOD3"].ToString(); _mainCOD3.Close(); _mainCOD3 = null; /* * yearCalendar.MinDate = new System.DateTime(DateTime.Now.Year, 1, 1, 0, 0, 0, 0); * yearCalendar.MaxDate = new System.DateTime(DateTime.Now.Year, 12, 31, 23, 59, 59, 100); */ cboYear.ValueChanged += CboYear_ValueChanged; cboYear.Value = DateTime.Now.Year; yearCalendar.CalendarDimensions = new Size(4, 3); yearCalendar.DateSelected += YearCalendar_DateSelected; conn.Open(); }