void loadData()
{
Database1Entities database1Entities = new Database1Entities();
var data = (from d in database1Entities.t_matakuliah
select new
{
id = d.Id,
kode_matkul = d.kode_matkul,
nama_matkul = d.nama_matkul
});
dataGridView1.DataSource = data.ToList();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Kode Matkul";
dataGridView1.Columns[2].HeaderText = "Nama Matkul";
}
private void button1_Click(object sender, EventArgs e)
{
Database1Entities database1Entities = new Database1Entities();
t_matakuliah matakuliah = new t_matakuliah();
matakuliah.kode_matkul = textBox1.Text;
matakuliah.nama_matkul = textBox2.Text;
database1Entities.t_matakuliah.Add(matakuliah);
database1Entities.SaveChanges();
loadData();
MessageBox.Show("Data Sukses Di input");
resetFrom();
}
private void button3_Click(object sender, EventArgs e)
{
try
{
int idMatkul = int.Parse(id.Text);
Database1Entities db = new Database1Entities();
var data = (from d in db.t_matakuliah
where d.Id == idMatkul
select d).FirstOrDefault();
db.t_matakuliah.Remove(data);
db.SaveChanges();
loadData();
MessageBox.Show("Data Telah Dihapus");
resetFrom();
}
catch (Exception)
{
MessageBox.Show("Pilih Data Terlebih Dahulu");
}
}