8,497
社区成员
发帖
与我相关
我的任务
分享
var query = from obj in dataTable.AsEnumerable()
select obj;
var query = from obj in dataTable.AsEnumerable()
select obj;
foreach (var item in query)
{
var obj = db.classes.SingleOrDefault(o=>o.class1 == item.Field<string>("班级"));
if (obj == null)
{
obj = new @class();
obj.class1 = item.Field<string>("班级");
obj.specialty = item.Field<string>("专业");
obj.counsellor = item.Field<string>("班主任");
obj.enroll = (int)item.Field<double>("入学年份");
db.classes.InsertOnSubmit(obj);
}
else
{
obj.specialty = item.Field<string>("专业");
obj.counsellor = item.Field<string>("班主任");
obj.enroll = (int)item.Field<double>("入学年份");
}
}
db.submitchangs();