Table bind in gridview

Question

Hi I have a table with some duplicate records id but all columns have diffrent values. I wann to bind this table in gridview. All duplicate same id columns bind in one row of a gridview. Plaese tell me

Nitin Bhardwaj · Answer

Sorry but it's not working

Munesh Sharma · Answer

I dont have any idea about this but you go on this link.. http://www.mssqltips.com/sqlservertip/3148/sql-server-reporting-services-xml-data-source-and-data-set/

Nitin Bhardwaj · Answer

Can we use this query in xml dataset? if yes then how?

Munesh Sharma · Answer

you can use this query for partition respect to ID select ID Row _number() over (PARTITION BY ID order by ID) As ID from tablename