public string[] ValidationList()
{
string sql = "select validation ||' ' ||cmmnt as item from hdb_validation " // where validation in ('A','F','L','H','P','T','V') "
+ "UNION SELECT ' <<null>>' from dual ";
DataTable tbl = m_server.Table("validation", sql);
return(DataTableUtility.StringList(tbl, "", "item").ToArray());
}
/// <summary>
/// Execute SQL Statement
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonSql_Click(object sender, System.EventArgs e)
{
if (this.richTextBoxSql.Text.Length > 0)
{
Cursor = Cursors.WaitCursor;
try
{
//oracle.SetDateFormat();
DataTable tbl;
string sql = this.richTextBoxSql.Text;
if (sql.ToLower().IndexOf("update") >= 0 || sql.ToLower().IndexOf("insert") >= 0 ||
sql.ToLower().IndexOf("drop") >= 0 || sql.ToLower().IndexOf("create") >= 0 ||
sql.ToLower().IndexOf("alter") >= 0 || sql.ToLower().IndexOf("truncate") >= 0 ||
sql.ToLower().IndexOf("rename") >= 0 || sql.ToLower().IndexOf("delete") >= 0 ||
sql.ToLower().IndexOf("merge") >= 0 || sql.ToLower().IndexOf("grant") >= 0 ||
sql.ToLower().IndexOf("revoke") >= 0 || sql.ToLower().IndexOf("analyze") >= 0 ||
sql.ToLower().IndexOf("audit") >= 0 || sql.ToLower().IndexOf("comment") >= 0 ||
sql.ToLower().IndexOf("commit") >= 0 || sql.ToLower().IndexOf("rollback") >= 0 ||
sql.ToLower().IndexOf("savepoint") >= 0 || sql.ToLower().IndexOf("set") >= 0)
{
tbl = new DataTable("queryerror");
tbl.Columns.Add("ERROR");
tbl.Rows.Add("You");
tbl.Rows.Add("may");
tbl.Rows.Add("only");
tbl.Rows.Add("execute");
tbl.Rows.Add("SELECT");
tbl.Rows.Add("statements");
tbl.Rows.Add("using");
tbl.Rows.Add("this");
tbl.Rows.Add("interface");
}
else if (sql.ToLower().IndexOf("$") >= 0)
{
MessageBox.Show("Missing input found. Replace all $-variables with your desired inputs.", "Missing Input", MessageBoxButtons.OK, MessageBoxIcon.Error);
tbl = new DataTable("queryerror");
}
else
{
tbl = oracle.Table("queryreturn", this.richTextBoxSql.Text);
}
this.dataGrid1.DataSource = tbl;
}
catch (Exception ex)
{
string msg = "Error: " + ex.Message;
MessageBox.Show(msg, "HDB Poet", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
}
private void buttonSql_Click(object sender, System.EventArgs e)
{
if (this.textBoxSql.Text.Length > 0)
{
Cursor = Cursors.WaitCursor;
try
{
//oracle.SetDateFormat();
DataTable tbl;
string sql = this.textBoxSql.Text;
if (sql.ToLower().IndexOf("update") >= 0 ||
sql.ToLower().IndexOf("insert") >= 0 ||
sql.ToLower().IndexOf("alter") >= 0
)
{
oracle.RunSqlCommand(sql);
tbl = new DataTable();
}
else
{
tbl = oracle.Table("test", this.textBoxSql.Text);
}
this.dataGrid1.DataSource = tbl;
if (tbl.Columns.Contains("tmstp"))
{
// SoiUtility.FormatDataColumn(dataGrid1,"tmstp","Time Stamp",SoiConstants.TimeFormat);
}
this.labelRecordCount.Text = tbl.Rows.Count.ToString() + " Records";
//this.dataGrid1.ReadOnly = true;
this.listBoxSql.Items.Add(this.textBoxSql.Text);
}
catch (Exception ex)
{
string msg = "Error: " + ex.Message;
MessageBox.Show(msg, "HDB Poet",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
}