private void Button1Click(object sender, EventArgs e)
{
chkMSAccess.Checked = controller.isOLEDBConnection();
string[] sqls = this.txtSQL.Text.Split(';');
for (int i = 0; i < sqls.Length; i++)
{
var sql = sqls[i];
MainView.Instance.setProgress($"{i}/{sqls.Length}", 100 * i / sqls.Length);
if (sql.Trim().Equals(""))
{
continue;
}
try {
if (chkMSAccess.Checked)
{
sql = sql.Replace("int IDENTITY(1,1)", "AUTOINCREMENT");
sql = sql.Replace("VARCHAR(1000)", "MEMO");
sql = sql.Replace("BIT", "YESNO");
}
if (sql.Trim().ToLower().StartsWith("select"))
{
txtResults.Text += $"{NEWLINE}{controller.Query(sql)}";
}
else
{
txtResults.Text += $"{NEWLINE}affected rows: { controller.Execute(sql) } ";
}
} catch (Exception ex) {
txtResults.Text += $"{NEWLINE} EXCEPTION : {ex.Message} ({sql})";
}
txtResults.Refresh();
}
MainView.Instance.setProgress("Completed", 0);
}
