Visual Studio Data

Building business applications with Visual Studio

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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() &...
Page 1 of 1 (6 items)