private void RefreshMasterList() { // not yet tested , requires view from db DB = new FinalSanitariumMIS.Helpers.DatabaseHelper(); DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM VW_STAFF WHERE POSITION = 'doctor'"); dgv_masterlist.Rows.Clear(); while (rs.Read()) { Object[] d = new Object[5]; d[0] = rs.GetString(0); d[1] = rs.GetString(1); d[2] = rs.GetString(2); d[3] = rs.GetString(3); d[4] = rs.GetString(4); dgv_masterlist.Rows.Add(d); } }
private void btn_reigster_Click(object sender, EventArgs e) { DB = new FinalSanitariumMIS.Helpers.DatabaseHelper(); DB2ResultSet rs = DB.QueryWithResultSet("SELECT * FROM VW_STAFF WHERE supplier_number = '" + tb_tel_no.Text + "'"); if (rs.Read()) { //DB.Query("UPDATE STAFF SET " + // "SUPPLIER_NUMBER = " + tb_supplier_number.Text + "," + // "SUPPLIER_NAME = '" + tb_supplier_name.Text + "'," + // "ADDRESS = '" + tb_address.Text + "'," + // "TELNUMBER = " + tb_tel_no.Text + "," + // "FAXNUMBER = " + tb_fax_no.Text + " WHERE SUPPLIER_NUMBER = " + // dgv_masterlist.CurrentRow.Cells[0].Value.ToString()); } else { //DB.Query("INSERT INTO SUPPLIER VALUES (" + // tb_supplier_number.Text + ",'" + tb_supplier_name.Text + "','" + // tb_address.Text + "'," + tb_tel_no.Text + "," + tb_fax_no.Text + ")"); } }