private void button1_Click(object sender, EventArgs e)
{
DataClasses1DataContext db = new DataClasses1DataContext();
//添加学生-课程关系
#region
var query = (from students in db.student
where students.Student_classid == classbox.Text
select students.Student_id).ToList();
int right = 0;
int wrong = 0;
int num = 0;
foreach (var a in query)
{
sutdent_course temp = new sutdent_course();
temp.id = a + coursebox.Text;
temp.Course_id = coursebox.Text;
temp.Student_id = a;
db.sutdent_course.InsertOnSubmit(temp);
try { db.SubmitChanges(); right++; }
catch { wrong++; }
}
num = query.Count;
String text = this.classbox.Text + "班共" + Convert.ToString(num) + "人，提交成功：" + Convert.ToString(right) + "条 ,提交失败：" + Convert.ToString(wrong) + "条";
MessageBox.Show(text);
#endregion
}
partial void Deletesutdent_course(sutdent_course instance);
partial void Updatesutdent_course(sutdent_course instance);
partial void Insertsutdent_course(sutdent_course instance);