How can I load some data to GridView.

See more:

SQL-Server-2005

C#3.0

VS2008

C#

, +

Here is the thing.I have created two tables called "User" and "Phone".In User table there are two columns "id" and "name".since one user has more than one phone number I've created another table called "Phone" as mentioned above. so phone table contains all the telephone numbers of each user.

User table
id-------name
100-----jack
200-----john


phone table
id-------phone
100-----12345
100-----23456
200-----34567
200-----45678

So now i want to load those two tables to a single grid view as below (Visual studio 2008,C#)

name-----phone
jack-------12345,23456
john-------34567,45678

I wrote a query as

SELECT U.name,P.phone
FROM tUser U,tPhone P 
WHERE U.id = P.id

But I'm getting the output as below

name-----phone
jack-------12345
jack-------23456
john-------34567
john-------45678

What should I do now? Is it not possible or is there any other way to get the correct output? I'm Waiting for a possitive reply.thanks..