Exemple #1
0
        //데이터그리드뷰에서 정보선택시 이력서 출력
        private void RESUMEInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            int re_num = int.Parse(RESUMEInfo[0, e.RowIndex].Value.ToString());

            DataSet ds = new DataSet();

            SqlConnection sqlcon = new SqlConnection(strconn);

            try
            {
                sqlcon.Open();

                //글번호가 같은 데이터를 불러온 후 WriteDetail폼에 전달
                SqlCommand cmd = new SqlCommand("select * from RESUME where RE_NUM = @re_num", sqlcon);
                cmd.Parameters.AddWithValue("@re_num", re_num);
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                adpt.Fill(ds);
                Show_Resume sr = new Show_Resume(ds);

                //조회수 증가
                //cmd = new SqlCommand("RecruitCountPlus", sqlcon);
                //cmd.CommandType = CommandType.StoredProcedure;
                //cmd.Parameters.AddWithValue("@re_num", ds.Tables[0].Rows[0]["RE_NUM"]);
                cmd.ExecuteNonQuery();

                Log.printLog($"{re_num}번 이력서 글 조회");

                sr.TopLevel        = false;
                sr.FormBorderStyle = FormBorderStyle.None;
                sr.Dock            = DockStyle.Fill;
                this.Controls.Add(sr);
                sr.BringToFront();
                sr.Show();
            }
            catch
            {
                MessageBox.Show("에러");
            }
            finally
            {
                if (sqlcon != null)
                {
                    sqlcon.Close();
                }
            }
        }
Exemple #2
0
 private void show_resume_detail()
 {
     if (renum != null)
     {
         SqlConnection sqlcon = new SqlConnection(strconn);
         sqlcon.Open();
         Console.WriteLine("RE_NUM = " + renum);
         SqlCommand cmd = new SqlCommand();
         cmd.Connection = sqlcon;
         DataSet        ds   = new DataSet();
         SqlDataAdapter adpt = new SqlDataAdapter("select * from RESUME where RE_NUM=" + renum, sqlcon);
         adpt.Fill(ds);
         Show_Resume sr = new Show_Resume(ds);
         sr.Show();
     }
     else
     {
         MessageBox.Show("글을 선택해주세요");
     }
 }