private void tableBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { //загружаем все поля выбранной таблицы if (tableBox.SelectedItem != null) { fieldLabel.Visibility = Visibility.Visible; fieldBox.Visibility = Visibility.Visible; labelBinary.Visibility = Visibility.Visible; binList.Visibility = Visibility.Visible; string _table = tableBox.SelectedItem.ToString(); _tableName = _table; string _catalog = dbListBox.SelectedItem.ToString(); FieldsClass.ClearList(); condGrid.Items.Refresh(); using (SqlConnection conn = new SqlConnection(connectionBox.Text + "Initial Catalog =" + _catalog)) { try { conn.Open(); string[] restrictions = new string[4]; restrictions[2] = _table; DataTable table = conn.GetSchema("Tables", restrictions); string sql = "SELECT * FROM " + _table + " WHERE 1 = 0"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); DataTable schema = reader.GetSchemaTable(); fieldBox.Items.Clear(); binList.Items.Clear(); for (int i = 0; i < schema.Rows.Count; i++) { if (schema.Rows[i][0] != null) { FieldsClass.AddValue(schema.Rows[i][0].ToString(), ""); fieldBox.Items.Add(schema.Rows[i][0].ToString()); binList.Items.Add(schema.Rows[i][0].ToString()); } } } catch (Exception error) { MessageBox.Show(error.ToString()); } finally { conn.Close(); } } } else { fieldLabel.Visibility = Visibility.Hidden; labelBinary.Visibility = Visibility.Hidden; fieldBox.Visibility = Visibility.Hidden; binList.Visibility = Visibility.Hidden; } }
private void dbListBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { fieldBox.Items.Clear(); binList.Items.Clear(); tableBox.Items.Clear(); byteData = null; FieldsClass.ClearList(); condGrid.Items.Refresh(); tablesLabel.Visibility = Visibility.Visible; tableBox.Visibility = Visibility.Visible; ComboBox comboBox = (ComboBox)sender; string _table = comboBox.SelectedItem.ToString(); _tableCatalog = _table; using (SqlConnection conn = new SqlConnection(connectionBox.Text + "Initial Catalog =" + _table)) { try { conn.Open(); allColumnsSchemaTable = conn.GetSchema("Tables"); List <string> tablesList = ShowCols(allColumnsSchemaTable, "TABLE_NAME"); foreach (string cur in tablesList) { tableBox.Items.Add(cur); } } catch (Exception error) { MessageBox.Show(error.ToString()); } finally { conn.Close(); } } }