hello
I have a situation here.I have a datatable coming in with one to many kind of relation.
for example, i have a sequence number from the database which have one or more values
like seq_number attrib value ... other coulumn in the datatable.
now i want to show just one row for each squence number.i am join couple of tables in my query so i can;t do this inside of the query itself.right now i get rows like this
seq_number attrib value seqno1 attr1 val1 seqno2 attr2 val2 i want to show this in one row,and the last column in grid will show the values and attribs for one sequence no.
can any one help,i know i need to do something with my datatable or use DataRowview but i am not able to figure out how to do this exactly.
i can;t use nested datagrids.instead i have a div elemen which pops up
,ie the last column in my gird is a link coulumn which pops up this div tag which has the child data.
Thanks and any help would really great :)
Hi!
Could you please explain it more precisely with examples. I would be able to help you then.
Regards,
From: "h1b" <amitsdeo>
Reply-To: DotNetDevelopment
To: "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" <DotNetDevelopment>
Subject:one to many relations in a datagrid
Date: Fri, 07 Jul 2006 02:54:40 -0000
>
>hello
>
>I have a situation here.I have a datatable coming in with one to many
>kind of relation.
>for example, i have a sequence number from the database which have one
>or more values
>
>like seq_number attrib value ... other coulumn in the datatable.
>
>now i want to show just one row for each squence number.i am join
>couple of tables in my query so i can;t do this inside of the query
>itself.right now i get rows like
this
>
>seq_number attrib value
>seqno1 attr1 val1
>seqno2 attr2 val2 i want to show this in one row,and the last column in
>grid will show the values and attribs for one sequence no.
>
>can any one help,i know i need to do something with my datatable or use
>DataRowview but i am not able to figure out how to do this exactly.
>
>i can;t use nested datagrids.instead i have a div elemen which pops up
>,ie the last column in my gird is a link coulumn which pops up this
>div tag which has the child data.
>
>
>
>Thanks and any help would really great :)
>
>
>