protected void btn_POLYNone(object sender, EventArgs e)
{
DataTable ViewPolySchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%POLYTECHNIC%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewPolySchTable);
POLYTable.DataSource = ViewPolySchTable;
POLYTable.DataBind();
con.Close();
}
protected void btnPOLYLocation(string area)
{
DataTable ViewPOLYTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE zone_code=@area AND school_name LIKE '%POLYTECHNIC%';";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@area", area);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewPOLYTable);
POLYTable.DataSource = ViewPOLYTable;
POLYTable.DataBind();
con.Close();
}
