private void Execute()
{
string text = textBox.GetSelectionOrAllText();
if (text == string.Empty)
return;
tabControl.Items.Clear();
var cmd = new SqlCmd(provider, text);
if (text.IndexOf("select", StringComparison.CurrentCultureIgnoreCase) >= 0
&& text.IndexOf("insert", StringComparison.CurrentCultureIgnoreCase) < 0
&& text.IndexOf("update", StringComparison.CurrentCultureIgnoreCase) < 0
&& text.IndexOf("delete", StringComparison.CurrentCultureIgnoreCase) < 0
)
{
try
{
StringBuilder builder = new StringBuilder();
var ds = cmd.FillDataSet();
int i = 1;
foreach (DataTable dt in ds.Tables)
{
var tab = new TabItem { Header = $"Table {i++}", Content = DisplayTable(dt) };
tabControl.Items.Add(tab);
builder.AppendLine($"{dt.Rows.Count} row(s) affected");
}
DisplayMessage(builder.ToString());
}
catch (SqlException ex)
{
DisplayMessage(ex.Message());
}
catch (Exception ex)
{
DisplayMessage(ex.Message);
}
}
else
{
try
{
int count = cmd.ExecuteNonQuery();
string message = $"{count} row(s) affected";
DisplayMessage(message);
}
catch (SqlException ex)
{
DisplayMessage(ex.Message());
}
catch (Exception ex)
{
DisplayMessage(ex.Message);
}
}
if (tabControl.HasItems)
(tabControl.Items[0] as TabItem).Focus();
}
