/// <summary> /// Sets required key fields and helper data sources /// </summary> private void InitParamaters() { _diseaseName = !string.IsNullOrEmpty(QueryDiseaseName) ? QueryDiseaseName : string.Empty; _diseaseAttributeLookup = new Dictionary <int, int>(); _lkpDiseaseAttributeId = null; // set data sources LookupCodeDa da = new LookupCodeDa(); if (QueryDiseaseId.HasValue) { var lkpAttributes = BOL.BusinessObject.GetByFields <LookupAttribute>(new Dictionary <string, object> { { LookupAttribute.AttributeName, "Disease" } }); if (lkpAttributes.Count() > 0) { _lkpDiseaseAttributeId = (int)lkpAttributes.First()[LookupAttribute.AttributeId]; // get lookup codes for current disease var diseaseLkpCode = BOL.BusinessObject.GetByFields <LookupCodeAttribute>(new Dictionary <string, object> { { LookupCodeAttribute.AttributeId, _lkpDiseaseAttributeId.Value }, { LookupCodeAttribute.AttributeValue, QueryDiseaseName } }); // create lookup to get lookup attribute id by lookup code id _diseaseAttributeLookup = diseaseLkpCode.ToDictionary(b => (int)b[LookupCodeAttribute.LookupCodeId], b => (int)b[LookupCodeAttribute.LookupCodeAttributeId]); } } // set main lookup data source _lkpCodesTable = da.GetLookupFieldNames().Tables[0]; }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BindLookupAttributeValues(object sender, EventArgs e) { string lkFieldName = LookupCodesList.Value; string lkpAttributeId = LookupAttributesList.Value; // determine if using textbox(default) to build value or dropdown list string lkpAttributeValue = string.Empty; if (!string.IsNullOrEmpty(LookupAttributeValue.Value)) { lkpAttributeValue = LookupAttributeValue.Value; } else if (!string.IsNullOrEmpty(ExistingAttributeValues.Value)) { lkpAttributeValue = ExistingAttributeValues.Value; } if (!string.IsNullOrEmpty(lkFieldName) && !string.IsNullOrEmpty(lkpAttributeId) && !string.IsNullOrEmpty(lkpAttributeValue)) { selectedAttributeValue = lkpAttributeValue; LookupCodeDa da = new LookupCodeDa(); DataView dv = da.GetLookupCodeAttributesByLkpFieldAndAttribute(lkFieldName, int.Parse(lkpAttributeId), lkpAttributeValue).DefaultView; LookupAttributesGrid.DataSource = dv; LookupAttributesGrid.DataBind(); GridPanel.Visible = true; UpdateBtn.Visible = true; } else { GridPanel.Visible = false; UpdateBtn.Visible = false; } dirtyRows = new List <int>(); }
/// <summary> /// Get mapping of chron items to color /// </summary> /// <param name="lkpFieldName">The lkp field assocaited to colors by attribute</param> private IDictionary <string, Color> GetDefaultColors(string lkpFieldName) { if (!string.IsNullOrEmpty(lkpFieldName)) { // build simple lookup for var name > color DataTable colorsDt = new LookupCodeDa().GetLookupCodesAttributeValues(lkpFieldName, "Color"); var lookup = from row in colorsDt.AsEnumerable() let lkpCode = row[LookupCode.LkpCode].ToString() let lkpAttributeValue = row[LookupCodeAttribute.AttributeValue].ToString() group lkpAttributeValue by lkpCode into g let lkpCode = g.First() let color = !string.IsNullOrEmpty(lkpCode) ? (lkpCode.StartsWith("#") ? System.Drawing.ColorTranslator.FromHtml(lkpCode) : System.Drawing.Color.FromName(lkpCode)) : DEFAULT_CHRON_COLOR select new { Code = g.Key, Color = color }; // convert mapping to lookup of var to Color return(lookup.ToDictionary(k => k.Code, k => k.Color)); } else { return(new Dictionary <string, Color>()); } }
/// <summary> /// Builds a grid populated with the current LkpFieldName /// </summary> /// <param name="lkpField"></param> private bool BuildLookupCodeList(string lkpField) { InitParamaters(); LookupCodeDa da = new LookupCodeDa(); var lkpCodes = LookupCode.GetByFieldsAsDataView <LookupCode>(new Dictionary <string, object> { { LookupCode.LkpFieldName, lkpField } }); // sort by, then alpha numeric DataColumn sortCol = new DataColumn("_Sort", typeof(int), "ISNULL(LkpOrder," + int.MaxValue + ")"); DataColumn sortCol2 = new DataColumn("_Sort2", typeof(int), "ISNULL(LookupCodeId," + int.MaxValue + ") - ISNULL(LookupCodeId," + int.MaxValue + " - 1)"); lkpCodes.Table.Columns.Add(sortCol); lkpCodes.Table.Columns.Add(sortCol2); lkpCodes.Sort = "_Sort ASC, _Sort2 ASC, " + LookupCode.LkpCode + " ASC"; // build main lookup code list LookupCodeGrid.DataSource = lkpCodes; LookupCodeGrid.DataBind(); DataSet ds = da.GetLookupCodeStats(lkpField, _diseaseName); DataTable lookupByMetadata = ds.Tables[0]; int lookupCodeCount = (int)ds.Tables[1].Rows[0][0]; int lookupDiseaseCount = (int)ds.Tables[2].Rows[0][0]; BuildLkpStats(lookupByMetadata, lookupDiseaseCount, lookupCodeCount); return(lookupCodeCount > 0); }
protected void SetSiteItems() { DataView view = LookupCodeDa.GetLookupData("SpecimenSites", "SiteId", "SiteName", "", ""); RptSite.DataSource = view; RptSite.DataBind(); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void HandleLookupDeleteClick(object sender, CommandEventArgs e) { int lkpCodeId = int.Parse(e.CommandArgument.ToString()); LookupCodeDa da = new LookupCodeDa(); da.DeleteLookupCode(lkpCodeId); BuildStageStageEventsAndAttributes(); }
protected void GetCodes() { string lkpField = Request.Form[LookupCodeFieldName]; LookupCodeDa da = new LookupCodeDa(); DataTable dt = da.GetLookupsByFieldName(lkpField).Tables[0]; string codes = "{ \"codes\": " + GetOutputArray(dt) + " }"; Response.Write(codes); }
protected void BindLookupCodeDropDowns() { LookupCodeDa da = new LookupCodeDa(); DataTable lookupDataSource = da.GetLookupFieldNames().Tables[0]; LookupCodes.DataSource = lookupDataSource; LookupCodes.DataBind(); ChildLookupCodeField.DataSource = lookupDataSource; ChildLookupCodeField.DataBind(); }
/// <summary> /// Helper function used to create child records for projects based on lookup codes /// </summary> /// <param name="parentBizo"></param> /// <param name="childBizo"></param> /// <param name="parentBizoNameField"></param> /// <param name="childBizoNameField"></param> /// <param name="PARENT_LKP_FIELD_TYPE"></param> /// <param name="CHILD_LKP_FIELD_TYPE"></param> /// <param name="validate">Whether to check if parent has child records before inserting</param> /// <param name="doSave">true if to save populated biz objects before returning </param> /// <returns></returns> private static List <BusinessObject> CreateChildRecordByBizLkpCodes(BusinessObject parentBizo, BusinessObject childBizo, string parentBizoNameField, string childBizoNameField, string PARENT_LKP_FIELD_TYPE, string CHILD_LKP_FIELD_TYPE, bool validate, bool doSave) { List <BusinessObject> childBizList = new List <BusinessObject>(); int bizPriKey = int.Parse(parentBizo[parentBizo.PrimaryKeyName].ToString()); string bizNameField = parentBizo[parentBizoNameField].ToString(); // Check child Bizo to ensure no records have been created //BusinessObject checker = BusinessObjectFactory.BuildBusinessObject(childBizo.TableName); //checker.GetByParent(bizPriKey); //if (checker.RecordCount > 0 && validate) //{ // return childBizList; //} if (validate) { string tablename = childBizo.TableName; string parentKeyName = BusinessObject.GetParentKeyName(tablename); var criteria = new Dictionary <string, object>() { { parentKeyName, bizPriKey } }; if (BusinessObject.Exists(tablename, criteria)) { return(childBizList); } } LookupCodeDa da = new LookupCodeDa(); DataRow[] lkpRecords = da.GetLookupsByFieldName(PARENT_LKP_FIELD_TYPE).Tables[0].Select("", LKP_SORT_ORDER); foreach (DataRow lkpRecord in lkpRecords) { string lkpCode = lkpRecord[LookupCode.LkpCode].ToString(); if (lkpCode == bizNameField) { int lkpCodeId = int.Parse(lkpRecord[LookupCode.LookupCodeId].ToString()); DataRow[] childLkpRecords = da.GetChildCodesByLookupIdAndChildLookupName(lkpCodeId, CHILD_LKP_FIELD_TYPE).Select("", LKP_SORT_ORDER); foreach (DataRow childLkpRecord in childLkpRecords) { string childLkpCode = childLkpRecord[LookupCode.LkpCode].ToString(); BusinessObject childBiz = BusinessObjectFactory.BuildBusinessObject(childBizo.TableName); childBiz[childBiz.ParentKeyName] = bizPriKey; childBiz[childBizoNameField] = childLkpCode; childBiz.Save(); childBizList.Add(childBiz); } } } return(childBizList); }
protected override void Page_Load(object sender, EventArgs e) { bool requestFromMetaDataPage = false; // if page is launched from meta data page populate with lookup code values based on query string if (Request.QueryString["lookupCodeValue"] != null) { requestFromMetaDataPage = true; PopulateLookupFieldDropDown(); fieldName.SelectedValue = Request.QueryString["lookupCodeValue"].ToString(); } lkpName.Disabled = true; if (Page.IsPostBack || requestFromMetaDataPage) { //get look up codes for posted field name if (fieldName.SelectedValue != null && fieldName.SelectedValue.Length > 0) { lkpName.Value = fieldName.SelectedValue; LookupCodeDa lkpDa = new LookupCodeDa(); DataSet lkpDs = lkpDa.GetLookupsByFieldName(fieldName.SelectedValue); if (lkpDs.Tables[0].Rows.Count > 0) { //show repeater table repeaterDiv.Visible = true; //hide table tableDiv.Visible = false; addBtn.Visible = true; if (!Page.IsPostBack) { BindLookupCodesGrid(); } } } else { repeaterDiv.Visible = false; tableDiv.Visible = false; addBtn.Visible = false; } } else { //hide repeaterDiv.Visible = false; tableDiv.Visible = false; //populate the lookup field name drop down PopulateLookupFieldDropDown(); } }
protected void BuildCommonProblems() { LookupCodeDa lDa = new LookupCodeDa(); DataTable lDt = lDa.GetLookupCodes("Problem"); if (lDt.Rows.Count > 0) { CommonProblems.DataSource = lDt.DefaultView; CommonProblems.DataBind(); } }
protected void GetCodesByParentIdAndChildFieldName() { int parentLkpId = int.Parse(Request.Form[ParentLookupId]); string childFieldName = Request.Form[ChildLookupFieldName]; LookupCodeDa da = new LookupCodeDa(); DataTable lookupCodes = da.GetLookupCodesExcludingCodesByParentLookupId(parentLkpId, childFieldName); DataTable childNodes = da.GetChildCodesByLookupIdAndChildLookupName(parentLkpId, childFieldName); string codes = "{ \"codes\": " + GetOutputArray(lookupCodes) + ", \"childCodes\": " + GetOutputArray(childNodes) + " }"; Response.Write(codes); }
protected void BuildCommonPlans() { LookupCodeDa lDa = new LookupCodeDa(); DataTable lDt = lDa.GetLookupCodes("ProblemPlan,Disease,Osteoporosis"); if (lDt.Rows.Count > 0) { CommonPlans.DataSource = lDt.DefaultView; CommonPlans.DataBind(); } }
protected void BuildFilterByParent(object sender, EventArgs e) { string filterLkpCodeId = FilterByParentLkpCodes.Value; if (!string.IsNullOrEmpty(filterLkpCodeId)) { LookupCodeDa da = new LookupCodeDa(); var currentChildCodes = da.GetChildCodesByLookupIdAndChildLookupName(int.Parse(filterLkpCodeId), CurrentLkpFieldName.Value); SetLookupCodeGridFilter(currentChildCodes, "ApplyToParent", LookupParentChildCode.ParentChildCodeId); } }
protected void BuildLookupCodeByAttribute(object sender, EventArgs e) { string lkpAttributeId = FilterByAttributeNames.Value; string lkpAttributeValue = FilterByAttributeValues.Value; if (!string.IsNullOrEmpty(lkpAttributeValue)) { LookupCodeDa da = new LookupCodeDa(); var codeByAttribute = da.GetLookupCodeAttributesByLkpFieldAndAttribute(CurrentLkpFieldName.Value, int.Parse(lkpAttributeId), lkpAttributeValue); SetLookupCodeGridFilter(codeByAttribute, "ApplyToAttribute", LookupCodeAttribute.LookupCodeAttributeId); } }
/// <summary> /// /// </summary> private void BuildDropDownLists() { LookupCodeDa da = new LookupCodeDa(); DataTable lookupCodeList = da.GetLookupFieldNames().Tables[0]; LookupCodesList.DataSource = lookupCodeList; LookupCodesList.DataBind(); // Bind dropdown list LookupAttributesList.DataSource = LookupAttributesDataView; LookupAttributesList.DataBind(); }
protected void PopulateLookupFieldDropDown() { LookupCodeDa da = new LookupCodeDa(); DataSet ds = da.GetLookupFieldNames(); if (ds.Tables.Count > 0) { fieldName.DataSource = ds.Tables[0].DefaultView; fieldName.DataTextField = "LkpFieldName"; fieldName.DataValueField = "LkpFieldName"; fieldName.DataBind(); } }
protected void BuildFilterByParentLkpCodes(object sender, EventArgs e) { FilterByParentLkpCodes.Items.Clear(); string lkpField = FilterByParentLkpFieldNames.Value; if (!string.IsNullOrEmpty(lkpField)) { LookupCodeDa da = new LookupCodeDa(); var lkpCodes = da.GetLookupsByFieldName(lkpField).Tables[0].DefaultView; FilterByParentLkpCodes.DataSource = lkpCodes; FilterByParentLkpCodes.DataBind(); } }
protected void BuildPhysicianJSRepeater(string PhysicianType, Repeater PhysicianRepeater) { string LkpString = "OpSurgeon,PhysicianType," + PhysicianType; LookupCodeDa lDa = new LookupCodeDa(); DataTable lDt = lDa.GetLookupCodes(LkpString); if (lDt.Rows.Count > 0) { PhysicianRepeater.DataSource = lDt.DefaultView; PhysicianRepeater.DataBind(); } }
protected void RemoveAssociations() { LookupCodeDa da = new LookupCodeDa(); string parentLkpId = Request.Form[ParentLookupId]; string keyList = Request.Form[ChildLookupCodeIdList]; if (!string.IsNullOrEmpty(parentLkpId) && !string.IsNullOrEmpty(keyList)) { int parentKey = int.Parse(parentLkpId); string[] childKeys = keyList.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); da.RemoveChildCodes(parentKey, childKeys); } GetCodesByParentIdAndChildFieldName(); }
protected override void Page_Load(object sender, System.EventArgs e) { base.Page_Load(sender, e); BuildChemoTx(this._patientId, "", "Dynamic"); base.SetTitle(ComponentTitle); LookupCodeDa lpcDa = new LookupCodeDa(); DataTable lpcDt = lpcDa.GetLookupCodes("MedTxAgent"); DataTable lpcDt2 = lpcDa.GetLookupCodes("MedTxType"); SetNewAgentLookupCode(MedTxAgent_6, lpcDt, MedTxType_6, lpcDt2); SetNewAgentLookupCode(MedTxAgent_7, lpcDt, MedTxType_7, lpcDt2); SetNewAgentLookupCode(MedTxAgent_8, lpcDt, MedTxType_8, lpcDt2); SetNewAgentLookupCode(MedTxAgent_9, lpcDt, MedTxType_9, lpcDt2); SetNewAgentLookupCode(MedTxAgent_10, lpcDt, MedTxType_10, lpcDt2); }
protected override void OnInit(EventArgs e) { base.OnInit(e); LookupCodeDa da = new LookupCodeDa(); DataView procNameView = da.GetLookupCodesByAttributeByNameAndValue("ProcName", "Baseline Form Prostate", "PCCTC").DefaultView; if (procNameView.Count == 0) { procNameView = CacheManager.GetLookupCodeList("ProcName").DefaultView; } if (procNameView.Count > 0) { procNameView.Sort = LookupCode.LkpCode + " ASC"; procedureLookupNames = procNameView.ToTable(); } }
protected void BindLookupCodesGrid() { string selectedFieldName = fieldName.SelectedValue; if (!string.IsNullOrEmpty(selectedFieldName)) { LookupCodeDa lkpDa = new LookupCodeDa(); DataSet lkpDs = lkpDa.GetLookupsByFieldName(selectedFieldName); DataView view = lkpDs.Tables[0].DefaultView; // Add empty rows for (int i = 0; i < BLANK_LOOKUPCODE_ROWS; i++) { view.AddNew(); } LookupCodeGrid.DataSource = view; LookupCodeGrid.DataBind(); } }
/// <summary> /// Builds a list of default idenfitiers used for default search parameters /// as well as identifier on various forms. /// </summary> private void BuildDefaultIdentifiers() { // determine if list should be Shown string showIdentifierOnLogin = CaisisConfiguration.GetWebConfigValue("ShowIdentifiersOnLogin"); // only build and show list if web config key explicity set to true if (!string.IsNullOrEmpty(showIdentifierOnLogin) && bool.Parse(showIdentifierOnLogin)) { LookupCodeDa lkpDa = new LookupCodeDa(); DataView defaultIdList = lkpDa.GetLookupCodesAttributeValues("IdType", "UseAsDefault").DefaultView; DefaultIdentifiersRadioList.DataSource = defaultIdList; DefaultIdentifiersRadioList.DataBind(); // only show identifiers radio when values exist if (defaultIdList.Count > 0) { // show list IdentifiersPanel.Visible = true; // select value in list if in cookie HttpCookie defaultIdTypeCookie = GetDefaultIdTypeCookie(); if (defaultIdTypeCookie != null) { string defaultIdType = defaultIdTypeCookie.Value; // if a value exists in cookie, check default radio if (!string.IsNullOrEmpty(defaultIdType)) { foreach (ListItem item in DefaultIdentifiersRadioList.Items) { if (item.Value == defaultIdType) { item.Selected = true; break; } } } } } else { IdentifiersPanel.Visible = false; } } }
/// <summary> /// Builds checkbox matrix to allow selecting organizations and stages /// </summary> private void BuildCheckBoxMatrix() { LookupCodeDa lookupDa = new LookupCodeDa(); // Set Global Organization List (controls columns) organizationListDataView = da.GetAllOrganizationsByProjectId(projectId).DefaultView; allProjectStageEvents = da.GetStageEventsByProject(projectId).DefaultView; // Determine if we need to filter organization if (!string.IsNullOrEmpty(OrganizationId)) { organizationListDataView.RowFilter = ProjectOrganization.OrganizationId + " = " + OrganizationId; } // Gets all Stage names based on Lookup Codes DataTable stagesLkpCodes = lookupDa.GetLookupsByFieldName("ProjectStages").Tables[0]; // Bind Organization Header Items OrgListRptr.DataSource = organizationListDataView; OrgListRptr.DataBind(); // Bind Stages //ProjectStage projectStages = new ProjectStage(); //projectStages.GetByParent(projectId); //orgStageRecords = projectStages.DataSourceView; orgStageRecords = BusinessObject.GetByParentAsDataView <ProjectStage>(projectId); if (orgStageRecords.Count == 0) { ProjectMgmtUtil.CreateProjectChildRecords(projectId); //projectStages.GetByParent(projectId); //orgStageRecords = projectStages.DataSourceView; orgStageRecords = BusinessObject.GetByParentAsDataView <ProjectStage>(projectId); } orgStageRecords.RowFilter = ProjectStage.OrganizationId + " IS NULL"; //StagesRptr.DataSource = stagesLkpCodes; StagesRptr.DataSource = orgStageRecords; StagesRptr.DataBind(); }
/// <summary> /// Sets the color AttributeId used for updating attributes for setting colors with stages /// </summary> private void SetColorAttributeId() { if (!Page.IsPostBack) { LookupCodeDa da = new LookupCodeDa(); DataView colorAttibutes = da.GetLookupAttributeByName("Color").DefaultView; if (colorAttibutes.Count > 0) { int attId = int.Parse(colorAttibutes[0][LookupAttribute.AttributeId].ToString()); ColorAttributeId.Value = attId.ToString(); int attributeId = int.Parse(ColorAttributeId.Value); stageColorCodeAttributes = da.GetLookupCodeAttributesByAttributeId(attributeId); } } else { int attributeId = int.Parse(ColorAttributeId.Value); stageColorCodeAttributes = da.GetLookupCodeAttributesByAttributeId(attributeId); } }
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); }
/// <summary> /// Returns true if the selected ProjectType needs an approval record, else false. /// </summary> /// <param name="projectType"></param> /// <returns></returns> private bool FormNeedsApprovalStep(string projectType) { LookupCodeDa da = new LookupCodeDa(); // LookupCode ProjectApprovalType should contain a single lookup value // used to link child codes as needing approval step. DataTable dt = da.GetLookupsByFieldName("ProjectApprovalType").Tables[0]; DataRow[] singleType = dt.Select("LkpCode = 'ProjectApprovalType'"); if (singleType.Length > 0) { int parentCodeId = int.Parse(singleType[0]["LookupCodeId"].ToString()); // Get all the ProjectTypes which need approval DataTable childCodes = da.GetChildCodesByLookupIdAndChildLookupName(parentCodeId, "ProjectType"); // If projectType is in this list, we need an approval step if (childCodes.Select("LkpCode = '" + PageUtil.EscapeSingleQuotesForSql(projectType) + "'").Length > 0) { return(true); } } return(false); }
protected void GetAllCodesByParentId() { int parentLkpId = int.Parse(Request.Form[ParentLookupId]); LookupCodeDa da = new LookupCodeDa(); DataTable results = da.GetChildsCodeByLookupId(parentLkpId); string outputBuffer = "["; string s = ""; foreach (DataRow row in results.Rows) { string lkpFieldName = row[LookupCode.LkpFieldName].ToString(); if (lkpFieldName != s) { outputBuffer += "{ \"field\" : '" + lkpFieldName + "', \"codes\": " + GetOutputArray(results.Select("LkpFieldName = '" + lkpFieldName + "'")) + " } ,"; s = lkpFieldName; } } outputBuffer = outputBuffer.TrimEnd(",".ToCharArray()); outputBuffer += "]"; Response.Write(outputBuffer); }
protected void EditButtonClick(object sender, CommandEventArgs e) { tableDiv.Visible = true; //sally added //this.repeaterDiv.Visible = false; tblAddBtn.Visible = false; updateBtn.Visible = true; int lkpId = int.Parse(e.CommandName); LookupCodeDa da = new LookupCodeDa(); DataSet ds = da.GetLookupCodesRecord(lkpId); DataRow dr = ds.Tables[0].Rows[0]; lkpOrder.Value = dr[LookupCode.LkpOrder].ToString(); lkpCodeId.Value = dr["LookupCodeId"].ToString(); lkpFieldName.Value = dr["LkpFieldName"].ToString(); lkpValue.Value = dr["LkpCode"].ToString(); lkpDescription.Value = dr["LkpDescription"].ToString(); lkpSuppress.Checked = bool.Parse(dr["LkpSuppress"].ToString()); }