DB linkage instructor management example source implemented in C#

public void UpdateInfo_User()
        {
            if (this.intUserKey == 0)
            {
                this.InitMemberInfo();
            }
            else
            {
                try
                {
                    this.Cursor = Cursors.WaitCursor;

                    DataTable tbl = PLAcaDBManager.UsersSelect(intUserKey);
                    if (tbl != null && tbl.Rows.Count > 0)
                    {
                        foreach (DataRow dr in tbl.Rows)
                        {
                            switch (dr["Status"].ToString())
                            {
                                case "재직":
                                    this.ucUserStatus1.VisibleStatusText = PLAcaManage.ucUserStatus.StatusText.Active;
                                    break;

                                case "휴직":
                                    this.ucUserStatus1.VisibleStatusText = PLAcaManage.ucUserStatus.StatusText.Rest;
                                    break;

                                case "퇴직":
                                    this.ucUserStatus1.VisibleStatusText = PLAcaManage.ucUserStatus.StatusText.Retire;
                                    break;
                            }
                            this.txtUserName.Text = Convert.ToString(dr["UserName"]);
                            if (dr["Jumin"].ToString() == "-")
                            {
                                this.txtJumin.Text = "";
                            }
                            else
                            {
                                this.txtJumin.Text = Convert.ToString(dr["Jumin"]);
                            }
                            if (!UtilManager.ValidJumin(Convert.ToString(dr["Jumin"])))
                            {
                                this.txtJumin.ForeColor = System.Drawing.Color.Red;
                            }
                            else
                            {
                                this.txtJumin.ForeColor = System.Drawing.Color.Black;
                            }
                            this.txtSex.Text = Convert.ToString(dr["Sex"]);
                            this.txtBirth.Text = dr["Birth"].ToString().Replace("/", "-");
                            if (this.txtBirth.Text.Replace("-", "").Length > 0)
                            {
                                this.txtBirth.Text +=  string.Format(" ({0})", dr["Lunar"]);
                                if (this.txtBirth.Text.Split(new char[] { '-' }).Length > 2)
                                {
                                    this.txtAge.Text = Convert.ToString(UtilManager.AgeCalurate(Convert.ToInt32(this.txtBirth.Text.Split(new char[] { '-' })[0])));
                                }
                                else
                                {
                                    this.txtAge.Text = "";
                                }
                            }
                            else
                            {
                                this.txtAge.Text = "";
                            }
                            this.txtMobile.Text = UtilManager.FormatPhoneNumber(Convert.ToString(dr["Mobile"]), true);
                            this.txtTel.Text = UtilManager.FormatPhoneNumber(Convert.ToString(dr["Tel"]), true);
                            this.txtMajorSubject.Text = Convert.ToString(dr["MajorSubject"]);
                            if (dr["Zip"].ToString().Length > 0)
                            {
                                this.txtAddress.Text = string.Format("{0}) {1} {2}", dr["Zip"], dr["Address1"].ToString().Trim(), dr["Address2"].ToString().Trim());
                            }
                            else
                            {
                                this.txtAddress.Text = string.Format("{0} {1}", dr["Address1"].ToString().Trim(), dr["Address2"].ToString().Trim());
                            }
                            this.Address1 = dr["Address1"].ToString().Trim();
                            this.Address2 = dr["Address2"].ToString().Trim();
                            userName = dr["UserName"].ToString();
                            userMobile = dr["Mobile"].ToString();
                        }
                    }
                }
                catch (Exception ee)
                {
                    TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                    System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                }
                finally
                {
                    this.Cursor = Cursors.Default;
                }
                try
                {
                    this.ucMemberPhoto1.SetUserKey = this.intUserKey;
                }
                catch (Exception ee)
                {
                    TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                    System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                }
            }
        }