[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

displaying related data in a datagrid

Posted on 2005-05-09
4
Medium Priority
?
203 Views
Last Modified: 2010-04-07
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
0
Comment
Question by:RTKHOT
  • 3
4 Comments
 

Author Comment

by:RTKHOT
ID: 13957511
what i mean is that in the datagrid, i need to show ServiceType, followed by the services within that type.
0
 
LVL 11

Accepted Solution

by:
sachiek earned 500 total points
ID: 13957853
There are soo many examples.

Look at this below examples.
http://www.denisbauer.com/ASPNETControls/HierarGrid.aspx
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13957854
Creating Master-Detail Listings using ASP.NET controls
http://www.dotnetbips.com/displayarticle.aspx?id=184
0
 
LVL 11

Expert Comment

by:sachiek
ID: 13957855
Creating a Multi-table DataGrid in ASP.NET
http://msdn.microsoft.com/msdnmag/issues/03/08/CuttingEdge/
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month20 days, 7 hours left to enroll

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question