Resource Page DescriptionWhen creating a typed-dataset in a project with Hierarchical Update enabled, TableAdapterManager is automatically generated to help updating related tabes in dataset. However, when updating self-referencing tables, TableAdapterManager has some errors in determining the correct order of affected rows, which could cause FK constraint violation errors when committing the changes to database. This project shows how to workaround this sorting error when updating self-referencing dataset tables.
For a complete introduction to this problem and its solution, see How to Workaround Sorting Errors when Updating Self-Referencing DataSet Tables in Visual Studio 2008 This sample uses the Northwind sample databas. You can find here Additional information on starting a new resource page is available here: Resource Page Startup Guide.
|