private void Form1_Load(object sender, EventArgs e) { hapus_edit(); hapus_member(); cmbkjrsan.SelectedIndex = 0; AutoGeneratedID autoid = new AutoGeneratedID(); string id_member = autoid.AutoIDMember(); txtidmember.Text = id_member; txtidmember.ReadOnly = true; try { koneksi = conn.con(); koneksi.Open(); sql = "Select * from tb_Member order by id_member desc"; adapter.SelectCommand = new SqlCommand(sql, koneksi); adapter.Fill(ds, "Member"); dv = new DataView(); dv.Table = ds.Tables[0]; dataGridView1.DataSource = dv; dataGridView2.DataSource = dv; dataGridView3.DataSource = dv; dataGridView4.DataSource = dv; koneksi.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { koneksi.Close(); } }
private void button1_Click_1(object sender, EventArgs e) { try { String nama = txtnama.Text; String nim = txtnim.Text; String kelas = txtkelas.Text; String alamat = riscalmt.Text; String no_telp = txttlpn.Text; Regex reg = new Regex(@"^[A-Z a-z]+$"); Match match_huruf = reg.Match(nama); Regex reg1 = new Regex(@"^[0-9]+$"); Match match_angka = reg1.Match(nim); Match match_angka1 = reg1.Match(no_telp); if (nim == "") { errorProvider1.Clear(); errorProvider1.SetError(txtnim, "Nim Tidak Boleh Kosong!"); var warning = MessageBox.Show("Nim Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (!match_angka.Success) { errorProvider1.Clear(); errorProvider1.SetError(txtnim, "Nim Harus Berupa Angka!"); var warning = MessageBox.Show("Nim Harus Berupa Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (nim.Length < 9) { errorProvider1.Clear(); errorProvider1.SetError(txtnim, "Nim Minimal Harus 9 Digit Angka!"); var warning = MessageBox.Show("Nim Minimal Harus 9 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (nim.Length > 11) { errorProvider1.Clear(); errorProvider1.SetError(txtnim, "Nim Maksimal Harus 11 Digit Angka!"); var warning = MessageBox.Show("Nim Maksimal Harus 11 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (nama == "") { errorProvider1.Clear(); errorProvider1.SetError(txtnama, "Nama Tidak Boleh Kosong!"); var warning = MessageBox.Show("Nama Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (!match_huruf.Success) { errorProvider1.Clear(); errorProvider1.SetError(txtnama, "Nama Harus Berupa Huruf!"); var warning = MessageBox.Show("Nama Harus Berupa Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (nama.Length < 3) { errorProvider1.Clear(); errorProvider1.SetError(txtnama, "Nama Minimal 3 Huruf!"); var warning = MessageBox.Show("Nama Minimal 3 Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (nama.Length > 30) { errorProvider1.Clear(); errorProvider1.SetError(txtnama, "Nama Maksimal 30 Huruf!"); var warning = MessageBox.Show("Nama Maksimal 30 Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (kelas == "") { errorProvider1.Clear(); errorProvider1.SetError(txtkelas, "Kelas Tidak Boleh Kosong!"); var warning = MessageBox.Show("Kelas Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (kelas.Length < 4) { errorProvider1.Clear(); errorProvider1.SetError(txtkelas, "Kelas Minimal 4 Character!"); var warning = MessageBox.Show("Kelas Minimal 4 Character!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (kelas.Length > 6) { errorProvider1.Clear(); errorProvider1.SetError(txtkelas, "Kelas Maksimal 5 Character!"); var warning = MessageBox.Show("Kelas Maksimal 5 Character!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (cmbkjrsan.SelectedIndex == 0) { errorProvider1.Clear(); errorProvider1.SetError(cmbkjrsan, "Jurusan Harus Dipilih!"); var warning = MessageBox.Show("Jurusan Harus Dipilih!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (alamat == "") { errorProvider1.Clear(); errorProvider1.SetError(riscalmt, "Alamat Tidak Boleh Kosong!"); var warning = MessageBox.Show("Alamat Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (alamat.Length < 4) { errorProvider1.Clear(); errorProvider1.SetError(riscalmt, "Alamat Minimal 4 Huruf!"); var warning = MessageBox.Show("Alamat Minimal 4 Huruf!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (alamat.Length > 50) { errorProvider1.Clear(); errorProvider1.SetError(riscalmt, "Alamat Maksimal 50 Character!"); var warning = MessageBox.Show("Alamat Maksimal 50 Character!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (no_telp == "") { errorProvider1.Clear(); errorProvider1.SetError(txttlpn, "No Telp/Hp Tidak Boleh Kosong!"); var warning = MessageBox.Show("No Telp/Hp Tidak Boleh Kosong!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (!match_angka1.Success) { errorProvider1.Clear(); errorProvider1.SetError(txttlpn, "No Telp/Hp Harus Berupa Angka!"); var warning = MessageBox.Show("No Telp/Hp Harus Berupa Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (no_telp.Length < 3) { errorProvider1.Clear(); errorProvider1.SetError(txttlpn, "No Telp/Hp Minimal 3 Digit Angka!"); var warning = MessageBox.Show("No Telp/Hp Minimal 3 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else if (no_telp.Length > 13) { errorProvider1.Clear(); errorProvider1.SetError(txttlpn, "No Telp/Hp Maksimal 13 Digit Angka!"); var warning = MessageBox.Show("No Telp/Hp Maksimal 13 Digit Angka!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } else { string jk = ""; if (radioButton1.Checked || radioButton2.Checked) { if (radioButton1.Checked) { jk = "Pria"; } else { jk = "Wanita"; } koneksi = conn.con(); SqlCommand command = new SqlCommand("insert into tb_Member (id_member, NIM, nama, kelas, jurusan, alamat, no_telp, jenis_kelamin) values ('" + txtidmember.Text + "','" + txtnim.Text + "','" + txtnama.Text + "','" + txtkelas.Text + "','" + cmbkjrsan.SelectedItem + "','" + riscalmt.Text + "','" + txttlpn.Text + "','" + jk + "');", koneksi); adapter = new SqlDataAdapter("select * from tb_Member order by id_member desc", koneksi); koneksi.Open(); DataTable dtMember = new DataTable(); command.ExecuteNonQuery(); dataGridView1.DataSource = dtMember; dataGridView2.DataSource = dtMember; dataGridView3.DataSource = dtMember; adapter.SelectCommand.ExecuteNonQuery(); adapter.Fill(dtMember); MessageBox.Show("Data success ditambah"); AutoGeneratedID autoid = new AutoGeneratedID(); string id_member = autoid.AutoIDMember(); txtidmember.Text = id_member; txtidmember.ReadOnly = true; //dataGridView1.DataSource = dtMember; errorProvider1.Clear(); hapus(); koneksi.Close(); } else { errorProvider1.Clear(); errorProvider1.SetError(radioButton2, "Jenis Kelamin Harus Dipilih!"); var warning = MessageBox.Show("Jenis Kelamin Harus Dipilih!", "Perhatian", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning); if (warning == DialogResult.Cancel) { hapus(); errorProvider1.Clear(); } } } } catch (SqlException se) { MessageBox.Show(se.Message); } }