protected void Button2_Click(object sender, EventArgs e)
        {
            EMSEntities Context = new EMSEntities();


            EntittyFramewordWebApplication4.StudentDetail stud1 = new StudentDetail();
            stud1.id      = "67";
            stud1.name    = "ziauddin";
            stud1.address = "chittagong";
            stud1.marks   = 88;
            stud1.section = "C";
            Context.StudentDetails.Add(stud1);
            Context.SaveChanges();
            Label1.Text = "added";
        }
        protected void Button4_Click(object sender, EventArgs e)
        {
            EMSEntities dbcontext = new EMSEntities();

            EntittyFramewordWebApplication4.StudentDetail stud1 = new StudentDetail();
            try
            {
                string idd = TextBox2.Text;

                stud1 = dbcontext.StudentDetails.FirstOrDefault(xx => xx.id == idd);
                dbcontext.StudentDetails.Remove(stud1);
                dbcontext.SaveChanges();
                Label1.Text = "delated successfull";
            }
            catch (Exception e1)
            {
                Label1.Text = "not found";
            }
        }
        protected void Button7_Click(object sender, EventArgs e)
        {
            //EMSEntities dbcontext = new EMSEntities();
            //emp e1 = new emp();
            //e1.empId = int.Parse(TextBox2.Text);
            //e1.name = TextBox4.Text;
            //e1.deptno = int.Parse(TextBox5.Text);
            //e1.job = TextBox5.Text;
            //e1.salary = int.Parse(TextBox6.Text);
            //dbcontext.emps.Add(e1);
            //dbcontext.SaveChanges();
            //Label1.Text = "added from emp table";
            EMSEntities dbcontext = new EMSEntities();
            emp         e1        = new emp();

            e1.empId  = 786;
            e1.name   = "pabel";
            e1.deptno = 56;
            e1.job    = "hr";
            e1.salary = 6700;
            dbcontext.emps.Add(e1);
            dbcontext.SaveChanges();
            Label1.Text = "added from emp table";
        }