protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DBConnect myConnect = new DBConnect(); string strSQL = "SELECT DISTINCT CarMake FROM Cars"; DataSet myDataSet = myConnect.GetDataSet(strSQL); ddlMake.DataSource = myDataSet; ddlMake.DataTextField = "CarMake"; ddlMake.DataValueField = "CarMake"; ddlMake.DataBind(); ddlMake.Items.Add(new ListItem("No Selection", "NoSelection")); ddlMake.SelectedIndex = ddlMake.Items.Count - 1; ddlModel.Items.Add(new ListItem("No Make Selected", "NoMakeSelect")); string delete = "DELETE FROM SelectedPackages"; myConnect.DoUpdate(delete); } }
protected void ddlMake_SelectedIndexChanged(object sender, EventArgs e) { string SelectedCarMake = ddlMake.SelectedValue; if (SelectedCarMake != "NoSelection") { DBConnect myConnect = new DBConnect(); string strSQL = "SELECT CarModel FROM Cars WHERE CarMake = '" + SelectedCarMake + "'"; DataSet myDataSet = myConnect.GetDataSet(strSQL); ddlModel.DataSource = myDataSet; ddlModel.DataTextField = "CarModel"; ddlModel.DataValueField = "CarModel"; ddlModel.DataBind(); string strsql2 = "SELECT PackageDescription, Price, PackageID FROM Packages"; DataSet myDS2 = myConnect.GetDataSet(strsql2); gvPackages.DataSource = myDS2; gvPackages.DataBind(); } else { ddlModel.Items.Clear(); ddlModel.DataBind(); ddlModel.Items.Add(new ListItem("No Make Selected", "NoMakeSelect")); } }