protected void Page_Load(object sender, EventArgs e)
        {
            if (Application["username"] == null)
            {
                Response.Redirect("/Login");
            }
            if (!IsPostBack)
            {
                usernumber = Convert.ToInt32(Application["UserNumber"].ToString());
                ClientVehicle cv = new ClientVehicle();
                VehicleDDL.DataValueField = "Client_Vehicle_Number";
                VehicleDDL.DataTextField = "Vehicle";
                VehicleDDL.DataSource = db.BindDropdown(cv.SearchClientVehicles(usernumber), "GVehicle_Model", "Client_Vehicle_Number");
                VehicleDDL.DataBind();

                db.LoadClientVehicles(usernumber);
                foreach (ClientVehicle ClientV in ClientVehicleBindingList.ClientVehicleList)
                {
                    if (ClientV.ClientVehicleNumber == Convert.ToInt32(VehicleDDL.SelectedValue))
                    {
                        txtName.Text = ClientV.ClientVehicleName;
                        txtColour.Text = ClientV.ClientVehicleColour;
                        txtLicensePlate.Text = ClientV.RegistrationNumber;
                        clientVehicleNumber = ClientV.ClientVehicleNumber;
                        break;
                    }
                }

                //Client Vehicle Products
                ClientVehicle cvProducts = new ClientVehicle();
                gvwStudents.DataSource = db.SearchQuery(cvProducts.SearchClientVehicleProducts(clientVehicleNumber), "ProductTable");
                gvwStudents.DataMember = "ProductTable";
                gvwStudents.DataBind();
            }
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Application["username"] == null)
     {
         Response.Redirect("/Login");
     }
     if(!IsPostBack)
     {
         usernumber = Convert.ToInt32(Application["UserNumber"]);
         VehicleDDL.Items.Clear();
         DBConnection db = new DBConnection();
         ClientVehicle cv = new ClientVehicle();
         VehicleDDL.DataTextField = "Vehicle";
         VehicleDDL.DataValueField = "Client_Vehicle_Number";
         VehicleDDL.DataSource = db.BindDropdown(cv.SearchClientVehicles(usernumber), "GVehicle_Model", "Client_Vehicle_Number");
         VehicleDDL.DataBind();
         VehicleDDL.Items.Insert(0, "");
     }
 }