Welcome to MSDN Blogs Sign in | Join | Help

November 2005 - Posts

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. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp

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,

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
Posted by SmartClientData | 1 Comments
Filed under:

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
Posted by SmartClientData | 14 Comments
Filed under:

Installing Northwind on SqlExpress

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
 
Page view tracker