private void FormFilterPublishers_Load(object sender, EventArgs e) { Application.UseWaitCursor = false; string publisherName = ""; lbFilteredPublishers.EndUpdate(); lbAvailablePublishers.EndUpdate(); lbFilteredPublishers.Items.Clear(); lbAvailablePublishers.Items.Clear(); // Get the list of publishers currently in the filter list SettingsDAO lwDataAccess = new SettingsDAO(); string publisherFilter = lwDataAccess.GetPublisherFilter(); List <String> listFilterPublishers = new List <string>(); listFilterPublishers.AddRange(publisherFilter.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)); // Recover a complete list of all publsiher names DataTable dtAvailablePublishers = new ApplicationsDAO().GetAllPublisherNames(); // add <unidentified> publisher if not present if (dtAvailablePublishers.Select("_PUBLISHER = '" + DataStrings.UNIDENIFIED_PUBLISHER + "'").Length == 0) { DataRow uidRow = dtAvailablePublishers.NewRow(); uidRow["_PUBLISHER"] = DataStrings.UNIDENIFIED_PUBLISHER; dtAvailablePublishers.Rows.Add(uidRow); } // Add the publisher to the appropriate list foreach (DataRow row in dtAvailablePublishers.Rows) { publisherName = row[0].ToString(); if (!listFilterPublishers.Contains(publisherName)) { lbAvailablePublishers.Items.Add(publisherName); } else { lbFilteredPublishers.Items.Add(publisherName); } } lbFilteredPublishers.EndUpdate(); lbAvailablePublishers.EndUpdate(); }