Bind Multiple value from database in single column

Question

0.00/5 (No votes)

See more:

I want data in gridview like this:

CategoryName Subcategory Name
--------------------------------
Abc Abc1,abc2,abc3
Bcs Bcs1,bcs2
def Null / No Record

How can I do that?

okay i want data from database by using single table. i have one table categories in which i have field like categryid, parentid,name. when parentid is 0 then its known by Categories else all other is subCategories.

I Am using asp.net with c# and i want to do this in gridview with using boundfield. for categories i have done but for sub categories i dont have any idea how to do.

subcategories is idedntify by its parentid. in sub categories parentid =categryid

Posted 28-Jan-13 23:53pm

DimpalPindoriya

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)

Vinodh.B · Answer 1 · 2013-01-29T01:40:00

Solution 1

You have to use the Common Table Expression .
Refer the link for more details .
http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/[^]

Posted 29-Jan-13 1:40am

Vinodh.B

Comments

DimpalPindoriya 29-Jan-13 7:44am

thanks vinodh i can do this also by using inside datalist in item template of gridview but i dnt know hw to pass the gridview item id as a parameter in datalist..
if you have knowledge about it then please help me..

Vinodh.B 29-Jan-13 8:07am

Your above comments are unclear. Could you explain step by step exactly what is your need or how to display the data .

DimpalPindoriya 30-Jan-13 5:58am

its okay now i solved my problem.,

Vinodh.B 30-Jan-13 6:07am

anyways if my solution had helped you you can accept the solution or vote the solution .