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); }