private void ColumnSelect_Click(object sender, RoutedEventArgs args) { //populate columns in conditions listbox FullQuery += "SELECT "; foreach (string s in ColumnsListBox.SelectedItems) { SelectedColumns.Add(s); FullQuery += s + ", "; } //trim last comma FullQuery = FullQuery.Substring(0, (FullQuery.Length - 2)); //add view FullQuery += " FROM " + View; FullQueryBox.Text = FullQuery; #region ResetToggles ConditionsListBox.ClearValue(ItemsControl.ItemsSourceProperty); ConditionsListBox.ItemsSource = SelectedColumns; ColumnButton.IsEnabled = false; BackToCol.IsEnabled = true; BackToView.IsEnabled = false; ExecuteQuery.IsEnabled = true; #endregion }
private void BackToCol_Click(object sender, RoutedEventArgs e) { #region ResetToggles ConditionsListBox.ClearValue(ItemsControl.ItemsSourceProperty); SelectedColumns.Clear(); ConditionsListBox.ItemsSource = SelectedColumns; ColumnButton.IsEnabled = true; BackToView.IsEnabled = true; BackToCol.IsEnabled = false; FullQuery = ""; FullQueryBox.Text = FullQuery; WhereClause = ""; InitialCondition = true; ExecuteQuery.IsEnabled = false; #endregion }