Click here to Skip to main content
11,921,316 members (60,712 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# DataGrid

I am working on datagrid which contains two columns with 25 rows, I need to arrange the data in the order as
1.First ten rows shown in the col1,col2
2.Next ten rows in new columns(like columns in rdlc reports)

Kindly can anyone guide me to achieve this...
Posted 19-Sep-11 21:58pm
Ajit Hegde 20-Sep-11 3:04am
What you mean is 1st 10 rows contains data in col1 and in col2 it is empty and for next 10 rows col1 is empty and col2 contains data. is that right?
sathya4260 20-Sep-11 7:03am
Ex: Mark1,Mark2 are columns and rows are students mark, if there are 25 students, first ten students mark1,mark2 are displayed in col1,col2 and
for next ten students mark1,mark2 two new columns are added as col3,col4 this goes on,, till how many students are there...

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

I think you could do it with LINQ like this:

StudentsDataContext db=new StudentsDataContex();
var tblStudents= (from row in db.tStudents).OrderBy(p=>p.col1).ThenBy(p=>p.col2);


Wish this helps you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 583
1 Dave Kreskowiak 245
2 phil.o 160
3 KrunalRohit 134
4 F-ES Sitecore 130
0 OriginalGriff 6,951
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,171
3 George Jonsson 2,840
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web02 | 2.8.151120.1 | Last Updated 27 Sep 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100