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

Author: youngjoo Date: 08/09/2006

Q&A About SQL Server Everywhere

Steve posted some answers to many of the questions about SQL Server Everywhere......

Author: SmartClientData 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....

Author: Steve Lasker 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...

Author: Steve Lasker 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...

Author: SmartClientData Date: 02/13/2006

VSLive San Francisco Presentations

At VSLive I presented two sessions. One for Occasionally Connected Smart Clients and another on...

Author: SmartClientData Date: 02/01/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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData Date: 08/26/2005

Drag Once w/Custom Controls

Article written for CoDe magazine describing how to customize the controls listed in the Data...

Author: SmartClientData Date: 08/24/2005

Drag Once Databinding

Article written for CoDe magazine relating to the Drag Once Databinding features in Smart Client...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData Date: 08/13/2005

In 2005 we now have a new DataSet Designer. While we had planned to implement Zoom functionality it...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData Date: 07/14/2005

The little database that could. Deploying SQL Mobile as a local / single user database across Microsoft Mobile devices

UPDATE - April 6th 2006, Paul Flessner announced that SQL Mobile will released as SQL Server...

Author: SmartClientData Date: 07/14/2005

TableAdapter Conflict Options

Developers often ask about better concurrency options on DataAdapters and of course our new...

Author: SmartClientData Date: 06/23/2005

DataSet Designer, Schema Designer and Xml Editor

DataSet Designer, Xml Schema Designer and Xml Editor (Note, DataSet Designer is also called DataSet...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData 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...

Author: SmartClientData Date: 06/13/2005