protected void ddlNameOfSurgery_IndexChanged(object sender, EventArgs e)
        {
            int Val = Convert.ToInt32(ddlNameOfSurgery.SelectedValue);
            EntitySurgeryMaster objTxt = new SurgeryMasterBLL().GetOperationalProcedure(Val);

            txtOperatonalProce.Text = objTxt.OperationalProcedure;
        }
 private void BindSurgery()
 {
     try
     {
         List <EntitySurgeryMaster> tblSurgery = new SurgeryMasterBLL().GetAllSurgeryName();
         tblSurgery.Insert(0, new EntitySurgeryMaster()
         {
             PKId = 0, NameOfSurgery = "----Select----"
         });
         ddlNameOfSurgery.DataSource     = tblSurgery;
         ddlNameOfSurgery.DataTextField  = "NameOFSurgery";
         ddlNameOfSurgery.DataValueField = "PKId";
         ddlNameOfSurgery.DataBind();
     }
     catch (Exception ex)
     {
         //lblMessage.Text = ex.Message;
     }
 }