public FormEdit() { // // The InitializeComponent() call is required for Windows Forms designer support. // InitializeComponent(); for (int i = 1980; i <= 2010; i++) { editTahun.Items.Add(i); } for (int j = 2000; j <= 7000; j += 500) { editHarga.Items.Add(j); } string sqlQueryString = ("Select * from tbl_tipe_katalog"); TampilData f1 = new TampilData(); OleDbCommand SQLQuery = new OleDbCommand(); DataTable data = null; OleDbDataAdapter dataAdapter = null; SQLQuery.CommandText = sqlQueryString; SQLQuery.Connection = f1.database; data = new DataTable(); dataAdapter = new OleDbDataAdapter(SQLQuery); dataAdapter.Fill(data); foreach (DataRow drRow in data.Rows) { string id = drRow["id_tipe_katalog"].ToString(); string nama_kat = drRow["tipe_katalog"].ToString(); editTipe.Items.Add(id + " - " + nama_kat); } }
void Button1Click(object sender, EventArgs e) { TampilData f1 = new TampilData(); nama = editNama.Text.ToString(); alamat = editAlamat.Text.ToString(); jaminan = cmbJaminan.Text.ToString(); total = editHarga.Text.ToString(); if (rdSudah.Checked == true) { status = "sudah"; } else if (rdBelum.Checked == true) { status = "belum"; } string SQLUpdateString = "update tbl_pelanggan set nama='" + nama + "', alamat='" + alamat + "', jaminan='" + jaminan + "', total_bayar='" + total + "', status='" + status + "' where id_pelanggan=" + id_penyewa + ""; try{ OleDbCommand SQLCommand = new OleDbCommand(); SQLCommand.CommandText = SQLUpdateString; SQLCommand.Connection = f1.database; int response = SQLCommand.ExecuteNonQuery(); MessageBox.Show("Update data berhasil...!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } catch (Exception) { MessageBox.Show("Error"); } }
void Button1Click(object sender, EventArgs e) { if (usrName.Text == "admin" && psWord.Text == "admin") { Form frmData = new TampilData(); frmData.Show(); this.Hide(); } else { MessageBox.Show("Username dan Password tidak Valid...!!!", "Username & Password Salah...!!!"); } }
void Button1Click(object sender, EventArgs e) { TampilData f1 = new TampilData(); nama = editNamaTipe.Text.ToString(); string SQLUpdateString = "update tbl_tipe_katalog set tipe_katalog='" + nama + "' where id_tipe_katalog=" + id_kat + ""; try{ OleDbCommand SQLCommand = new OleDbCommand(); SQLCommand.CommandText = SQLUpdateString; SQLCommand.Connection = f1.database; int response = SQLCommand.ExecuteNonQuery(); MessageBox.Show("Update data berhasil...!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } catch (Exception) { MessageBox.Show("Error"); } }
void Button1Click(object sender, EventArgs e) { TampilData f1 = new TampilData(); nama = editJudul.Text.ToString(); produsen = editPenerbit.Text.ToString(); tipe = editTipe.Text.Substring(0, 1); tahun = editTahun.Text.ToString(); harga = editHarga.Text.ToString(); string SQLUpdateString = "update tbl_katalog set id_tipe_katalog='" + tipe + "', nama_katalog='" + nama + "', produsen='" + produsen + "', harga_sewa='" + harga + "', tahun_terbit='" + tahun + "' where id_katalog=" + id_cd + ""; try{ OleDbCommand SQLCommand = new OleDbCommand(); SQLCommand.CommandText = SQLUpdateString; SQLCommand.Connection = f1.database; int response = SQLCommand.ExecuteNonQuery(); MessageBox.Show("Update data berhasil...!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); } catch (Exception) { MessageBox.Show(tipe); } }