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 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)…


SQL Server Everywhere – SQL Mobile Unleashed

Today Paul Flessner announced that SQL Mobile will be released as SQL Server Everywhere Edition. 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

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


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


VSLive San Francisco Presentations

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…


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 Forms applications.  There are a couple of quirks when it comes to Click Once that have been included in this MSDN article. Steve


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 (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…


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


Data Sources window is inactive in Design View

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…