NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Hierarchical Relationships Without DataRelation Object in ADO.NET
4321
Hierarchical Relationships Without DataRelation Object in ADO.NET
http://www.eggheadcafe.com/articles/20031014.asp
I initially turned to ADO.NET's DataRelation and DataSet objects so that they could handle the relationship management for me. The DataRelation object's capabilities are dead on for single tables with self-referencing keys or multi-table relationships without self-referencing keys. If your current situation falls into either of these categories, you'll want to use the DataRelation object scenario to recursively build your hierarchical structure rather than the solution described in this article. In fact, most tutorials you'll find in books or on the web deal with either of these two situations. However, I have found that the DataRelation object is a little flaky when it comes to combinations of self-referencing tables and multi-table nested relationships, particularly with those that run more than 2 levels deep or have their root level row with the same PrimaryKey as its ForeignKey ParentID. Of course, if you are using foreign key constraints, you can't just set the ParentID to 0.
ASP.NET > Tips and Tutorials
Oct 10, 2006
Robbe D. Morris
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Hierarchical Relationships Without DataRelation Object in ADO.NET: |
|||
Other links at ASP.NET > Tips and Tutorials
REST is short for Representational State Transfer. I'd place that into the category of names that makes more sense once you understand what REST is, but isn't quite so helpful in terms of explaining it. REST is often heard in the context of web services. When it was suggested as a topic for me to write about it was described to me as a web service but doing "the query string thing" to pass it parameters. That's not really what it's about, though.
Category:
Improving Development productivity by reducing the lines of code to be written by 70%. Most of the frequently required code is now available out of the box
Category:
In other applications, you don't care about exact results, but you are interested in having an answer that is correct to a certain number of significant digits. This is the case in experimental physics, for example. When you make a measurement of something, you can only measure it as accurately as your equipment will allow you. Therefore, you have an inherent error in that value already, which is going to cascade through any calculations you do with it. This means that while your computed answer may be 5.1826, you may know that the values this answer was calculated from were only accurate to three significant digits, and so the last two digits in this result (the 0.0026) don't matter. If there is a computational error in them, so be it - it's not going to hurt us.
Category:
In this tutorial you will having a deeper look at the Code Directory, the Code Beside Model and the evolution of the Code Behind model, learn about Partial Classes, Sharing Source components, Creating a Component, you will learn how to create a Application_Code folder, to create a component in the Application_Code folder and use a component.
Category:
Datasets store a copy of data from the database tables. However, Datasets can not directly retrieve data from Databases. DataAdapters are used to link Databases with DataSets. If we see diagrammatically
Category:
Main Category
185
2034
801
286
174
1803
1129
909
1161
7393
70
905
59
2200
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19263
Categories: 1275
Registered Users: 734
Mailing List Subscribers: 2043
Unique Outgoing Hits: 228320
Pagerank Statistics
PHP News