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"));
}
}