protected void btnCheckSyntax_Click(object sender, EventArgs e)
{
Key1.Text = "Parsed SQL.";
string inputStr = TextBox1.Text; // set the input string equal to the input in Textbox1
if (inputStr.Length == 0)
{
Key1.Text = "No SQL provided."; // if the user enters no input, then output to error box, letting user know.
}
else
{
inputStr = ScrubSQLstring(inputStr); // pass inputStr to Scrub function, set to inputStr
char[] delimiters = new char[] { ' ' }; // set delimiter characters
// pass scrubbed input, and element count to Build Token array, located in the utilities.cs file.
businesslogic.blSQLapp checker = new businesslogic.blSQLapp(); // create instance of our SQLutilities class, call it "checker"
string[] tokenArray = checker.BuildTokenArray(inputStr); // pass our instance "checker " the input string IOT have it build an array consisting of the components(tokens) of the SQL input.
// checker.CheckSQLsyntax(tokenArray); // pass the array of tokens to the CheckSQLsyntax() method
// if (checker.errorFound)
// { // check to see if errorFound was tripped in our instances.
// Errors1.Text = checker.getError(); // if they were, then set errors to text box <<<<<<<<<<<<<<<<<<<<<<DEBUGGING STEP>>>>>>>>>>>>>>>>>>>
// }
List<string> lst = tokenArray.OfType<string>().ToList(); // take the array that we got back and turn it into a list
DataTable returneddl = checker.GetSQLresult(inputStr, ConnectionString);
returnedDL.DataSource = returneddl;
returnedDL.DataBind();
GridView1.DataSource = lst; // set the datasource
GridView1.DataBind(); // bind it
}
}
private void PopulateGridView()
{
businesslogic.blSQLapp lister = new businesslogic.blSQLapp(); // create instance of our SQLutilities class, call it "lister".
DataTable dtRace = lister.GetSQLresult(tbQuery.Text, ConnectionString, 1);
DataView dvRace = dtRace.DefaultView;
dvRace.Sort = Session["SortExpression"].ToString() + " " + Session["SortDir"].ToString();
gvRaceList.DataSource = dvRace;
gvRaceList.DataBind();
}