CRUD dan Report Viewer Pada Visual Studio
Apa itu CRUD ??
CRUD merupakan button button yang biasa digunakan dalam program visual studi, dengan C yang berarti Create, R yang berarti Read, U yang berarti Update dan D yang berarti Delete. Sedangakn Report Viewer merupakan salah satu item yang terdapat pada toolbox.
CRUD merupakan button button yang biasa digunakan dalam program visual studi, dengan C yang berarti Create, R yang berarti Read, U yang berarti Update dan D yang berarti Delete. Sedangakn Report Viewer merupakan salah satu item yang terdapat pada toolbox.
Pertama-tama kita harus membuat 3 form, dengan form 1 mdi parent, form 2 design program yang diinginkan, dan form 3 report viewer.
1. Form 1
Keterangan Interface | ||
No. | Nama Komponen | Variabel Komponen |
1 | Menu Strip | programToolStripMenuItem |
2 | Menu Strip | printToolStripMenuItem |
3 | Menu Strip | exitToolStripMenuItem |
2. Form 2
Keterangan Interface | ||
No. | Nama Komponen | Variabel Komponen |
1 | Label | Lbljual |
2 | Label | Lblket |
3 | Label | Lblnomor |
4 | Label | Lblnama |
5 | Label | Lblmerk |
6 | Label | Lblharga |
7 | Button | Btncreate |
8 | Button | btnupdate |
9 | Text Box | Txtnomor |
10 | Text Box | Txtnama |
11 | Label | Lblcari |
12 | Text Box | Txtcari |
13 | Combo Box | cbmerk |
14 | Text Box | txtharga |
15 | Button | btnrefresh |
16 | Button | btndelete |
17 | DataGridView | dgv |
3. Form 3
Keterangan Interface | ||
No. | Nama Komponen | Variabel Komponen |
1 | Reportviewer | Reportviewer1 |
Coding Program
Class Form 1 | ||
Nama Komponen | Event | Source Code |
programToolStripMenuItem | Click | private void programToolStripMenuItem_Click(object sender, EventArgs e) { Form2 sari = new Form2(); sari.Refresh(); //memanggil method refresh sari.MdiParent = this; //mdi parent sari.Show(); //menampilkan } |
exitToolStripMenuItem | Click | private void exitToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Anda yakin ingin keluar ?", "Awas!", MessageBoxButtons.OKCancel); if (dr == DialogResult.OK) //peringatan sebelum keluar program { this.Close(); //menutup program } } |
printToolStripMenuItem | click | private void printToolStripMenuItem_Click(object sender, EventArgs e) { Form3 sari = new Form3(); //memanggil form3 sari.Refresh() ; //memanggil method refresh sari.MdiParent = this; //mdi parent sari.Show(); //menampilkan sari } |
Class Form 2 | ||
Nama Komponen | Event | Source Code |
Form2 | Load | private void Form2_Load(object sender, EventArgs e) { gridview_databind(); //method gridview reset(); //method reset } |
btncreate | Click | private void btncreate_Click(object sender, EventArgs e) { try { SqlConnection conn = kon.GetConn(); //sql konek conn.Open(); //membuka sql string query = string.Format("insert into tabel_jual values('{0}','{1}','{2}')",txtnama.Text, cbmerk.SelectedItem.ToString(), txtharga.Text); //jumlah tabel SqlCommand command = new SqlCommand(query, conn); command.ExecuteNonQuery(); conn.Close(); //menutup sql MessageBox.Show("Data berhasil disimpan"); //peringatan data berhasil disimpan gridview_databind(); //method gridview reset(); //method refresh } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } |
txtsearch | txtchanged | private void txtsearch_TextChanged(object sender, EventArgs e) { try { SqlConnection conn = kon.GetConn(); conn.Open(); string query = "select nomor as NOMOR, nama_pembeli as NAMA_PEMBELI, merk_hp as MERK_HP, harga as HARGA from tabel_jual WHERE nomor LIKE '%" + txtsearch.Text + "%' OR nama_pembeli LIKE '%" + txtsearch.Text + "%' OR merk_hp LIKE '%" + txtsearch.Text + "%' OR harga LIKE '%" + txtsearch.Text + "%'"; //pencarian SqlCommand command = new SqlCommand(query, conn); SqlDataAdapter sda = new SqlDataAdapter(command); DataTable dt = new DataTable(); sda.Fill(dt); dgv.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } |
btnupdate | Click | private void btnupate_Click(object sender, EventArgs e) { try { SqlConnection conn = kon.GetConn(); conn.Open(); var query = "update tabel_jual set nama_pembeli='" + txtnama.Text + "',merk_hp='" + cbmerk.Text + "',harga='" + txtharga.Text + "' where nomor='" + txtnomor.Text + "'"; var command = new SqlCommand(query, conn); command.ExecuteNonQuery(); MessageBox.Show("Data Berhasil Diedit", "Pemberitahuan", MessageBoxButtons.OK, MessageBoxIcon.Information); //peringatan data berhasil diedit command.Dispose(); conn.Close(); //menutup program gridview_databind(); //method } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } |
btndelete | Click | private void btndelete_Click(object sender, EventArgs e) { try { SqlConnection conn = kon.GetConn(); conn.Open(); var nomor = dgv.CurrentRow.Cells[0].Value; var query = "delete from tabel_jual where nomor='" + nomor + "'"; SqlCommand command = new SqlCommand(query, conn); command.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Data berhasil dihapus"); //data berhasil disimpan gridview_databind(); //method } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } |
dgv | cellclick | private void dgv_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = dgv.Rows[e.RowIndex]; txtnomor.Text = row.Cells[0].Value.ToString(); txtnama.Text = row.Cells[1].Value.ToString(); cbmerk.Text = row.Cells[2].Value.ToString(); txtharga.Text = row.Cells[3].Value.ToString(); } //menampilkan data pada datagirdview |
btnrefresh | click | private void btnrefresh_Click(object sender, EventArgs e) { reset(); //method } |
Class Form 3 | ||
Nama Komponen | Event | Source Code |
Form3 | Load | private void Form3_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'Database1DataSet.tabel_jual' table. You can move, or remove it, as needed. this.tabel_jualTableAdapter.Fill(this.Database1DataSet.tabel_jual); this.reportViewer1.RefreshReport(); } //report viewer |