protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.UnobtrusiveValidationMode = System.Web.UI.UnobtrusiveValidationMode.None;
using (SqlConnection con = new SqlConnection(DbString))
{
String query = "SELECT City,RouteID From Route";
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(query, con);
sda.Fill(dt);
if (dt.Columns.Count != 0)
{
StudentCity.DataSource = dt;
StudentCity.DataTextField = "City";
StudentCity.DataValueField = "RouteID";
StudentCity.DataBind();
}
ListItem liCity = new ListItem("Select City", "-1");
StudentCity.Items.Insert(0, liCity);
ListItem liRoute = new ListItem("Select Route", "-1");
StudentRoute.Items.Insert(0, liRoute);
ListItem liStop = new ListItem("Select Stop", "-1");
StudentStop.Items.Insert(0, liCity);
StudentRoute.Enabled = false;
StudentStop.Enabled = false;
}
}
}
// ---- Utility Methods ----
public int Checksum()
{
// hash code of first name, last name, and city (no spaces and all lowercase)
return((StudentLastName.Replace(" ", "").ToLower() + StudentCity.Replace(" ", "").ToLower() + StudentBirthday.ToString()).GetHashCode());
}