private void buttonDelete_Click(object sender, EventArgs e) //삭제 버튼 { try { //선택된 값 삭제 //id(pk)값 가지고 삭제 int id = Int32.Parse(dataGridViewSelect.Rows[dataGridViewSelect.CurrentCellAddress.Y].Cells[0].Value.ToString()); //MessageBox.Show("" + id); //삭제 쿼리 보내기 string query = "DELETE FROM 일일업무등록 WHERE id = " + id; DBManager.GetInstance().DBquery(query); MessageBox.Show("삭제되었습니다."); //화면 닦이는지 확인 gridView.SettingGridView(); } catch { MessageBox.Show("선택후 진행해 주세요"); } }
public void SettingValue() //gridview 전부 출력 { gridView = new GridViewManager(dataGridViewSelect); // gridview 세팅 string query = "Select id AS '번호'," + "(SELECT name FROM Employee WHERE 등록자id=identification) AS 등록자" + ",날짜,부서,업무종류,업무내용,SUBSTR(시작시간,12) AS 시작시간,SUBSTR(종료시간,12) AS 종료시간 FROM 일일업무등록,업무마스터 WHERE 업무마스터id=업무번호"; gridView.SettingSelect(query); //select 세팅 gridView.SettingGridView(); // gridview 그려주기 //컬럼 사이즈 설정 dataGridViewSelect.Columns[0].FillWeight = 50; dataGridViewSelect.Columns[3].FillWeight = 80; dataGridViewSelect.Columns[5].FillWeight = 250; //dataGridView1.Columns[6].Visible = false; // 화면에 보여주고 싶지 않은 칼럼 지정 }
private void TodayWorkSaveChange_FormClosed(object sender, FormClosedEventArgs e) { //폼 닫힘 //gridview 새로 그리기 gridView.SettingGridView(); }