private void ackbtn_Click(object sender, EventArgs e) { //添加班级,更新各种信息到数据库 #region var query = from teachername in db.teacher where teachername.Teacher_name == techernamebox.Text select teachername.Teacher_id; try { query.First(); } catch { MessageBox.Show("没有该老师!"); return; } @class a = new @class(); a.Class_id = gradebox.Text + classbox.Text; a.Class_name = classnamebox.Text; a.Class_college = classcollege.Text; a.Class_teacherid = query.First(); [email protected](a); try { db.SubmitChanges(); MessageBox.Show("添加成功!"); } catch { MessageBox.Show("添加失败!"); } #endregion // #region var again = (from temp in db.@class select new { 班级编号 = temp.Class_id, 班级名称 = temp.Class_name, 所属学院 = temp.Class_college, 辅导员编号 = temp.Class_teacherid }).ToList(); dataGridView1.DataSource = again; #endregion }
private void ackbtn_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); var query = from teachername in db.teacher where teachername.Teacher_name == techernamebox.Text select teachername.Teacher_id; try { query.First(); } catch { MessageBox.Show("没有该老师!"); return; } @class a = new @class(); a.Class_id = gradebox.Text + classbox.Text; a.Class_name = classnamebox.Text; a.Class_college = classcollege.Text; a.Class_teacherid = query.First(); [email protected](a); try { db.SubmitChanges(); MessageBox.Show("添加成功!"); } catch { MessageBox.Show("添加失败!"); } }
partial void Deleteclass(@class instance);
partial void Updateclass(@class instance);
partial void Insertclass(@class instance);