protected void Go_Button_Click(object sender, EventArgs e)
{
if (Records_GridView.Visible)
{
Records_GridView.Visible = false;
}
Color color;
string message;
DataTable dt = new DataTable();
bool hasRecords = false;
if (!string.IsNullOrEmpty(Query_TextBox.Text))
{
message = SQL.RunSQL(Provider_DropDownList.Text, Query_TextBox.Text.Trim(), out color, out dt);
if (dt.Rows.Count > 0)
{
hasRecords = true;
}
}
else
{
message = "Please Enter the Query. :(";
color = Color.Red;
}
if (hasRecords)
{
Records_GridView.Visible = true;
Records_GridView.DataSource = dt;
Records_GridView.DataBind();
}
(this.Master as MasterPages_MasterPage).ShowMessageLabel(message, Color.Black);
(this.Master as MasterPages_MasterPage).Refresh_sidebar();
}
protected void Go_Button_Click(object sender, EventArgs e)
{
if (Records_GridView.Visible)
{
Records_GridView.Visible = false;
}
Color color;
dbname = Session["dbname"].ToString();
string message, query;
DataTable dt = new DataTable();
bool hasRecords = false;
if (Provider_DropDownList.Text.Equals("MYSQL"))
{
query = "use `" + dbname + "`;";
}
else
{
query = "use \"" + dbname + "\";";
}
query += Query_TextBox.Text.Trim();
if (!string.IsNullOrEmpty(Query_TextBox.Text))
{
message = SQL.RunSQL(Provider_DropDownList.Text, query, out color, out dt);
if (dt.Rows.Count > 0)
{
hasRecords = true;
}
}
else
{
message = "Please Enter the Query. :(";
color = Color.Red;
}
if (hasRecords)
{
Records_GridView.Visible = true;
Records_GridView.DataSource = dt;
Records_GridView.DataBind();
}
(this.Master as MasterPages_MasterPage).ShowMessageLabel(message, Color.Black);
}
