convert column into row in mvc4 razor webgrid

vidhya

13y3.4k.NET

i need output like this

students totalpoints newassignemnt testing assignment

raj kumar 30/55 10/20 10/15 10/20

but it displays like this

students totalpoints newassignemnt students totalpoints    testing students totalpoints    assignment

raj kumar 30/55 10/20   raj kumar 30/55   10/15   raj kumar 30/55   10/20
raj kumar 30/55 10/20   raj kumar 30/55   10/15   raj kumar 30/55   10/20
raj kumar 30/55 10/20   raj kumar 30/55   10/15   raj kumar 30/55   10/20

3 assignments there so it displays 3 rows. but i need to display in a single row.

List cols = new List();

foreach (GradeBook.StudentGradeBook x in Model.Student)

{

cols.Add(grid.Column(format:@@item.FirstName @item.lastName, header: "student"));

cols.Add(grid.Column(format:@@totptsawd/@totptspbl, header: "Total Points"));

cols.Add(grid.Column(format:@@item.PointsAwarded/@item.PointsPossible, header: x.AssignmentName));

}

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
you will not get, since you have used string sql. That way you need to assume the output column column and create a new datamodel class

Regards,
Iftikar
+1
vidhya13y ago
I am getting Selected stored procudure returns no information when i click GET COLUMN INFORMATION" while i import a function
+1
Iftikar Hussain13y ago
refer this article. still i have the question, is the assignment number is fixed?

http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

Regards,
Iftikar
+1
Jignesh Trivedi13y ago
hi,
If you use Entity framework than please refer my article
http://www.c-sharpcorner.com/UploadFile/ff2f08/call-store-procedure-from-entity-framework/
+1
vidhya13y ago
i did not know howto call sp thru linq
+1
Iftikar Hussain13y ago
create this query as a SP and call the same from your code. Is the number of assignment is fixed?

Regards,
Iftikar
+1
vidhya13y ago
DECLARE @AssignmentList varchar(3000),@Sql varchar(max)
SET @AssignmentList =STUFF((SELECT DISTINCT ',[' + assignmentname + ']' FROM assignment where coursesectionid='b78a6efe-ac77-4e49-806a-fc2fad71068b' FOR XML PATH('')),1,1,'')

SET @Sql ='select *
from
(
select p.firstname,p.lastname,a.assignmentname,a.pointspossible
from person2 p
inner join coursesectionroster cs
on cs.personid = p.personid
inner join assignment a
on a.coursesectionid = cs.coursesectionid
left join assignmentsubmission asg
on a.assignmentid=asg.assignmentid
where cs.coursesectionid=''b78a6efe-ac77-4e49-806a-fc2fad71068b''
and cs.courserole=2
)t
PIVOT(SUM(pointspossible) FOR assignmentname IN(' + @AssignmentList + '))p'

EXEC (@SQL)
+1
Iftikar Hussain13y ago
can you share your sql query? I suggest you better create SP and call that sp using linq

Regards,
Iftikar
+1
vidhya13y ago
i create sql query for converting columns into rows. but i did not know how to convert the sql into linq.
+1
Iftikar Hussain13y ago
Hi,
Before doing this in WebGrid, can you share me your table design? How you are storing the Student Mark info? I think you need to convert rows to column in your sql query. I believe you have fixed number of assignment.

Regards,
Iftikar
+1