//Load Installers from DB protected void SelectHeadOffice_Click(object sender, EventArgs e) { //Clear current items ddlInstallers.Items.Clear(); ddlInstallers.DataBind(); AjaxControlToolkit.ModalPopupExtender mpInstaller = Parent.FindControl("mpInstaller") as AjaxControlToolkit.ModalPopupExtender; if (mpInstaller != null) { mpInstaller.Show(); } string installerName = installerCompanyName.Text.Trim().ToLower(); LinqToSqlDataContext dataCtxt = new LinqToSqlDataContext(); try { var installerQry = dataCtxt.GetInstallersByNameCode(installerName, installerName, Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()])); foreach (var dbInstaller in installerQry) { ListItem item = new ListItem(); item.Text = dbInstaller.CompanyName + " [ " + dbInstaller.Town + ", " + dbInstaller.PostCode + " ]"; item.Value = dbInstaller.InstallerCompanyID.ToString(); ddlInstallers.Items.Add(item); } ddlInstallers.DataBind(); if (ddlInstallers != null && ddlInstallers.Items.Count > 0) { ddlInstallers_SelectedIndexChanged(null, null); } else { ltrCompanyInfo.Text = ""; } } catch (Exception exp) { ListItem item = new ListItem(); item.Text = "Error Loading.. "; ddlInstallers.Items.Add(item); ddlInstallers.DataBind(); ////Record on to DB //CSLLog.RecordException(exp.Message, exp.StackTrace, "", "", "", enumPriority.HIGH.ToString(), "", SiteUtility.GetIPAddress()); } }