MID Pemerograman Visual (8020180091) скачать в хорошем качестве

MID Pemerograman Visual (8020180091)

public static OleDbConnection con; public static OleDbCommand cmd; public static OleDbDataAdapter damhs; public static DataTable tblmhs = new DataTable(); public static OleDbConnection konek_db() { OleDbConnection con = new OleDbConnection ("provider=microsoft.ace.oledb.12.0;data source=dbakademik.accdb"); con.Open(); return con; } void konek_mhs() { z.tblmhs.Clear(); z.damhs.Fill(z.tblmhs); } void ambildata() { z.tblmhs.Clear(); z.damhs.Fill(z.tblmhs); } private void Form1_Load(object sender, EventArgs e) { z.con = z.konek_db(); z.damhs= new OleDbDataAdapter(" select * from mahasiswa ",z.con); konek_mhs(); dataGridView1.DataSource = z.tblmhs; dataGridView1.AutoGenerateColumns = true; dataGridView1.Columns[0].HeaderText = "NIM"; dataGridView1.Columns[0].Width = 100; dataGridView1.Columns[0].HeaderText = "Nama Mahasiswa"; dataGridView1.Columns[0].Width = 130; dataGridView1.ReadOnly = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.DefaultCellStyle.SelectionBackColor = Color.AntiqueWhite; dataGridView1.DefaultCellStyle.SelectionForeColor = Color.Black; dataGridView1.SelectionMode = dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; }perintah untuk simpan z.cmd = new OleDbCommand ("select * from Buku where Kode_Buku='" + txtbox.Text + "'", z.con); z.dtr = z.cmd.ExecuteReader(); if (z.dtr.HasRows) { MessageBox.Show("Kode Buku tersebut sudah ada", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtbox.Clear(); txtbox.Focus(); } else if (txtbox.Text.Trim() == "") { MessageBox.Show("Kode Buku masih kosong", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtbox.Clear(); txtbox.Focus(); } else { z.cmd = new OleDbCommand ("insert into Buku(Kode_Buku,Judul_Buku,Pengarang) " + "values ('" + txtbox.Text + "'," + "'" + txtbox.Text + "'," + "'" + txtbox.Text + "')", z.con); z.cmd.ExecuteNonQuery(); ambildata(); MessageBox.Show("Data sudah tersimpan", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Information); bersih(); }perintah untuk hapus int brs; string kode; brs = dataGridView1.CurrentRow.Index; kode = dataGridView1[0, brs].Value.ToString(); if (MessageBox.Show("Apakah Kode Buku =" + kode + "
" + "ingin dihapus?", "Pesan", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { z.cmd = new OleDbCommand ("delete from Buku where Kode_Buku='" + kode + "'", z.con); z.cmd.ExecuteNonQuery(); ambildata(); MessageBox.Show("Data sudah terhapus", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Information); }//membaca data database public static OleDbDataReader dtr;perintah untuk edit if (button4.Text == "edit") { button4.Text = "Edit"; button2.Enabled = false; button3.Enabled = false; textBox1.Enabled = false; int brs; brs = dataGridView1.CurrentRow.Index; textBox1.Text = dataGridView1[0, brs].Value.ToString(); textBox3.Text = dataGridView1[1, brs].Value.ToString(); textBox2.Text = dataGridView1[2, brs].Value.ToString(); } else if (button4.Text == "Edit") { button4.Text = "edit"; button2.Enabled = true; button3.Enabled = true; textBox1.Enabled = true; z.cmd = new OleDbCommand ("update Buku set " + "Judul_Buku ='" + textBox3.Text + "'," + "Pengarang ='" + textBox2.Text + "' where " + "Kode_Buku ='" + textBox1.Text + "'", z.con); z.cmd.ExecuteNonQuery(); ambildata(); MessageBox.Show("Data sudah Di Edit", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Information); bersih(); }