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);
