Link to home
Start Free TrialLog in
Avatar of RTKHOT
RTKHOTFlag for India

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
Avatar of RTKHOT
RTKHOT
Flag of India image

ASKER

what i mean is that in the datagrid, i need to show ServiceType, followed by the services within that type.
ASKER CERTIFIED SOLUTION
Avatar of sachiek
sachiek
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Creating Master-Detail Listings using ASP.NET controls
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/