protected void Page_Load(object sender, EventArgs e) { string output = ""; string methodName = Request.Form["methodName"]; string lookupField = Request.Form["field"]; string searchTerm = Request.Form["search"]; bool isDistinct = string.IsNullOrEmpty(Request.Form["isDistinct"]) ? false : bool.Parse(Request.Form["isDistinct"]); switch (methodName) { case ("GetParentCodeByChildCode"): string childLkpField = Request.Form["childLkpField"]; string childLkpCode = Request.Form["childLkpCode"]; string parentLkpField = Request.Form["parentLkpField"]; LookupCodeDa da = new LookupCodeDa(); DataTable dt = da.GetParentLookupCodeByChildCode(parentLkpField, childLkpField, childLkpCode); // 0 || > 1 results, return empty value (prevent ambiguity) output = dt.Rows.Count == 1 ? dt.Rows[0][LookupCode.LkpCode].ToString() : ""; break; default: if (!string.IsNullOrEmpty(lookupField)) { DataTable lkpTable = GetLookupCodes(lookupField, isDistinct); if (lkpTable.Columns.Contains(LookupCode.LkpCode)) { string[] lkpFields = new string[] { LookupCode.LkpCode, LookupCode.LkpDescription }; output = PageUtil.DataTableToJSArray(lkpTable, lkpFields, false); } else { string[] lkpFields = new string[] { "DropDownValue", "DropDownText" }; output = PageUtil.DataTableToJSArray(lkpTable, lkpFields, false); } } break; } Response.Write(output); }