Geek asks and answers

Retrieving data from a database from different tables

I create this mobile portal / application using (ASP + WML), I needed to create a list of courses made by a student in a certain semester during a certain year.

I have the following tables:

enter image description here

I have the following options on the previous page:

string StudentId = Request.Params["StudentId"];
string Year = Request.Params["Year"];
string Semester = Request.Params["Semester"];
  • values ​​( Year) are either "2011" or "2012".
  • values ​​( Semester) are either "first" or "second" or "summer".
  • values ​​( StudentId) is the number previously extracted from id in the Students table.

As a sample of data inside tables.

enter image description here

I'm stuck here

string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\Uni.MDF;" +
            "Integrated Security=True;User Instance=True";
           string queryString =" ??????????????????????????? " ;

, ( ). URL , .

- :

First Semester  2010
Student : Arin Rizk

Course Name     No. of Credit      Mark
    AAA                3            65
    BBB                3            23
    CCC                3            65
    DDD                3            58
    EEE                3            70

Your GPA for this semster is 3.12

Edit

?

? , , .

.

.

+3
2
select st.firstname + ' ' + st.lastname,se.year, c.coursename,c.credits,ri.mark 
from students st 
inner join RegisteredIn ri on ri.studentid=st.id
inner join semester se on se.id=ri.semesterid
inner join Courses c on c.id=se.courseid

, , courseame, .

gpa - , .

+3

:

Select Courses.CourseName, Courses.NumberOfCredits, RegisteredIn.Mark
From dbo.Courses Inner Join dbo.RegisteredIn On Courses.id = RegisteredIn.CourseID
    Inner Join dbo.Semester On RegisteredIn.SemesterID = Semester.id
Where RegisteredIn.StudentID = '20111' AND
    Semester.Title = 'First' AND 
    Semester.Year = 2011
Order By Courses.CourseName
0

More articles:


All Articles