private void LoadDatabaseFilteredObjects() { try { tError.Text = ""; cbObjects.Items.Clear(); using (DataStuff sn = new DataStuff()) { DataTable dt = sn.GetDatabaseObjectsFiltered(ConnectionString, cbDatabaseName.Text, FilterString, ObjectsSelected, false); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { cbObjects.Items.Add(row["Name"].ToString()); } } } } catch (Exception ex) { tError.Text = ex.Message; } }
private void LoadDatabaseFilteredObjectsPOP() { string ObjectList = string.Empty; try { ObjectList = GetProjectFilter(); if (ObjectList.Trim() == "") { MessageBox.Show("No objects were found in the current database selected for this project.", "Filter Objects", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } tError.Text = ""; cbObjects.Items.Clear(); using (DataStuff sn = new DataStuff()) { DataTable dt = sn.GetDatabaseObjectsFiltered(ConnectionString, cbDatabaseName.Text, ObjectList, ObjectsSelected, true); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { cbObjects.Items.Add(row["Name"].ToString()); } } } } catch (Exception ex) { tError.Text = ex.Message; } }