private void rows_delete_delete_button_Click(object sender, EventArgs e)
{
var tableName = dash_tables_listBox.SelectedItem?.ToString();
var columnName = rows_delete_column_comboBox.SelectedItem?.ToString();
var opSymbol = rows_delete_operator_comboBox.SelectedItem?.ToString();
var value = rows_delete_value_textBox.Text;
if (string.IsNullOrWhiteSpace(tableName) || string.IsNullOrWhiteSpace(columnName) || string.IsNullOrWhiteSpace(opSymbol) || string.IsNullOrWhiteSpace(value))
{
HandleError("Table, column, operator, and value must be selected.");
return;
}
try
{
var column = new ColumnDto()
{
ColumnName = columnName.Split('(')[0].Trim(),
Value = columnName.Split('(')[1].TrimEnd(')')
};
var count = _sql.DeleteRowFromTable($"{dash_statusStrip_schema_value.Text}.{tableName}", column, opSymbol, value, connDto);
rows_delete_value_textBox.Text = string.Empty;
rows_delete_column_comboBox.SelectedIndex = -1;
rows_delete_operator_comboBox.SelectedIndex = -1;
WriteToLog($"Successfully deleted {count} row(s)");
}
catch (Exception ex)
{
HandleError("Error deleting row(s):", ex);
return;
}
}
