//----------------------------- //DataGridView에 데이터 채우기 //----------------------------- private void LoadData() { try { string sql = "select * from addrbook"; LocalConn = Common_DB.DBConnection(); LocalConn.Open(); adapter = new OleDbDataAdapter(sql, LocalConn); cb = new OleDbCommandBuilder(adapter); adapter.DeleteCommand = cb.GetDeleteCommand(); adapter.InsertCommand = cb.GetInsertCommand(); adapter.UpdateCommand = cb.GetUpdateCommand(); ds = new DataSet(); adapter.Fill(ds, "ADDRBOOK"); dataGrid1.DataSource = ds.Tables["ADDRBOOK"]; } catch (Exception e1) { MessageBox.Show("주소록 저장 오류~" + e1.ToString()); Log.WriteLine("FrmDataGridView", e1.ToString()); } finally { LocalConn.Close(); } }
//-------------------------------------------------------- // 메인화면 로딩시 처리되는 부분 //-------------------------------------------------------- private void FrmListView_Load(object sender, EventArgs e) { OleDbDataReader myReader = null; try { //-------------------------------------------- LocalConn = Common_DB.DBConnection(); //-------------------------------------------- LocalConn.Open(); myReader = Common_DB.DataSelect("select * from AddrBook ", LocalConn); DataLoad(myReader); //Combo Box 채우기 comSex.Items.Add("남자"); comSex.Items.Add("여자"); } catch (Exception e1) { MessageBox.Show(e1.ToString()); Log.WriteLine("FrmListView", e1.ToString()); } finally { if (!myReader.IsClosed) { myReader.Close(); myReader = null; } LocalConn.Close(); } }
private void button1_Click(object sender, EventArgs e) { OleDbDataReader myReader; string sql = null; try { LocalConn = Common_DB.DBConnection(); LocalConn.Open(); if (txtID.Text == "" || txtPWD.Text == "") { MessageBox.Show("ID 또는 Password를 입력 하세요..."); return; } sql = "select pwd from member "; sql += " where id = " + "'" + txtID.Text + "'"; myReader = Common_DB.DataSelect(sql, LocalConn); if (myReader.Read()) { if (txtPWD.Text != myReader["pwd"].ToString()) { MessageBox.Show("Password가 맞지 않습니다..."); return; } } else { MessageBox.Show("등록되지 않은 ID 입니다."); return; } //----------- ID가 PWD가 맞는 경우 FrmMDIMain m = new FrmMDIMain(); m.Show(); //m.Owner = this; //--------------------------------- this.Hide(); Log.WriteLine("FrmLogin", "[로그인 :" + txtID.Text + "]"); } catch (Exception e1) { Log.WriteLine("FrmLogin", e1.ToString()); Log.WriteLine("FrmLogin", sql); MessageBox.Show("FrmLogin", "로그인 오류! " + sql); } }
private void btnLogin_Click(object sender, EventArgs e) { OleDbDataReader myReader; string sql = null; try { localConn = Common_DB.DBConnection(); localConn.Open(); if (txtID.Text == "" || txtPWD.Text == "") { MessageBox.Show("ID 또는 PWD를 입력하세요"); } sql = "select pwd from member"; sql += " where id=" + "'" + txtID.Text + "'"; myReader = Common_DB.DataSelect(sql, localConn); if (myReader.Read()) { if (txtPWD.Text != myReader["pwd"].ToString()) { MessageBox.Show("pwd가 맞지 않습니다"); return; } } else { MessageBox.Show("ID가 맞지 않습니다"); return; } FrmMDIMain m = new FrmMDIMain(); m.Show(); this.Hide(); Log.WriteLine("frmlogin", "[login :"******"]"); } catch (Exception e1) { Log.WriteLine("frmlogin", e1.ToString()); Log.WriteLine("frmlogin", sql); MessageBox.Show("frmlogin", "로그인 오류 : " + sql); } }