RTKHOT
asked on
displaying related data in a datagrid
i have 2 tables called ServiceTypes and Services. ServiceTypes contains ServiceTypeID (numeric value) and ServiceTypeName (Furniture, Electrical, Labor, etc). Services contains various services available, eg Wooden table & chair, 40 watt bulb, etc. The data in the Services table contains the ServiceTypeID as a foreign key.
i have created 2 datasets to populate data from both the tables, and i have set a relationship between them.
i want to display this data in a datagrid control. i need the service type (Furniture) and then a list of all the services within that type (Chair, table, hooks, etc). can you please show me how to do it, or send me the code. thanks
i have created 2 datasets to populate data from both the tables, and i have set a relationship between them.
i want to display this data in a datagrid control. i need the service type (Furniture) and then a list of all the services within that type (Chair, table, hooks, etc). can you please show me how to do it, or send me the code. thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Creating Master-Detail Listings using ASP.NET controls
http://www.dotnetbips.com/displayarticle.aspx?id=184
http://www.dotnetbips.com/displayarticle.aspx?id=184
Creating a Multi-table DataGrid in ASP.NET
http://msdn.microsoft.com/msdnmag/issues/03/08/CuttingEdge/
http://msdn.microsoft.com/msdnmag/issues/03/08/CuttingEdge/
ASKER