Question Distribute Records into Colums

[ranjit_dutt]

friends
i have number of records in one column and i would like to distribute evenly in several (six) columns
assume there are 20 records in one column, and i want to distribute 4 records in first column, 4 records in second column, and 3 records in third, fourth, fifth and sixth column respectively...

details as below:

i am selecting some records from a listbox and copy selected records to new table with six columns (i.e. records in single column to six columns in destination table)

actually what basically i want to do is: i have records with photo locations saved in one field. and i want to print all photos in single page in rdlc report viewer (for that i have to supply a dataset)...

hope i have cleared the question.....

please help......

 

[jmcilhinney]

Create a DataTable, Add the Columns and then Add the Rows, exactly as you'd expect.