private void BindWorkloadFunding(int i) { using (WACDataClassesDataContext wac = new WACDataClassesDataContext()) { var a = wac.agWorkloadFundings.Where(w => w.pk_agWorkloadFunding == i).Select(s => s); fv.DataKeyNames = new string[] { "pk_agWorkloadFunding" }; fv.DataSource = a; fv.DataBind(); if (fv.CurrentMode == FormViewMode.Insert) { WACGlobal_Methods.PopulateControl_DatabaseLists_Year_DDL(fv.FindControl("ddlYear") as DropDownList, DateTime.Now.Year); WACGlobal_Methods.PopulateControl_DatabaseLists_AgWorkloadFunding_DDL(fv.FindControl("ddlSource") as DropDownList, null, true); } if (fv.CurrentMode == FormViewMode.Edit) { WACGlobal_Methods.PopulateControl_DatabaseLists_Year_DDL(fv.FindControl("ddlYear") as DropDownList, a.Single().year); WACGlobal_Methods.PopulateControl_DatabaseLists_AgWorkloadFunding_DDL(fv.FindControl("ddlSource") as DropDownList, a.Single().fk_agWorkloadFunding_code, true); } } }