protected void DateDDL_SelectedIndexChanged(object sender, EventArgs e) { DBConnection db = new DBConnection(); int projectNumber = Convert.ToInt32(DateDDL.SelectedItem.Value); db.LoadAllProjects(""); foreach (Project p in ProjectBindingList.ProjectList) { if (projectNumber == p.ProjectNumber) { txtProjectType.Text = p.ProjectType.ToString(); txtProjectCost.Text = p.ProjectTotalCost.ToString(); break; } } //Project Vehicle Products Project pProducts = new Project(); gvwStudents.DataSource = db.SearchQuery(pProducts.SearchClientVehicleProducts(projectNumber), "ProductTable"); gvwStudents.DataMember = "ProductTable"; gvwStudents.DataBind(); }