Smart Client Data
This blog describes some of the Data features specific to Smart Clients. This includes Windows Forms, Devices and Visual Studio Tools for Office. The Smart Client Data team, AKA VB Data, is responsible for features such as the Data Sources Window, Typed
How to retrieve stored procedure return values from TableAdapter
If you’ve been wondering why you are not able to access stored procedure return values from...
Date: 08/09/2006
Q&A About SQL Server Everywhere
Steve posted some answers to many of the questions about SQL Server Everywhere......
Date: 04/09/2006
SQL Server Everywhere - SQL Mobile Unleashed
Today Paul Flessner announced that SQL Mobile will be released as SQL Server Everywhere Edition....
Date: 04/06/2006
Splitting Typed DataSets from TableAdapters - Sharing Validation Code across the tiers
You’re building a Smart Client application. You want this Smart Client to be smart enough to provide...
Date: 02/21/2006
Relation Dialog: Relation Only, or with Foreign Key Constraint?
Using the Relation Dialog, you are asked to choose Relation Only, Foreign Key Constraint Only, or...
Date: 02/13/2006
Embedding SQL Server Express into Custom Applications
Rob Walters, from the SQL Team, and I worked on an article for working with SQL Express in Windows...
Date: 11/23/2005
Building SQL manually considered harmful
I just got done fixing a painful bug. The long and short of it is that I had code like this...
Date: 11/22/2005
How do I get to the generated code?
In order to get to the code that is auto-generated by Visual Studio, follow these steps: 1. In the...
Date: 11/18/2005
Data Sources window is inactive in Design View
On certain machines, after installing Visual Studio 2005, the contents of the Data Sources window...
Date: 11/18/2005
Installing Northwind on SqlExpress
When performing a default install of Visual Studio 2005 an instance of Sql Server Express edition is...
Date: 11/02/2005
Returning the identity column value from a TableAdapter DBDirect method
A common scenario when using tables with an auto-increment primary key is to get the value of the...
Date: 10/31/2005
Why is my column named _Region in the Typed DataSet?
One quirk you'll find when making a typed DataSet with a column or table named "Region" is that the...
Date: 10/14/2005
Case sensitive or not sensitive
In a Dataset, case sensitive seems only apply to the data not to the schema Within a dataset, table...
Date: 10/06/2005
Performance tip for databound UI
When loading large amounts of data into a dataset table with databound UI, things can get pretty...
Date: 09/19/2005
PDC05 - Windows Forms: Occasionally Connected Smart Clients
At PDC I presented a session covering Occasionally Connected Smart Clients that can leverage SQL...
Date: 09/14/2005
Working with local databases
Overview In Visual Studio 2005 we added a number of features to help developers build and deploy...
Date: 08/26/2005
Drag Once w/Custom Controls
Article written for CoDe magazine describing how to customize the controls listed in the Data...
Date: 08/24/2005
Drag Once Databinding
Article written for CoDe magazine relating to the Drag Once Databinding features in Smart Client...
Date: 08/24/2005
Increasing query time-outs with TableAdapters
Tuning your SQL queries for the best performance can be part of life when you’re writing a database...
Date: 08/16/2005
Setting NullValue property for typed dataset
In Whidbey DataSet designer, you are able to set Typed DataColumn's NullValue property to the...
Date: 08/13/2005
Navigating a large DataSet with the Document Outline - Zoom
In 2005 we now have a new DataSet Designer. While we had planned to implement Zoom functionality it...
Date: 08/05/2005
TableAdapters will support TimeStamp Concurrency Checks
I’m happy to report that we were able to get TimeStamp comparison added. The issue we faced was by...
Date: 07/27/2005
Customizing the connection string for TableAdapters
Visual Studio 2005 now leverages the strongly typed settings file which wraps app.config. With...
Date: 07/25/2005
Databinding not happy with the object name containing dots
DataBinding does not work well with DataTable name with a "." The Dot in a DataTable name or a...
Date: 07/14/2005
DataSet Designer, Schema Designer and Xml Editor
DataSet Designer, Xml Schema Designer and Xml Editor (Note, DataSet Designer is also called DataSet...
Date: 06/16/2005
Thank you! Steve!
Thanks Steve to create a new home for us. By the way, I am Zhiyong (aka John Chen), I am the...
Date: 06/15/2005
Tech Ed '05: Client and Middle Tier Data Caching with SQL Server 2005
Last week Pablo Castro and I presented two topics related to caching. Pablo presented caching...
Date: 06/13/2005
Tech Ed ’05: Windows Forms: Making the Most of WinForms 2.0 Data Binding
Last week Andrew Brust and I presented a fun session on the enhancements we’ve done for databinding...
Date: 06/13/2005
A new home
For those that have been following our team under the VB Team blog, you've found our new home. Why...
Date: 06/13/2005