WPF Data Binding: How to Bind DataSet to WPF Designer

WPF Data Binding: How to Bind DataSet to WPF Designer In our previous posts, we mostly used the Entity Data Model as the ORM (Object-relational mapping) layer for the WPF Data Binding scenarios. Meanwhile, since DataSet is used broadly, we also provide the DataSet as a supported DataSource in the Data Binding stories. Following is…

3

Refresh the Primary Key Identity Column during Insert Operation

If you have an identity primary key column defined in a database table, its value will be automatically set by the database engine when you insert a new row to the table. The identity value is determined by the column’s Identity Seed and Identity Increment properties. While in your client application, you can insert a…

12

How to Workaround Sorting Errors when Updating Self-Referencing DataSet Tables with Visual Studio 2008 SP1

Hierarchical update is an important feature of typed dataset that refers to the process of saving updated data back to a database while maintaining referential integrity rules. This feature is enhanced in Visual Studio 2008 by introducing a TableAdapterManger component to manage all TableApdaters in a typed dataset. When updating related tables, TableAdapterManager uses foreign-key…

2

Multi-Targeting and N-Tier Dataset

Multi-Targeting in Visual Studio What is Multi-Targeting in Visual Studio? The multi-targeting feature of Visual Studio lets you specify the version of the .NET Framework, or its profile, that is required for your application. For example, with Multi-Targeting, you can use the latest Visual Studio to continue to develop your existing projects that were created…

0

Using TableAdapters to Insert Related Data into an MS Access Database

I’ve posted before about how to use TableAdapters to update parent-child (master-detail) relationships against SQL server. It’s pretty straightforward and Visual Studio generates all the code for you to properly insert, update and delete your data. However if you’re using MS Access then there’s one thing that Visual Studio doesn’t do because it’s not supported…


TableAdapter and Multiple Result Sets

Several people asked me whether TableAdapter can be used to retrieve multiple result sets from stored procedures. The quick answer is… No, you can’t do that with TableAdapter.Fill() method that gets generated as a part of Typed Dataset. But there’s a very simple work-around. DataAdapter.Fill() & Multiple Result Sets TableAdapter.Fill() method calls DataAdapter.Fill() to retrieve…

2