repeater with dynamic column

Question

4.00/5 (1 vote)

See more:

Hi
How can I make dynamic multiple columns in repeater in asp.net c#.

please see below structure just for reference.

VB

|  year  |  year  |  year  |  year
name | amount | amount | amount | amount
name | amount | amount | amount | amount
name | amount | amount | amount | amount
name | amount | amount | amount | amount

in my case I might have 2 or 3 or 4 or any no. of products to be compared so I need to display multiple products with multiple features to be compared.

ref. site: http://www.biocompare.com/ProductCompare.aspx?i=2936820,79743,438523,0000[^]

thanks in advance.

Posted 3-Apr-11 21:19pm

trilokharry

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

walterhevedeich · Answer 1 · 2011-04-04T19:02:00

Solution 1

Have you taken a look at this?

ASP.Net Repeater dynamically using C# code[^]

[UPDATE]

You can actually pivot the datatable before binding it to the repeater.
Pivoting a DataTable[^]

After you made your pivot on the datatable, you can now create your repeater in your code behind. Refer to the first URL on how to do it.

Posted 4-Apr-11 19:02pm

walterhevedeich

Updated 7-Apr-11 21:04pm

v2

Comments

trilokharry 5-Apr-11 1:20am

Hinot able to get sample in reference site what you have given me for dynamic columns.
my scenario is:
table can have 2 or 3 or 4 or 5 rows of products.
if no. of rows are 2 means columns will be 2.
if no. of rows are 3 means columns will be 3.

columns in table will be used to display features of product for comparison.

thanks for your kind response.

walterhevedeich 8-Apr-11 2:33am

But thats exactly how you do it. If you are building a repeater with dynamic columns, you should do it in the code behind. As you can see the URL I provided, there are code snippets which demonstrates you how to do it.

trilokharry 8-Apr-11 2:10am

thanks for kind response.

my scenario is:

suppose I have 4 records of products in DataTable.

4 rows in DataTable with p1, p2, p3, p4 with respective product features.

if 4 rows means I want to make 4 columns or if it is 2 row means 2 columns.

Particular Product features will be used to be compared.

How can I achieve same by repeater control in asp.net c#.

thanks

walterhevedeich 8-Apr-11 2:33am

in your scenario, how many columns do you have in your DataTable?

trilokharry 8-Apr-11 2:48am

in my scenario columns might be any no. of and will be treated as a feature in DataTable.
but columns in a repeater will be based on no. of rows in DataTable.

like:
result of this query:
select *from product where ProductId in(2,3,6,7);
4 products will be in result and will be compared.
min prod compare 2 and max will be 5 so max repeater column will be 5 and so max no. of rows also will be 5.

thanks

trilokharry 8-Apr-11 2:54am

might be display result in repeater as mention below.
p1 p2
quality feature1 feature2
Price $2000 $4000
Catalog Number AR001 344289-1SET

so does it make sense.
thanks

walterhevedeich 8-Apr-11 3:00am

Now I get it. What database are you using as your backend? For these kinds of scenarios, a pivot might be needed. Since MS SQL 2005, there's already a PIVOT command that you can use to accomplish your goal. Im not sure if they have PIVOT on other database.

trilokharry 8-Apr-11 3:31am

database might be MS SQL 2005 or 2008.

walterhevedeich 8-Apr-11 3:04am

I have updated my answer above. Please see the updates and let me know if it works for you.

trilokharry 8-Apr-11 3:17am

sure
thanks a lot.