Merge rows and separate them with punctuator in gridview using coding

Question

1.00/5 (1 vote)

See more:

Hi,

I'm creating a grid view, the output I'm getting is like this:

<img src="http://i869.photobucket.com/albums/ab252/write2varun/gridview_zpsc34ad4d5.png" border="0" alt="grid view photo gridview_zpsc34ad4d5.png"/>

But I want the output as distinct GroupName and the Name should be separated by comma (,)
Eg:

<img src="http://i869.photobucket.com/albums/ab252/write2varun/gridview2_zps739c97d6.png" border="0" alt="grid 2 photo gridview2_zps739c97d6.png"/>

wanna wanna do it via. code side of the page

Thank You

p.s. i cannot change the query string

Posted 10-Sep-13 7:06am

write2varun

Updated 10-Sep-13 7:46am

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 10-Sep-13 13:12pm

Looks pretty trivial. http://whathaveyoutried.com so far? what's the problem?
—SA

write2varun 10-Sep-13 13:18pm

I know what to do but I don't know how to do

Sergey Alexandrovich Kryukov 10-Sep-13 13:22pm

Do what? Generate HTML code with a table and cells in ASP.NET? Or get the data from database?
—SA

write2varun 10-Sep-13 13:24pm

i wanna get data from database into the gridview in that format

Sergey Alexandrovich Kryukov 10-Sep-13 14:21pm

Then what prevents you from doing that? Do you have problems with ADO.NET? HTML? Writing HTML using ASP.NET? Understanding ASP.NET?
—SA

write2varun 11-Sep-13 0:56am

i will try to bind the rows using if and foreach

ZurdoDev 10-Sep-13 13:26pm

Where are you stuck?

write2varun 10-Sep-13 13:28pm

I don't know how to merge the value of rows and separate them with a comma

ZurdoDev 10-Sep-13 13:35pm

https://www.google.com/search?q=sql+concatenante+rows+into+column&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

You want to concatenate your rows into a column.

write2varun 10-Sep-13 13:39pm

yes, please let me try this

write2varun 10-Sep-13 13:41pm

Sorry I can't change anything in the query

ZurdoDev 10-Sep-13 13:52pm

In that case just loop through your records and process it however you need.

write2varun 10-Sep-13 13:57pm

okay, i will try it

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)