Show multiple languages spoken for each person in a GridView 1

[prover]

This may be simple but it escapes me. I have a gridview with the following columns: Name, address and position. I need to add another column listing all langaues spoken for each person (if any).

My question is how to get the gridview to display each person and any language they speak.

Name Address Position Languages
jim brown 1 Test Dr Manager Spanish, French
mary smith 2 test dr clerk Spanish
paul jones 3 test dr clerk

TIA

Never argue with an idiot. He'll just drag you to his level and beat you with experience!

 

[ca8msm]

This should probably be done in the Stored Procedure.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[josie2007]

Otherwise, assuming you have all the information in the database just concatenate the filed like this "spanish'||','||'Germangy'....and create a field Languages

 

[ca8msm]

Otherwise, assuming you have all the information in the database just concatenate the filed like this "spanish'||','||'Germangy'....and create a field Languages

I'm not sure I understand. Do you mean that the user should create an additional field on their database table, loop through each row for that user, concatenate each entry and then poulate this field?


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[prover]

I created a function that returned a (coma delimited) list of languages for each person.

TY All!

Never argue with an idiot. He'll just drag you to his level and beat you with experience!