示例#1
0
 private void Form1_Load(object sender, EventArgs e)
 {
     using (var dbCtx = new EmpDBContext())
     {
         dgv.DataSource = dbCtx.tbl_employee.ToList();
     }
 }
示例#2
0
        private void Btndelete_Click(object sender, EventArgs e)
        {
            int ecode  = int.Parse(textecode.Text);
            var dbctx  = new EmpDBContext();
            var result = dbctx.tbl_employee.Where(o => o.EmpId == ecode).SingleOrDefault();

            dbctx.tbl_employee.Remove(result);
            dbctx.SaveChanges();
            MessageBox.Show("yakanna delete madya");
            dgv.DataSource = dbctx.tbl_employee.ToList();
        }
示例#3
0
        private void Btninsert_Click(object sender, EventArgs e)
        {
            using (var dbCtx = new EmpDBContext())
            {
                //take user input for insert
                var record = new Tbl_Employee
                {
                    EmpId  = int.Parse(textecode.Text),
                    Ename  = textename.Text,
                    Salary = int.Parse(textsalary.Text),
                    Deptid = int.Parse(textdeptid.Text)
                };

                dbCtx.tbl_employee.Add(record);
                dbCtx.SaveChanges();
                MessageBox.Show("inserted successfully");
                dgv.DataSource = dbCtx.tbl_employee.ToList();
            }
        }