Pleas Urgent help in DataGrid problem

G

gops

This is my sql query

"SELECT UC_Course_Unit.Unit_ID, Unit.Unit_Name,
UC_Course_Unit.Semester_Offered, UC_Course_Unit.Year_Offered FROM Unit
INNER JOIN UC_Course_Unit ON Unit.Unit_ID = UC_Course_Unit.Unit_ID
WHERE (((UC_Course_Unit.Unit_ID) Not In (SELECT OS_Course_Unit.Unit_ID
FROM OS_Course_Unit WHERE (((OS_Course_Unit.OS_course_ID)="+
OscourseID +")))) AND ((UC_Course_Unit.Course_ID)='"+ UCCouseID
+"'))ORDER BY UC_Course_Unit.Year_Offered",cts);

I want to format the data grid something looks like this

Semester 1 Semester2
Year 1

Subject 1 Subject 1
Subject 2 Subject 2
Subject 3 Subject 3
Subject 4 Subject 4

Year 2
Subject 1 Subject 1
Subject 2 Subject 2
Subject 3 Subject 3
Subject 4 Subject 4

Please help me to solve this problem Thanks in advanced.show me some
codding

gop
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top