private void dash_tables_listBox_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
var columns = _sql.GetColumnList(dash_tables_listBox.SelectedItem?.ToString(), connDto);
dash_columns_listBox.Items.Clear();
rows_select_availableColumns_listBox.Items.Clear();
rows_select_whereColumn_comboBox.Items.Clear();
rows_delete_column_comboBox.Items.Clear();
rows_select_selectedColumns_listBox.Items.Clear();
rows_update_availableColumns_listBox.Items.Clear();
rows_update_whereColumn_comboBox.Items.Clear();
foreach (var col in columns)
{
dash_columns_listBox.Items.Add($"{col.ColumnName} ({col.Value})");
rows_select_availableColumns_listBox.Items.Add($"{col.ColumnName} ({col.Value})");
rows_select_whereColumn_comboBox.Items.Add($"{col.ColumnName} ({col.Value})");
rows_delete_column_comboBox.Items.Add($"{col.ColumnName} ({col.Value})");
rows_update_availableColumns_listBox.Items.Add($"{col.ColumnName} ({col.Value})");
rows_update_whereColumn_comboBox.Items.Add($"{col.ColumnName} ({col.Value})");
}
}
catch (Exception ex)
{
HandleError("Error getting columns for table:", ex);
return;
}
try
{
var constraints = _sql.GetConstraints(dash_tables_listBox.SelectedItem?.ToString(), connDto);
columns_removeConstraint_constraints_listBox.Items.Clear();
foreach (var constraint in constraints)
{
columns_removeConstraint_constraints_listBox.Items.Add(constraint);
}
}
catch (Exception ex)
{
HandleError("Error getting constraints from table:", ex);
return;
}
}
