protected void Button5_Click(object sender, EventArgs e) { string id = TextBox2.Text; EMSEntities dbcontext = new EMSEntities(); var stud = from dd in dbcontext.StudentDetails where dd.id == id select dd; bool flag = false; foreach (var student in stud) { TextBox3.Text = student.name; TextBox4.Text = student.address; TextBox5.Text = student.section; TextBox6.Text = student.marks.ToString(); flag = true; } if (flag == false) { Label1.Text = "not found"; } else { Label1.Text = "found"; } }
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 Button1_Click(object sender, EventArgs e) { int m = int.Parse(TextBox1.Text); EMSEntities dbcontext = new EMSEntities(); var stud = from dd in dbcontext.StudentDetails where dd.marks > m && dd.section == "A" select dd; //string s = "Output"; DataTable dt = new DataTable(); dt.Columns.Add("id"); dt.Columns.Add("name"); dt.Columns.Add("address"); dt.Columns.Add("section"); dt.Columns.Add("marks"); foreach (var student in stud) { DataRow r = dt.NewRow(); r[0] = student.id; r[1] = student.name; r[2] = student.address; r[3] = student.section; r[4] = student.marks; //r[0] = "id"; //r[1] = "name"; //r[2] = "address"; //r[3] = "section"; //r[4] = 4; dt.Rows.Add(r); //s = s + "ID:" + student.id; //s = s + "name:" + student.name; //s = s + "Section::" + student.section; } GridView1.DataSource = dt; GridView1.DataBind(); //Label1.Text = s; }
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"; }