How to present data to user in HTML table.
-
I have SerialNumber(SN) ,city ,Country,version ,Region,,,etc in parent table For each SN in connectrix table there are multiple switch in switch_header table. the details of switches are stored in switch_details table. For each switch we have different Frus that is stored in Fru table that has information about fru details I need to display Connectrix information along with their switches and fru information as per search criteria. When I Joined above 4 tables I am getting all the parent column as repetation which I don't want to happen. But some how user should understand the situation such that records should return single SNO, and multiple switchsns ,multiple frus I tried to populate data in heiarchial HTML table mannar using DataSet But Gave up. Is there any methodology from back end? Any ideas on this? Thanks in advance.
"Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
-
I have SerialNumber(SN) ,city ,Country,version ,Region,,,etc in parent table For each SN in connectrix table there are multiple switch in switch_header table. the details of switches are stored in switch_details table. For each switch we have different Frus that is stored in Fru table that has information about fru details I need to display Connectrix information along with their switches and fru information as per search criteria. When I Joined above 4 tables I am getting all the parent column as repetation which I don't want to happen. But some how user should understand the situation such that records should return single SNO, and multiple switchsns ,multiple frus I tried to populate data in heiarchial HTML table mannar using DataSet But Gave up. Is there any methodology from back end? Any ideas on this? Thanks in advance.
"Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
This sounds to be more of a question for .NET group or something. One option in SQL Server would be to output more than one recordset from a procudure or something, but you are still dealing with a display issue which has everything to do with the application and nothing to do with SQL Server. Since it is in the ADO group. Look into Nested Repeaters and you should find your answer there.