public void ShowProfileList(ref ComboBox cbo)
 {
     try
     {
         Log.AppendText("กำลังเรียกข้อมูล Profiles...");
         ManageBiz ms = new ManageBiz();
         DataTable dtUser;
         dtUser         = ms.GetProfileList();
         cbo.DataSource = null;
         if (dtUser.Rows.Count > 0)
         {
             cbo.DataSource    = dtUser;
             cbo.DisplayMember = "ProfileName";
             cbo.ValueMember   = "ProfileName";
             Log.AppendText("เรียกข้อมูล Profiles เรียบร้อย");
         }
         else
         {
             Log.AppendText("ไม่พบข้อมูล Profiles");
         }
     }
     catch (Exception ex)
     {
         Log.AppendText(ex.Message);
         MessageBox.Show(ex.Message);
         cbo.DataSource = null;
     }
 }
        public void LoadConnectorSpec(string connectorType, ref ComboBox _ToolType, ref ComboBox _ProfileName, ref TextBox _Pins,
                                      ref TextBox _baseThickness, ref TextBox _unseatedTop, ref TextBox _height, ref TextBox _seatedHeight,
                                      ref TextBox _graphFPerPin, ref TextBox _graphDistance,
                                      ref TextBox _minFPerPin, ref TextBox _maxFPerPin, ref TextBox _userFPerPin, ref TextBox _otherForce,
                                      ref TextBox _parsPercent, ref TextBox _parsStartHeight, ref TextBox _parsDistance,
                                      ref TextBox _gradDegrees, ref TextBox _comments)
        {
            try
            {
                Log.AppendText("กำลังเรียกข้อมูล Connector spec. {" + connectorType + "}");

                DataTable dtConnector   = new DataTable();
                DataTable dtToolType    = new DataTable();
                DataTable dtProfileName = new DataTable();
                ManageBiz ms            = new ManageBiz();

                dtConnector   = ms.GetConnectorBy(connectorType);
                dtToolType    = ms.GetToolList();
                dtProfileName = ms.GetProfileList();

                if (dtConnector.Rows.Count > 0)
                {
                    _ToolType.DataSource    = null;
                    _ToolType.DataSource    = dtToolType;
                    _ToolType.DisplayMember = "ToolType";
                    _ToolType.ValueMember   = "ToolType";
                    _ToolType.Text          = dtConnector.Rows[0]["ToolType"].ToString();

                    _ProfileName.DataSource    = null;
                    _ProfileName.DataSource    = dtProfileName;
                    _ProfileName.DisplayMember = "ProfileName";
                    _ProfileName.ValueMember   = "ProfileName";
                    _ProfileName.Text          = dtConnector.Rows[0]["ProfileName"].ToString();

                    _Pins.Text = dtConnector.Rows[0]["NumberOfPins"].ToString();

                    _baseThickness.Text = dtConnector.Rows[0]["BaseThickness"].ToString();
                    _unseatedTop.Text   = dtConnector.Rows[0]["UnseatedTop"].ToString();
                    _height.Text        = dtConnector.Rows[0]["Height"].ToString();
                    _seatedHeight.Text  = dtConnector.Rows[0]["SeatedHeight"].ToString();

                    _graphFPerPin.Text  = dtConnector.Rows[0]["GraphFPerPin"].ToString();
                    _graphDistance.Text = dtConnector.Rows[0]["GraphDistance"].ToString();

                    _minFPerPin.Text  = dtConnector.Rows[0]["MinFPerPin"].ToString();
                    _maxFPerPin.Text  = dtConnector.Rows[0]["MaxFPerPin"].ToString();
                    _userFPerPin.Text = dtConnector.Rows[0]["UserFPerPin"].ToString();
                    _userFPerPin.Text = dtConnector.Rows[0]["OtherForce"].ToString();

                    _parsPercent.Text     = dtConnector.Rows[0]["PARSPercent"].ToString();
                    _parsStartHeight.Text = dtConnector.Rows[0]["PARSStartHeight"].ToString();
                    _parsDistance.Text    = dtConnector.Rows[0]["PARSDistance"].ToString();

                    _gradDegrees.Text = dtConnector.Rows[0]["FGradDegrees"].ToString();

                    _comments.Text = dtConnector.Rows[0]["Comments"].ToString();

                    Log.AppendText("เรียกข้อมูล Tools เรียบร้อย");
                }
                else
                {
                    Log.AppendText("ไม่พบข้อมูล Tools");
                }
            }
            catch (Exception ex) { Log.AppendText(ex.Message); MessageBox.Show(ex.Message); }
        }