Smart Client Data

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

Steve posted some answers to many of the questions about SQL Server Everywhere... http://blogs.msdn.com/stevelasker/

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

Article explaining how to separate TableAdapters from Typed DataSets to leverage common validation routines between the client and reinforced by the server. ...

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

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

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

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

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

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

When performing a default install of Visual Studio 2005 an instance of Sql Server Express edition is installed. Unfortunately there are no sample databases included with Sql Express. ( http://lab.msdn.microsoft.com/express/sql/ ) I've had more than...

A common scenario when using tables with an auto-increment primary key is to get the value of the identity column for the row you just inserted. Sometimes you can't, or don't want to, use DataSets, which is why we created the DBDirect methods on the TableAdapter...

One quirk you'll find when making a typed DataSet with a column or table named "Region" is that the generated code produces a property called "_Region". What's up with that? If you read Raymond Chen's blog , you already have a pretty good guess: Backward...

In a Dataset, case sensitive seems only apply to the data not to the schema Within a dataset, table and column names are by default case-insensitive — that is, a table in a dataset called "Customers" can also be referred to as "customers." This matches...

When loading large amounts of data into a dataset table with databound UI, things can get pretty slow. One reason is that each time a row is added to the table, the databinding components will perform some work and tell the databound controls that a new...

At PDC I presented a session covering Occasionally Connected Smart Clients that can leverage SQL Server Mobile, RDA, ClickOnce running in the background. The sample contains some early thinking on where we're heading post Whidbey, in addition to what...

Overview In Visual Studio 2005 we added a number of features to help developers build and deploy applications that need a local data store. Here's a quick peek at how it works. In order to work with a local database file, you can simply add the...

Article written for CoDe magazine describing how to customize the controls listed in the Data Sources Window for Drag Once Databinding http://www.code-magazine.com/Article.aspx?quickid=0411071 Steve

Article written for CoDe magazine relating to the Drag Once Databinding features in Smart Client Applicaitons www.Code-Magazine.com/Article.aspx?quickid=0409051 Steve

Tuning your SQL queries for the best performance can be part of life when you’re writing a database application. Sometimes life is hard, and you just can’t get things running as quickly as you’d like. With the default command time-out at 30 seconds, how...

In Whidbey DataSet designer, you are able to set Typed DataColumn's NullValue property to the following values if the DataType is string 1 (Empty) 2 (Nothing) (null for C#) 3 (Throw exception) 4 any string you can type in. The first...

In 2005 we now have a new DataSet Designer. While we had planned to implement Zoom functionality it turned out to be more difficult then we had hoped. Long term we plan to leverage the new design framework that’s used by the Class designer. However, this...

I’m happy to report that we were able to get TimeStamp comparison added. The issue we faced was by the time the DBCommandBuilder API stabilized we were in what we call UI freeze which means we couldn’t change UI elements without some major negotiating...

Visual Studio 2005 now leverages the strongly typed settings file which wraps app.config. With connection strings stored in app.config/Settings, developers can centralize their connection strings across their application. Some advantages over VS2003 are...

DataBinding does not work well with DataTable name with a "." The Dot in a DataTable name or a DataColumn name will not make the DataBinding happy. For example, if you drag drop a table from the DataSource window to a Windows Form, it would not...