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 Steve

2

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…

3

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…

1

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…

14

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 few people ask how to get the Northwind sample database loaded into Sql Express so here are some step-by-step directions for getting Northwind up…


Returning the identity column value from a TableAdapter DBDirect method

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. However, the default INSERT function doesn’t return the primary…

4

Why is my column named _Region in the Typed DataSet?

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 compatability.In previous versions of Visual Studio, we did the same thing. Why…

2

Case sensitive or not sensitive

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 the naming conventions in many databases, including the default behavior…

3

Performance tip for databound UI

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 record was added. To improve performance, you can suspend the binding events while…

5

PDC05 – Windows Forms: Occasionally Connected Smart Clients

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 can be done today with Visual Studio 2005 (Whidbey). Code Samples for August CTP of Visual Studio…

6