September 2009 - Posts

Easier Sync
26 September 09 03:09 PM

If you’ve been using Data Source Configuration Wizard since Visual Studio 2005, you’ll notice that with Visual Studio 2008 Service Pack 1 , there’s a “small” change – on Choose Your Database Objects page, a new checkbox would allow you to “enable local Read More...

Postedby Yang Cao | 0 Comments    

Filed under: VS2008, Data Source Wizard, Occasionally Connected System

Refresh the Primary Key Identity Column during Insert Operation
14 September 09 10:17 PM

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 Read More...

Postedby John Chen | 6 Comments    

Filed under: Typed Dataset, SQL Server, Data Binding, SQL Server Compact

Writing Event Handler for controls in a DataRepeaterItem
08 September 09 03:54 PM

In the MSDN Visual Basic Power Packs forum , I had an embarrassing reply on a DataRepeater event handling question, in which the user asked why his event handling code did not work. Here is the original question: “I want to be able to resize a textbox Read More...

Postedby John Chen | 0 Comments    

Filed under: VS2008, VS2010, WinForm, VB Power Packs

How to Workaround Sorting Errors when Updating Self-Referencing DataSet Tables with Visual Studio 2008 SP1
05 September 09 05:14 AM

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 Read More...

Postedby Gavin Fu | 1 Comments    

Filed under: Typed Dataset, VS2008, SQL Server, WinForm