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

If you’ve been wondering why you are not able to access stored procedure return values from TableAdapter, here’s the solution for you. I will use tbTasks table and spInsertTask stored procedure to demonstrate the solution. You can see definitions for both below. CREATE TABLE dbo.tbTasks ( intID INT NOT NULL IDENTITY(1,1), strName VARCHAR(100)…

Today Paul Flessner announced that SQL Mobile will be released as SQL Server Everywhere Edition. http://www.microsoft.com/sql/letter.mspx Details are yet to be announced. But to get a feel for what the new product will do, check out this walkthrough: The little database that could. Steve

You’re building a Smart Client application. You want this Smart Client to be smart enough to provide validation feedback to the user as they enter information. However, in order to make the application scale to thousands of users you can’t open connections directly to the database from the client because you’re server can’t handle that…

Using the Relation Dialog, you are asked to choose Relation Only, Foreign Key Constraint Only, or Both. Which is the right choice? “Relation Only” makes available the tables related to the table that you are working with. This means that if you are working with, for example, both a Customers table with CustomerID as primary…

At VSLive I presented two sessions. One for Occasionally Connected Smart Clients and another on Advancements in Data Access. The Occasionally Connected Smart Client session focused on what we’re working on post VS 2005. Some of which should be in Orcas, some of which will follow afterwards. Mostly the session was about providing an overview…

Rob Walters, from the SQL Team, and I worked on an article for working with SQL Express in Windows Forms applications. There are a couple of quirks when it comes to Click Once that have been included in this MSDN article. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp Steve

I just got done fixing a painful bug. The long and short of it is that I had code like this (simplified a lot for brevity): Public Sub StoreSyncDate() Dim sql As String = “insert into SyncTimes (ObjectID, SyncDate) values ({0}, ‘{1}’)” sql = String.Format(sql, Me.ID, DateTime.Now) Me.Executequery(sql) End Sub On my machine, sql gets…

In order to get to the code that is auto-generated by Visual Studio, follow these steps: 1. In the menu, select View -> Solution Explorer 2. In Solution Explorer, click the “Show all Files” icon at the top 3. Expand the file (e.g. Dataset1.xsd) that you want the generated code for 4. Double click on the corresponding Designer file (e.g. Dataset1.Designer.vb) to open…

On certain machines, after installing Visual Studio 2005, the contents of the Data Sources window disappears when a design surface that allows drag and drop from the Data Sources window is active. For example, the Windows Forms designer, User Control Designer, etc… The cause of this issue is how VS processes the list of associated…