protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
RemoteDatabaseDataContext rdc = new RemoteDatabaseDataContext();
e.Result = from p in rdc.rStudent
join br in rdc.rMajorType on p.RMajorType equals br.MajorTypeID
select new
{
p.RStuNo,
p.RName,
p.SchoolYear,
Major = br.MajorTypeName
};
}
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
RemoteDatabaseDataContext rdc = new RemoteDatabaseDataContext();
e.Result = from p in rdc.rCourse
join rcp in rdc.rCoursePlan on p.CourseID equals rcp.CourseID
select new
{
p.CourseID, p.CourseName, p.Credit,
Room = rcp.DetailLocation,
Teacher = rcp.TeacherName,
TimeAndRoom = rcp.TimeAndRoom, ElectiveStartTime = rcp.ElectiveStartTime,
ElectiveEndTime = rcp.ElectiveStartTime, maxNumber = rcp.MaxNumber,
Major = rcp.OptionalProfessional
};
}