private void GetAppplications() { _applicationsList.Clear(); ddlApplication.DataSource = null; try { var query = (from a in _context.usp_QT_LightingStudy_GetApplications().ToList() select a); if (!query.Any()) { return; } _applicationsList.Add(""); foreach (var item in query) { _applicationsList.Add(item.Application); } ddlApplication.DataSource = _applicationsList; } catch (Exception ex) { string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message; MessageBox.Show(string.Format("Failed to return Applications. Try refreshing. {0}", error), "Error at GetApplications()"); } }