Latek (Day-3) Coding untuk form gaji pegawai

        Melanjutkan Latek di hari kedua, pada latek dihari ketiga ini kami melanjutkan mengerjakan form gaji pegawai yang sudah didesain sebelumnya. Dan kali ini untuk menjalankan form tersebut dibutuhkan codingan agar aplikasi itu berjalan sesuai dengan apa yang sudah kita rencanakan. Adapun codingannya yang kami masukkan adalah seperti ini:

1:  using System;  
2:  using System.Collections.Generic;  
3:  using System.ComponentModel;  
4:  using System.Data;  
5:  using System.Drawing;  
6:  using System.Linq;  
7:  using System.Text;  
8:  using System.Threading.Tasks;  
9:  using System.Windows.Forms;  
10:  using MySql.Data.MySqlClient;  
11:  namespace gajipegawai  
12:  {  
13:    public partial class Form1 : Form  
14:    {  
15:      public Form1()  
16:      {  
17:        InitializeComponent();  
18:      }  
19:      MySqlConnection dbconect = new MySqlConnection("datasource=127.0.0.1;port=3306;username=root;password=;database=hrd_sttal");  
20:      private void Button1_Click(object sender, EventArgs e)  
21:      {  
22:        AddData();  
23:      }  
24:      private void AddData()  
25:      {  
26:        string Nama = textBox1.Text;  
27:        string Pangkat = textBox2.Text;  
28:        string Gaji= textBox3.Text;  
29:        string Potongan= textBox4.Text;  
30:    string query = string.Format("INSERT INTO Gaji_pegawai(`Nama`,`Pangkat`,`Gaji`,`Potongan`) VALUES ('{0}','{1}','{2}','{3}')", Nama, Pangkat, Gaji, Potongan);  
31:        MySqlCommand commandb = new MySqlCommand(query, dbconect);  
32:        commandb.CommandTimeout = 60;  
33:        try  
34:        {  
35:          dbconect.Open();  
36:          MySqlDataReader myreader = commandb.ExecuteReader();  
37:          MessageBox.Show("Data berhasil dimasukkan");  
38:          dbconect.Close();  
39:        }  
40:        catch (Exception e)  
41:        {  
42:          MessageBox.Show("Error :" + e.Message);  
43:        }  
44:      }  
45:      private void Button4_Click(object sender, EventArgs e)  
46:      {  
47:        ShowData();  
48:      }  
49:      private void ShowData()  
50:      {  
51:        string query = string.Format("Select * gaji_pegawai");  
52:        MySqlCommand commandb = new MySqlCommand(query, dbconect);  
53:        commandb.CommandTimeout = 60;  
54:        try  
55:        {  
56:          dbconect.Open();  
57:          MySqlDataAdapter SDA = new MySqlDataAdapter(query, dbconect);  
58:          DataTable Data = new DataTable();  
59:          SDA.Fill(Data);  
60:          dataGridView1.DataSource = Data;  
61:          dbconect.Close();  
62:        }  
63:        catch (Exception e)  
64:        {  
65:          MessageBox.Show("Error :" + e.Message);  
66:        }  
67:      }  
68:  private void DataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)  
69:      {  
70:        textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();  
71:        textBox2.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();  
72:        textBox3.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();  
73:        textBox4.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();  
74:      }  
75:      private void Button2_Click(object sender, EventArgs e)  
76:      {  
77:      }  
78:      private void Button3_Click(object sender, EventArgs e)  
79:      {  
80:        Delete();  
81:      }  
82:      private void Delete()  
83:      {  
84:        string nama = textBox1.Text;  
85:        string pangkat = textBox2.Text;  
86:        string gaji = textBox3.Text;  
87:        string potongan = textBox4.Text;  
88:        string query = string.Format("DELETE FROM gaji_pegawai where Nama='" + nama + "");  
89:        MySqlCommand commandb = new MySqlCommand(query, dbconect);  
90:        commandb.CommandTimeout = 60;  
91:        try  
92:        {  
93:          dbconect.Open();  
94:          MySqlDataReader myreader = commandb.ExecuteReader();  
95:          MessageBox.Show("Data berhasil dihapus");  
96:          dbconect.Close();  
97:        }  
98:        catch (Exception e)  
99:        {  
100:          MessageBox.Show("Error :" + e.Message);  
101:        }  
102:      }  
103:      private void Form1_Load(object sender, EventArgs e)  
104:      {  
105:      }  
106:      private void textBox1_TextChanged(object sender, EventArgs e)  
107:      {  
108:      }  
109:    }  
110:  }