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";
        }
 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";
 }