View difference between Paste ID: <a href="/nt9XyDs9">nt9XyDs9</a> and <a href="/xnLKvvGW">xnLKvvGW</a>

private void button1_Click(object sender, EventArgs e)
1		private void button1_Click(object sender, EventArgs e)
2		{
3	-	/code for insert a new record in table pembelian/
3	+	/code to insert a new record in table pembelian/
4		perintahsql = new SqlCeCommand("INSERT INTO pembelian (kd_barang, nama, jumlah) VALUES (@kd_barang, @nama, @jumlah)", koneksi);
5		perintahsql.Parameters.AddWithValue("@kd_barang", textBox1.Text);
6		perintahsql.Parameters.AddWithValue("@nama", textBox2.Text);
7		perintahsql.Parameters.AddWithValue("@jumlah", textBox3.Text);
8
9		koneksi.Open();
10		perintahsql.ExecuteNonQuery();
11		koneksi.Close();
12		pembelian();
13
14		/get the sum from column jumlah in table pembelian where kd_barang = 111/
15		string beli;
16		perintahsql = new SqlCeCommand("SELECT SUM(jumlah) as beli FROM pembelian WHERE kd_barang = 111", koneksi);
17		koneksi.Open();
18		beli = perintahsql.ExecuteScalar().ToString();
19		koneksi.Close();
20		MessageBox.Show(beli);
21
22		/get the sum from column jumlah in table gudang where kd_barang = 111/
23		string gudang_total;
24		perintahsql = new SqlCeCommand("SELECT SUM(jumlah) as gudang FROM gudang WHERE kd_barang = 111", koneksi);
25		koneksi.Open();
26		gudang_total = perintahsql.ExecuteScalar().ToString();
27		koneksi.Close();
28		int total = int.Parse(beli) + int.Parse(gudang_total);
29
30		/update table gudang where kd_barang = 111 after insertion in table pembelian/
31		perintahsql = new SqlCeCommand("UPDATE gudang SET nama = 'karet', jumlah = " + total.ToString() + " WHERE kd_barang = 111", koneksi);
32		koneksi.Open();
33		perintahsql.ExecuteNonQuery();
34		koneksi.Close();
35		MessageBox.Show(total.ToString());
36		gudang();
37		}