private void BindAg_WFP3_Encumbrance() { FormView fv = fvAg_WFP3_Encumbrance; using (WACDataClassesDataContext wDataContext = new WACDataClassesDataContext()) { var a = from b in wDataContext.form_wfp3_encumbrances.Where(w => w.pk_form_wfp3_encumbrance == PK_Wfp3Encumbrance) select b; fv.DataKeyNames = new string[] { "pk_form_wfp3_encumbrance" }; fv.DataSource = a; fv.DataBind(); string sRegionWAC = WACGlobal_Methods.SpecialQuery_Agriculture_GetWACRegion_ByFarmBusinessPK(FK_FarmBusiness); if (fv.CurrentMode == FormViewMode.Insert) { TextBox tbAmount = fv.FindControl("tbAmount") as TextBox; try { var x = wDataContext.form_wfp3_get_encumbranceAmt_all(FK_Wfp3); tbAmount.Text = x.Single().amt_encumbrance.ToString(); } catch { } WACGlobal_Methods.PopulateControl_DatabaseLists_Encumbrance_DDL(fv, "ddlEncumbrance", null); } if (fv.CurrentMode == FormViewMode.Edit) { WACGlobal_Methods.PopulateControl_DatabaseLists_Encumbrance_DDL(fv, "ddlEncumbrance", a.Single().fk_encumbrance_code); WACGlobal_Methods.PopulateControl_DatabaseLists_EncumbranceType_DDL(fv.FindControl("ddlType") as DropDownList, a.Single().fk_encumbranceType_code, true); } } }