C# - DataGridView Passing data ke Form CRUD dengan Stored Procedure #3

Lanjut dari postingan sebelumnya sekarang saya posting untuk listing code CRUD Strore Procedure dengan visual c# 2010

 using System;  
 using System.Collections.Generic;  
 using System.ComponentModel;  
 using System.Data;  
 using System.Drawing;  
 using System.Linq;  
 using System.Text;  
 using System.Windows.Forms;  
 namespace rusdhaRS.Forms  
 {  
   public partial class PegawaiForm : Form  
   {  
     DataTable dtPegawai;  
     koneksi db = new koneksi();  
     public model.rs_pegawai rs_pegawai;   
     public PegawaiForm()  
     {  
       InitializeComponent();  
     }  
     private void cstmdgv()  
     {  
       dgv.Columns[1].HeaderText = "Nip";  
       dgv.Columns[2].HeaderText = "Nama Pegawai";  
       dgv.Columns[3].HeaderText = "Tempat Lahir";  
       dgv.Columns[4].HeaderText = "Tangal Lahir";  
       dgv.Columns[5].HeaderText = "Jenis Kelamin";  
       dgv.Columns[6].HeaderText = "Alamat";  
       dgv.Columns[7].HeaderText = "Provinsi";  
       dgv.Columns[8].HeaderText = "Kota";  
       dgv.Columns[9].HeaderText = "Tlp";  
       dgv.Columns[1].Width = 80;  
       dgv.Columns[2].Width = 100;  
       dgv.Columns[3].Width = 100;  
       dgv.Columns[4].Width = 100;  
       dgv.Columns[5].Width = 50;  
       dgv.Columns[6].Width = 150;  
       dgv.Columns[7].Width = 100;  
       dgv.Columns[8].Width = 100;  
       dgv.Columns[9].Width = 80;  
       dgv.Columns[0].Visible = false;  
       dgv.Focus(); // membuat kursor fokus  
       dgv.CurrentCell = dgv.Rows[0].Cells[1]; // arah kursor fokus  
       foreach (DataGridViewColumn column in dgv.Columns)  
       {  
         column.SortMode = DataGridViewColumnSortMode.NotSortable; // menghilangkan sorttable pada headercolom  
         column.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; // center header  
       }  
     }  
     public void reset()  
     {  
       txtIDPegawai.Text = "";  
       txtNip.Text = "";  
       txtNamaPeg.Text = "";  
       txtTempatLahir.Text = "";  
       dtpLahir.Text = DateTime.Today.ToString();  
       txtAlamat.Text = "";  
       cmbJkel.Text = "";  
       cmbProv.Text = "";  
       cmbKota.Text = "";  
       txtTlp.Text = "";  
     }  
     private void reload()   
     {  
       this.dtPegawai = this.db.execQueryProc("pegawaiVIEW");  
       dgv.DataSource = dtPegawai;  
       reset();  
       cstmdgv();  
       this.Refresh();  
     }  
     private void PegawaiForm_Load(object sender, EventArgs e)  
     {  
       if (this.rs_pegawai != null)  
       {  
         txtIDPegawai.Text = dgv.CurrentRow.Cells["id_pegawai"].Value.ToString();  
         txtNip.Text = dgv.CurrentRow.Cells["nip"].Value.ToString();  
         txtNamaPeg.Text = dgv.CurrentRow.Cells["nama"].Value.ToString();  
         txtTempatLahir.Text = dgv.CurrentRow.Cells["tempat_lahir"].Value.ToString();  
         dtpLahir.Text = dgv.CurrentRow.Cells["tanggal_lahir"].Value.ToString();  
         cmbJkel.Text = dgv.CurrentRow.Cells["jenis_kelamin"].Value.ToString();  
         txtAlamat.Text = dgv.CurrentRow.Cells["alamat"].Value.ToString();  
         cmbProv.Text = dgv.CurrentRow.Cells["provinsi"].Value.ToString();  
         cmbKota.Text = dgv.CurrentRow.Cells["kota"].Value.ToString();  
         txtTlp.Text = dgv.CurrentRow.Cells["tlp"].Value.ToString();  
       }  
       else  
       {  
         reload();  
       }  
     }  
     private void btnBatal_Click(object sender, EventArgs e)  
     {  
       this.Close();  
     }  
     private void btnSimpan_Click(object sender, EventArgs e)  
     {  
       if (MessageBox.Show("Simpan data !!!", "pesan", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Cancel)  
       {  
         return;  
       }  
       if (this.rs_pegawai == null)  
       {  
         this.rs_pegawai = new model.rs_pegawai();  
       }  
       this.rs_pegawai.nip = txtNip.Text;  
       this.rs_pegawai.nama=txtNamaPeg.Text;  
       this.rs_pegawai.tempat_lahir = txtTempatLahir.Text;  
       this.rs_pegawai.tanggal_lahir = DateTime.Parse(dtpLahir.Text);  
       this.rs_pegawai.jenis_kelamin = cmbJkel.Text;  
       this.rs_pegawai.alamat =txtAlamat.Text;  
       this.rs_pegawai.provinsi=cmbProv.Text;  
       this.rs_pegawai.kota=cmbKota.Text;  
       this.rs_pegawai.tlp = txtTlp.Text;  
       if (this.rs_pegawai.id_pegawai == 0 )  
       {  
         this.db.execQueryProc("PegawaiINSERT", new object[]  
         {  
           this.rs_pegawai.nip,  
           this.rs_pegawai.nama,  
           this.rs_pegawai.tempat_lahir,  
           this.rs_pegawai.tanggal_lahir,  
           this.rs_pegawai.jenis_kelamin,  
           this.rs_pegawai.alamat,  
           this.rs_pegawai.provinsi,  
           this.rs_pegawai.kota,  
           this.rs_pegawai.tlp  
         });  
         MessageBox.Show("Data Berhasil diSimpan");  
         reload();  
       }  
       else  
       {  
         this.db.execQueryProc("PegawaiUPDATE", new object[]  
         {  
           this.rs_pegawai.id_pegawai,  
           this.rs_pegawai.nip,  
           this.rs_pegawai.nama,  
           this.rs_pegawai.tempat_lahir,  
           this.rs_pegawai.tanggal_lahir,  
           this.rs_pegawai.jenis_kelamin,  
           this.rs_pegawai.alamat,  
           this.rs_pegawai.provinsi,  
           this.rs_pegawai.kota,  
           this.rs_pegawai.tlp  
         });  
         MessageBox.Show("Data Berhasil Update");  
         reload();  
       }  
     }  
     private void btnHapus_Click(object sender, EventArgs e)  
     {  
       if (MessageBox.Show("Anda yakin hapus ?", "Konfirmasi", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Cancel)  
       {  
         return;  
       }  
       this.db.execQueryProc("pegawaiDELETE", new object[]  
       {  
         dgv.CurrentRow.Cells["id_pegawai"].Value  
       });  
       MessageBox.Show("Data Berhasil Dihapus");  
       reload();  
     }  
     private void dgv_Click(object sender, EventArgs e)  
     {    
        model.rs_pegawai pg = new model.rs_pegawai();  
        pg.id_pegawai = (int)dgv.CurrentRow.Cells["id_pegawai"].Value;  
        pg.nip = dgv.CurrentRow.Cells["nip"].Value.ToString();  
        pg.nama = dgv.CurrentRow.Cells["nama"].Value.ToString();  
        pg.tempat_lahir = dgv.CurrentRow.Cells["tempat_lahir"].Value.ToString();  
        pg.tanggal_lahir = (DateTime)dgv.CurrentRow.Cells["tanggal_lahir"].Value;  
        pg.jenis_kelamin = dgv.CurrentRow.Cells["jenis_kelamin"].Value.ToString();  
        pg.alamat = dgv.CurrentRow.Cells["alamat"].Value.ToString();  
        pg.provinsi = dgv.CurrentRow.Cells["provinsi"].Value.ToString();  
        pg.kota = dgv.CurrentRow.Cells["kota"].Value.ToString();  
        pg.tlp = dgv.CurrentRow.Cells["tlp"].Value.ToString();  
        rs_pegawai = pg;  
        PegawaiForm_Load(sender, e);  
     }  
     private void btnBaru_Click(object sender, EventArgs e)  
     {  
       reset();  
     }  
     private void btnBaru_Click_1(object sender, EventArgs e)  
     {  
       txtNip.Focus();  
       reset();  
     }  
   }//end claas  
 }//end namespace  

BACK POSTING.. #1