how to formate this datgrid problem

  • Thread starter Thread starter gops
  • Start date Start date
G

gops

i wan't the datagrid display something like this

Semester 1(Semester_Offered) Semester 2(Semester_Offered)

Year1(Credit_Level)
Subjectid name Subjectid name
Subjectid name Subjectid name

Year2
Subjectid name Subjectid name
Subjectid name Subjectid name

Year3
Subjectid name Subjectid name
Subjectid name Subjectid name
---------------------------------------------------------------
this is my query
SELECT ucu.Unit_ID, u.Unit_Name, u.Credit_Points, u.Credit_Level,
cu.Semester_Offered
FROM Unit AS u, UC_Course_Unit AS ucu
WHERE (((ucu.Unit_ID) Not In (SELECT ocu.Unit_ID
FROM UC_Course_Unit ucu,OS_Course_Unit ocu
WHERE( ocu.Unit_ID=ucu.Unit_ID) AND ((ucu.Course_ID)=[?]))) AND
((u.Unit_ID)=[ucu].[Unit_ID]));

-------------------------------------------------------
psudo code

If u.Credit_Level=1 and cu.Semester_Offered=1
datagrid.column[0].cell[0].add that unit

how can i do this in c# for asp.net pages

Please help me give me code

gops
 
psudo cod

If u.Credit_Level=1 and cu.Semester_Offered=
datagrid.column[0].cell[0].add that uni

include the above code in DataGrid_ItemDataBound method

--Kris

----- gops wrote: ----

i wan't the datagrid display something like thi

Semester 1(Semester_Offered) Semester 2(Semester_Offered

Year1(Credit_Level)
Subjectid name Subjectid nam
Subjectid name Subjectid nam

Year
Subjectid name Subjectid nam
Subjectid name Subjectid nam

Year
Subjectid name Subjectid nam
Subjectid name Subjectid nam
--------------------------------------------------------------
this is my quer
SELECT ucu.Unit_ID, u.Unit_Name, u.Credit_Points, u.Credit_Level
cu.Semester_Offere
FROM Unit AS u, UC_Course_Unit AS uc
WHERE (((ucu.Unit_ID) Not In (SELECT ocu.Unit_I
FROM UC_Course_Unit ucu,OS_Course_Unit oc
WHERE( ocu.Unit_ID=ucu.Unit_ID) AND ((ucu.Course_ID)=[?]))) AN
((u.Unit_ID)=[ucu].[Unit_ID]))

------------------------------------------------------
psudo cod

If u.Credit_Level=1 and cu.Semester_Offered=
datagrid.column[0].cell[0].add that uni

how can i do this in c# for asp.net page

Please help me give me cod

gop
 
Back
Top