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 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. We didn’t think we could get this done, but after reading…

4

Customizing the connection string for TableAdapters

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: Strongly typed settings file.  Rather then having to write AppSettinsReader.GetValue(“NameOfConfigItem”) as Object you can simply write:conn.ConnectionString = My.Settings.NorthwindConnectionString  The new settings file is…


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 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 create the right grid (the grid without columns). This is…


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 Everywhere Edition.  http://www.microsoft.com/sql/letter.mspx This will be the first of a several part series of blogicles that cover some of the thinking we’re doing around the Occasionally Connected scenarios, and what you can do today with Visual Studio 2005.   …ok,…