public void PopulateUIDefaults() { XmlDocument xmlDoc = new XmlDocument(); string filename; //filename = "~/Template/Default_" + Session["uname"].ToString() + ".xml"; //if (File.Exists(Server.MapPath(filename))) //{ xmlDoc.Load(Server.MapPath(filename)); } //else { xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); } xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("/Defaults/IEPage3"); foreach (XmlNode node in nodeList) { if (cboGAIT.Text == "") { cboGAIT.Text = node.SelectSingleNode("GAIT") == null?cboGAIT.Text.ToString().Trim() : node.SelectSingleNode("GAIT").InnerText; } if (cboAmbulates.Text == "") { cboAmbulates.Text = node.SelectSingleNode("Ambulates") == null?cboAmbulates.Text.ToString().Trim() : node.SelectSingleNode("Ambulates").InnerText; } chkFootslap.Checked = node.SelectSingleNode("Footslap") == null ? chkFootslap.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Footslap").InnerText); chkKneehyperextension.Checked = node.SelectSingleNode("Kneehyperextension") == null ? chkKneehyperextension.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Kneehyperextension").InnerText); chkUnabletohealwalk.Checked = node.SelectSingleNode("Unabletohealwalk") == null ? chkUnabletohealwalk.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Unabletohealwalk").InnerText); chkUnabletotoewalk.Checked = node.SelectSingleNode("Unabletotoewalk") == null ? chkUnabletotoewalk.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Unabletotoewalk").InnerText); if (txtOther.Text == "") { txtOther.Text = node.SelectSingleNode("Other") == null?txtOther.Text.ToString().Trim() : node.SelectSingleNode("Other").InnerText; } } xmlDoc = new XmlDocument(); xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); nodeList = xmlDoc.DocumentElement.SelectNodes("/Defaults/IEPage2"); foreach (XmlNode node in nodeList) { txtIntactExcept.Text = node.SelectSingleNode("intactexcept").InnerText; LEdtr.Checked = node.SelectSingleNode("LEdtr") == null ? LEdtr.Checked : Convert.ToBoolean(node.SelectSingleNode("LEdtr").InnerText); // chk_depression.Checked = node.SelectSingleNode("Depression") == null ? chk_depression.Checked : Convert.ToBoolean(node.SelectSingleNode("Depression").InnerText); LTricepstxt.Text = node.SelectSingleNode("DTRtricepsLeft").InnerText; RTricepstxt.Text = node.SelectSingleNode("DTRtricepsRight").InnerText; LBicepstxt.Text = node.SelectSingleNode("DTRBicepsLeft").InnerText; RBicepstxt.Text = node.SelectSingleNode("DTRBicepsRight").InnerText; RBrachioradialis.Text = node.SelectSingleNode("DTRBrachioRight").InnerText; LBrachioradialis.Text = node.SelectSingleNode("DTRBrachioLeft").InnerText; LKnee.Text = node.SelectSingleNode("DTRKneeLeft").InnerText; RKnee.Text = node.SelectSingleNode("DTRKneeRight").InnerText; LAnkle.Text = node.SelectSingleNode("DTRAnkleLeft").InnerText; RAnkle.Text = node.SelectSingleNode("DTRAnkleRight").InnerText; UExchk.Checked = node.SelectSingleNode("UEdtr") == null ? UExchk.Checked : Convert.ToBoolean(node.SelectSingleNode("UEdtr").InnerText); chkPinPrick.Checked = node.SelectSingleNode("Pinprick") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("Pinprick").InnerText); chkLighttouch.Checked = node.SelectSingleNode("Lighttouch") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("Lighttouch").InnerText); txtSensory.Text = node.SelectSingleNode("Sensory").InnerText; LESen_Click.Checked = node.SelectSingleNode("LEsen") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("LEsen").InnerText); TextBox4.Text = node.SelectSingleNode("LEL3Right").InnerText; txtDMTL3.Text = node.SelectSingleNode("LEL3Left").InnerText; TextBox6.Text = node.SelectSingleNode("LEL4Right").InnerText; TextBox5.Text = node.SelectSingleNode("LEL4Left").InnerText; TextBox8.Text = node.SelectSingleNode("LEL5Right").InnerText; TextBox7.Text = node.SelectSingleNode("LEL5Left").InnerText; TextBox10.Text = node.SelectSingleNode("LES1Left").InnerText; TextBox21.Text = node.SelectSingleNode("LES1Right").InnerText; TextBox25.Text = node.SelectSingleNode("LELumberParaspinalsRight").InnerText; TextBox24.Text = node.SelectSingleNode("LELumberParaspinalsLeft").InnerText; UESen_Click.Checked = node.SelectSingleNode("UEsen") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("UEsen").InnerText); TextBox9.Text = node.SelectSingleNode("UEC5Left").InnerText; txtUEC5Right.Text = node.SelectSingleNode("UEC5Right").InnerText; TextBox11.Text = node.SelectSingleNode("UEC6Left").InnerText; TextBox12.Text = node.SelectSingleNode("UEC6Right").InnerText; TextBox13.Text = node.SelectSingleNode("UEC7Left").InnerText; TextBox14.Text = node.SelectSingleNode("UEC7Right").InnerText; TextBox15.Text = node.SelectSingleNode("UEC8Left").InnerText; TextBox16.Text = node.SelectSingleNode("UEC8Right").InnerText; TextBox18.Text = node.SelectSingleNode("UET1Right").InnerText; TextBox17.Text = node.SelectSingleNode("UET1Left").InnerText; TextBox20.Text = node.SelectSingleNode("UECervicalParaspinalsRight").InnerText; TextBox19.Text = node.SelectSingleNode("UECervicalParaspinalsLeft").InnerText; //cboHoffmanexam.SelectedValue = node.SelectSingleNode("HoffmanExam").InnerText; //chkStocking.Checked = node.SelectSingleNode("Stocking") == null ? chkStocking.Checked : Convert.ToBoolean(node.SelectSingleNode("Stocking").InnerText); //chkGlove.Checked = node.SelectSingleNode("Glove") == null ? chkGlove.Checked : Convert.ToBoolean(node.SelectSingleNode("Glove").InnerText); LEmmst.Checked = node.SelectSingleNode("LEmmst") == null ? LEmmst.Checked : Convert.ToBoolean(node.SelectSingleNode("LEmmst").InnerText); TextBox23.Text = node.SelectSingleNode("LEHipFlexionRight").InnerText; TextBox22.Text = node.SelectSingleNode("LEHipFlexionLeft").InnerText; TextBox41.Text = node.SelectSingleNode("LEHipAbductionRight").InnerText; TextBox40.Text = node.SelectSingleNode("LEHipAbductionLeft").InnerText; TextBox27.Text = node.SelectSingleNode("LEKneeExtensionRight").InnerText; TextBox26.Text = node.SelectSingleNode("LEKneeExtensionLeft").InnerText; TextBox43.Text = node.SelectSingleNode("LEKneeFlexionRight").InnerText; TextBox42.Text = node.SelectSingleNode("LEKneeFlexionLeft").InnerText; TextBox29.Text = node.SelectSingleNode("LEAnkleDorsiRight").InnerText; TextBox28.Text = node.SelectSingleNode("LEAnkleDorsiLeft").InnerText; TextBox45.Text = node.SelectSingleNode("LEAnklePlantarRight").InnerText; TextBox44.Text = node.SelectSingleNode("LEAnklePlantarLeft").InnerText; TextBox47.Text = node.SelectSingleNode("LEAnkleExtensorRight").InnerText; TextBox46.Text = node.SelectSingleNode("LEAnkleExtensorLeft").InnerText; UEmmst.Checked = node.SelectSingleNode("UEmmst") == null ? UEmmst.Checked : Convert.ToBoolean(node.SelectSingleNode("UEmmst").InnerText); TextBox31.Text = node.SelectSingleNode("UEShoulderAbductionRight").InnerText; TextBox30.Text = node.SelectSingleNode("UEShoulderAbductionLeft").InnerText; TextBox49.Text = node.SelectSingleNode("UEShoulderFlexionRight").InnerText; TextBox48.Text = node.SelectSingleNode("UEShoulderFlexionLeft").InnerText; TextBox33.Text = node.SelectSingleNode("UEElbowExtensionRight").InnerText; TextBox32.Text = node.SelectSingleNode("UEElbowExtensionLeft").InnerText; TextBox51.Text = node.SelectSingleNode("UEElbowFlexionRight").InnerText; TextBox50.Text = node.SelectSingleNode("UEElbowFlexionLeft").InnerText; TextBox53.Text = node.SelectSingleNode("UEElbowSupinationRight").InnerText; TextBox52.Text = node.SelectSingleNode("UEElbowSupinationLeft").InnerText; TextBox55.Text = node.SelectSingleNode("UEElbowPronationRight").InnerText; TextBox54.Text = node.SelectSingleNode("UEElbowPronationLeft").InnerText; TextBox37.Text = node.SelectSingleNode("UEWristFlexionRight").InnerText; TextBox36.Text = node.SelectSingleNode("UEWristFlexionLeft").InnerText; TextBox57.Text = node.SelectSingleNode("UEWristExtensionRight").InnerText; TextBox56.Text = node.SelectSingleNode("UEWristExtensionLeft").InnerText; TextBox39.Text = node.SelectSingleNode("UEHandGripStrengthRight").InnerText; TextBox38.Text = node.SelectSingleNode("UEHandGripStrengthLeft").InnerText; TextBox59.Text = node.SelectSingleNode("UEHandFingerAbductorsRight").InnerText; TextBox58.Text = node.SelectSingleNode("UEHandFingerAbductorsLeft").InnerText; } }
private void bindData() { DBHelperClass db = new DBHelperClass(); string query = ""; query = "select top 1 * from tblPatientIEDetailPage2 where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); DataSet ds = db.selectData(query); if (ds.Tables[0].Rows.Count > 0) { //chk_seizures.Checked = ds.Tables[0].Rows[0]["Seizures"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Seizures"].ToString()) : false; //chk_chest_pain.Checked = ds.Tables[0].Rows[0]["ChestPain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ChestPain"].ToString()) : false; //chk_shortness_of_breath.Checked = ds.Tables[0].Rows[0]["ShortnessOfBreath"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ShortnessOfBreath"].ToString()) : false; //chk_jaw_pain.Checked = ds.Tables[0].Rows[0]["Jawpain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Jawpain"].ToString()) : false; //chk_abdominal_pain.Checked = ds.Tables[0].Rows[0]["AbdominalPain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["AbdominalPain"].ToString()) : false; //chk_fever.Checked = ds.Tables[0].Rows[0]["Fevers"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Fevers"].ToString()) : false; //chk_diarrhea.Checked = ds.Tables[0].Rows[0]["Diarrhea"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Diarrhea"].ToString()) : false; //chk_bowel_bladder.Checked = ds.Tables[0].Rows[0]["Bowel"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Bowel"].ToString()) : false; //chk_blurred.Checked = ds.Tables[0].Rows[0]["DoubleVision"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["DoubleVision"].ToString()) : false; //chk_recent_wt.Checked = ds.Tables[0].Rows[0]["RecentWeightloss"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["RecentWeightloss"].ToString()) : false; //chk_episodic_ligth.Checked = ds.Tables[0].Rows[0]["Episodic"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Episodic"].ToString()) : false; //chk_rashes.Checked = ds.Tables[0].Rows[0]["Rashes"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Rashes"].ToString()) : false; //chk_hearing_loss.Checked = ds.Tables[0].Rows[0]["HearingLoss"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["HearingLoss"].ToString()) : false; //chk_sleep_disturbance.Checked = ds.Tables[0].Rows[0]["NightSweats"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["NightSweats"].ToString()) : false; //chk_depression.Checked = ds.Tables[0].Rows[0]["Depression"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Depression"].ToString()) : false; //chk_bloodinurine.Checked = ds.Tables[0].Rows[0]["dloodinurine"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["dloodinurine"].ToString()) : false; LTricepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRtricepsLeft"]); RTricepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRtricepsRight"]); LBicepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBicepsLeft"]); RBicepstxt.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBicepsRight"]); RBrachioradialis.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBrachioRight"]); LBrachioradialis.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBrachioLeft"]); LKnee.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRKneeLeft"]); RKnee.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRKneeRight"]); LAnkle.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRAnkleLeft"]); RAnkle.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRAnkleRight"]); UExchk.Checked = ds.Tables[0].Rows[0]["UEdtr"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEdtr"].ToString()) : false; chkPinPrick.Checked = ds.Tables[0].Rows[0]["Pinprick"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Pinprick"].ToString()) : false; chkLighttouch.Checked = ds.Tables[0].Rows[0]["Lighttouch"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Lighttouch"].ToString()) : false; txtSensory.Text = Convert.ToString(ds.Tables[0].Rows[0]["Sensory"]); LESen_Click.Checked = ds.Tables[0].Rows[0]["LEsen"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEsen"].ToString()) : false; TextBox4.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL3Right"]); txtDMTL3.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL3Left"]); TextBox6.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL4Right"]); TextBox5.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL4Left"]); TextBox8.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL5Right"]); TextBox7.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEL5Left"]); TextBox10.Text = Convert.ToString(ds.Tables[0].Rows[0]["LES1Left"]); TextBox21.Text = Convert.ToString(ds.Tables[0].Rows[0]["LES1Right"]); TextBox25.Text = Convert.ToString(ds.Tables[0].Rows[0]["LELumberParaspinalsRight"]); TextBox24.Text = Convert.ToString(ds.Tables[0].Rows[0]["LELumberParaspinalsLeft"]); UESen_Click.Checked = ds.Tables[0].Rows[0]["UEsen"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEsen"].ToString()) : false; TextBox9.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC5Left"]); txtUEC5Right.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC5Right"]); TextBox11.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC6Left"]); TextBox12.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC6Right"]); TextBox13.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC7Left"]); TextBox14.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC7Right"]); TextBox15.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC8Left"]); TextBox16.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEC8Right"]); TextBox18.Text = Convert.ToString(ds.Tables[0].Rows[0]["UET1Right"]); TextBox17.Text = Convert.ToString(ds.Tables[0].Rows[0]["UET1Left"]); TextBox20.Text = Convert.ToString(ds.Tables[0].Rows[0]["UECervicalParaspinalsRight"]); TextBox19.Text = Convert.ToString(ds.Tables[0].Rows[0]["UECervicalParaspinalsLeft"]); // cboHoffmanexam.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["HoffmanExam"]); // chkStocking.Checked = ds.Tables[0].Rows[0]["Stocking"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Stocking"].ToString()) : false; //chkGlove.Checked = ds.Tables[0].Rows[0]["Glove"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Glove"].ToString()) : false; LEmmst.Checked = ds.Tables[0].Rows[0]["LEmmst"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEmmst"].ToString()) : false; TextBox23.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipFlexionRight"]); TextBox22.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipFlexionLeft"]); TextBox41.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipAbductionRight"]); TextBox40.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEHipAbductionLeft"]); TextBox27.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeExtensionRight"]); TextBox26.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeExtensionLeft"]); TextBox43.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeFlexionRight"]); TextBox42.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeFlexionLeft"]); TextBox29.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleDorsiRight"]); TextBox28.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleDorsiLeft"]); TextBox45.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnklePlantarRight"]); TextBox44.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnklePlantarLeft"]); TextBox47.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleExtensorRight"]); TextBox46.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleExtensorLeft"]); UEmmst.Checked = ds.Tables[0].Rows[0]["UEmmst"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEmmst"].ToString()) : false; TextBox31.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderAbductionRight"]); TextBox30.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderAbductionLeft"]); TextBox49.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderFlexionRight"]); TextBox48.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderFlexionLeft"]); TextBox33.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowExtensionRight"]); TextBox32.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowExtensionLeft"]); TextBox51.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowFlexionRight"]); TextBox50.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowFlexionLeft"]); TextBox53.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowSupinationRight"]); TextBox52.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowSupinationLeft"]); TextBox55.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowPronationRight"]); TextBox54.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowPronationLeft"]); TextBox37.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristFlexionRight"]); TextBox36.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristFlexionLeft"]); TextBox57.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristExtensionRight"]); TextBox56.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEWristExtensionLeft"]); TextBox39.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandGripStrengthRight"]); TextBox38.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandGripStrengthLeft"]); TextBox59.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandFingerAbductorsRight"]); TextBox58.Text = Convert.ToString(ds.Tables[0].Rows[0]["UEHandFingerAbductorsLeft"]); txtIntactExcept.Text = Convert.ToString(ds.Tables[0].Rows[0]["intactexcept"]); LEdtr.Checked = ds.Tables[0].Rows[0]["LEdtr"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEdtr"].ToString()) : false; } else { PopulateUIDefaults(); } query = "select * from tblPage3HTMLContent where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); ds = db.selectData(query); if (ds.Tables[0].Rows.Count > 0) { divHtml.InnerHtml = ds.Tables[0].Rows[0]["HTMLContent"].ToString(); divtopHtml.InnerHtml = ds.Tables[0].Rows[0]["topSectionHTML"].ToString(); } else { bindHtml(); } query = "Select * from tblPatientIEDetailPage3 WHERE PatientIE_ID = " + Session["PatientIE_ID"].ToString(); ds = db.selectData(query); if (ds.Tables[0].Rows.Count > 0) { cboGAIT.Text = ds.Tables[0].Rows[0]["GAIT"].ToString().Trim(); cboAmbulates.Text = ds.Tables[0].Rows[0]["Ambulates"].ToString().Trim(); chkFootslap.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Footslap"].ToString()); chkKneehyperextension.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Kneehyperextension"].ToString()); chkUnabletohealwalk.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Unabletohealwalk"].ToString()); chkUnabletotoewalk.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Unabletotoewalk"].ToString()); txtOther.Text = ds.Tables[0].Rows[0]["Other"].ToString().Trim(); } }