i am using VS 2008 (asp.net with c#) and SQL Server 2005....
subject table:
create table subject
(subid varchar(10),
subname varchar(20))
subid subname
1 subject1
2 subject2
3 subject3
=> it includes all the subjects in each row...for eg
result table: it includes all subject marks ( when i'm trying to create result it repeating each row with subid,subname)
studentid subid subname marks
1 1 subject1 12
1 2 subject2 23
1 3 subject3 22
1 4 subject4 20
here, it displays subjects and marks in row wise...
so i want something like this....
studentid subject1 subject2 subject3 subject4
1 12 23 22 20
2
3
so i want to display each subjects with its marks in column wise.....
NOTE:
Subjects are not fixed for each semester (in subject table) thats why i want to create/edit/delete table dynamically within asp.net web form....