private void Update_Click(object sender, RoutedEventArgs e) { Students_Tbl a1 = (Students_Tbl)CB.SelectedItem; Students_Tbl a2 = (from s in db.Students_Tbl where s.StudentId == a1.StudentId select s).FirstOrDefault(); a2.StudentName = StuN.Text; a2.StudentMail = StuM.Text; a2.StudentAddress = StuAdd.Text; a2.StudentAge = StuAge.Text; a2.StudentPhone = StuP.Text; db.SaveChanges(); updateCB(); UpdateDGV(); }
private void Add_Click(object sender, RoutedEventArgs e) { String Name = StuN.Text; String Email = StuM.Text; String Phone = StuP.Text; String Age = StuAge.Text; String Address = StuAdd.Text; /*בודק שהוכנסו כל הנתונים שהם חובה * EmpN name of textBox*/ if (StuN.Text == "" || StuAge.Text == "" || StuP.Text == "" || StuAdd.Text == "") { this.Title = "Erorr"; return; } /* שומר את הנתונים שהוקלדו והוכנסו אל המשתנים המתאימים בטבלה * EmpName השם של העמודה בטבלה*/ Students_Tbl a1 = new Students_Tbl(); a1.StudentName = Name; a1.StudentMail = Email; a1.StudentPhone = Phone; a1.StudentAge = Age; a1.StudentAddress = Address; db.Students_Tbl.Add(a1); db.SaveChanges(); this.Title = "Employe Add"; StuN.Text = ""; StuM.Text = ""; StuP.Text = ""; StuAdd.Text = ""; StuAge.Text = ""; this.Title = "sucsses"; UpdateDGV(); updateCB(); }
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { Students_Tbl a1 = (Students_Tbl)CB.SelectedItem; if (a1 == null) { StuN.Text = ""; StuM.Text = ""; StuP.Text = ""; StuAdd.Text = ""; StuAge.Text = ""; return; } StuN.Text = a1.StudentName; StuM.Text = a1.StudentMail; StuP.Text = a1.StudentPhone; StuAdd.Text = a1.StudentAddress; StuAge.Text = a1.StudentAge; }