예제 #1
0
        private void btmTambah_Click_1(object sender, EventArgs e)
        {
            FormTambahLogistik fr = new FormTambahLogistik();

            fr.ShowDialog();
            showData();
            jumlah      = dataGridView1.Rows.Count;
            lblJml.Text = (jumlah - 1).ToString();
            totalData();
        }
        private void btmSimpan_Click(object sender, EventArgs e)
        {
            if (dtTgl.Text == "")
            {
                MessageBox.Show("Nama belum diisi!");
                dtTgl.Focus();
            }
            if (txtNama.Text == "")
            {
                MessageBox.Show("Nama belum diisi!");
                txtNama.Focus();
            }
            else if (txtAlamat.Text == "")
            {
                MessageBox.Show("Alamat belum diisi!");
                txtAlamat.Focus();
            }
            else if (txtTelp.Text == "")
            {
                MessageBox.Show("No Telp belum diisi!");
                txtTelp.Focus();
            }
            else
            {
                sqlQuery = "INSERT INTO tb_logistik VALUES " +
                           "('" + dtTgl.Text + "', '" + txtNama.Text + "', '" + txtAlamat.Text + "', '" + txtTelp.Text + "', '" + txtBeras.Text + "', '" + txtMie.Text + "', '" + txtMasker.Text + "', '" + txtAqua.Text + "', '" + txtNasi.Text + "', '" + txtSusu.Text + "', '" + txtSelimut.Text + "', '" + txtRoti.Text + "', '" + txtLain.Text + "')";

                conn.Open();
                SqlCommand sqlCmd = new SqlCommand(sqlQuery, conn);
                sqlCmd.ExecuteNonQuery();
                conn.Close();
                MessageBox.Show("Data Bantuan Logistik tersimpan!");
                FormTambahLogistik fr = new FormTambahLogistik();
                this.Close();
            }
        }