protected void Page_Load(object sender, EventArgs e)
{
// Generates tables
DatabaseManager dbManager = new DatabaseManager();
dbManager.GenerateTable("SELECT * FROM tblBird", tblBird);
dbManager.GenerateTable("SELECT * FROM tblMember", tblMember);
dbManager.GenerateTable("SELECT * FROM tblBirdMember", tblBirdMember);
// Required query
String testQuery = "SELECT tblBird.englishName AS English, tblBird.maoriName AS Maori, tblMember.first AS Firstname, tblMember.last AS Lastname FROM tblBird INNER JOIN tblBirdMember ON tblBird.birdID = tblBirdMember.birdID INNER JOIN tblMember ON tblBirdMember.memberID = tblMember.memberID";
dbManager.GenerateTable(testQuery, tblTestQuery);
}
