Solved

Gridview display results issue (show multiple record results in a single gridview column)

Posted on 2009-05-12
5
214 Views
Last Modified: 2012-05-11
I really don't know how to ask this question so I will attempt to describe what I am needing to do. Say I have 300 units of Item A that ship in 4 different Boxes and 200 Units of Item B that ship in one box My search results would return 5 rows one for each box. This is how my gridview currently acts

Item Name           Box #
   A                        987
   A                        654
   A                        321
   A                        573
   B                        275

However this is how I would like it to display

Item Name          Box #
      A                   987, 654, 321, 573
      B                    275

is this possible and if so how do I get it to look like this (also each box number would be a link to the shipping information for that box)

0
Comment
Question by:WesleyAlgee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:David Robitaille
ID: 24366564
ther is many way of doig this, as an exemple, you could do this in the SQl query.
here an exemple
http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html
0
 

Author Comment

by:WesleyAlgee
ID: 24367834
maybe I don't understand or maybe I did not make it clear but the information I am getting from the database are in two different tables (don't know if this makes a difference) and would it seems to me that the code you linked to would still give me five records returned instead of only two
0
 
LVL 18

Expert Comment

by:David Robitaille
ID: 24368047
no if you do it correctly, it would return 2 row.
It<s a long time i did not do this. I would suggest that you use the request for attention button to ask a moderator to add the "SQL Syntax" Zone and the database type you use (mysql, ms SQL server, oracle etc.)
0
 

Accepted Solution

by:
WesleyAlgee earned 0 total points
ID: 24560178
Follow this link to see how I found my answer to this question I guess I worded the question better there

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24406293.html
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
mask value when navigating 5 24
junit initializtion error 2 22
Access 2003, find all instances of database ODBC 3 53
Why am I losing my session variable value 11 40
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question