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