query in sql server 2005 and c#

See more:

C#

SQL-Server

C#4.0

Hello everybody!
I have a problem and need your help. I want to display all the mark of student on the DatagridView, so below is my problem. Could anyone help me please. I'll appreciate your help.

create table STUDENT
(
   idstudent  char(10)primary key,
   .....info about student
)
//insert some data into table student
insert into STUDENT values('123456789',...)

create table SUBJECT
(
    idsubject  char(10),
    namesubject  char(10)
)
//i have two subject in this table such as ('111', 'Math') and ('112', 'Physics')

create table MARK
(
   idstudent  char(10) foreign key references STUDENT(idstudent),
   idsubject   char(10) foreign key references SUBJECT(idsubject),
   score   int
)
//i have two record like this ('123456789', '111', 9) and ('123456789', '112', 10)

So now i want to create a query to display all the mark of one student on a row like this:

idstudent    idsubject1(Math)  idsubject2(Physics)
123456789       9                      10