private void columns_dataType_changeType_button_Click(object sender, EventArgs e)
{
var tableName = dash_tables_listBox.SelectedItem?.ToString();
var columnName = dash_columns_listBox.SelectedItem?.ToString();
var dataType = columns_dataType_valueTypes_comboBox.SelectedItem?.ToString();
if (string.IsNullOrWhiteSpace(tableName) || string.IsNullOrWhiteSpace(columnName) || string.IsNullOrWhiteSpace(dataType))
{
HandleError("Table, column, and data type must be selected.");
return;
}
try
{
_sql.ChangeColumnDataType($"{dash_statusStrip_schema_value.Text}.{tableName}", columnName.Split(' ')[0], dataType, connDto);
WriteToLog("Successfully changed data type");
dash_tables_listBox_SelectedIndexChanged(sender, e);
columns_dataType_valueTypes_comboBox.SelectedIndex = -1;
}
catch (Exception ex)
{
HandleError("Error changing data type:", ex);
return;
}
}
