Skip to Main Content
Professional Visual Studio® 2008
book

Professional Visual Studio® 2008

by Nick Randolph, David Gardner
July 2008
Intermediate to advanced content levelIntermediate to advanced
1026 pages
27h 59m
English
Wrox
Content preview from Professional Visual Studio® 2008

34.6. The Data Source

Visual Studio 2008 includes designer support for building mobile data-bound applications that is similar to what it provides for full framework applications. This includes support for building mobile applications where it is useful to have a portable database that resides on the device. As with other project types, to add a data source to your application, select Add New Data Source from the Data Sources window. Select Database as the data source type and you will be prompted to select the database connection to use.

Mobile applications can connect directly to a SQL Server database using the same classes as desktop or web applications. However, this can limit the mobility of such a device, as it will require connectivity to the database to function. A better solution is to change the data source to be a SQL Server Compact Edition (SSCE) database. By default, the Add Connection dialog shows connection properties for a SQL Server connection. Selecting Change, next to the Data Source label, enables you to change the data source to be SQL Server Compact 3.5, as shown in Figure 34-10.

Figure 34.10. Figure 34-10

Accepting this change prompts you to select the parameters for the SSCE database to connect to. Here you can select either an existing database, as shown in Figure 34-11 (where the Northwind database that ships with Visual Studio 2008 has been selected), ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional Visual Studio® 2010

Professional Visual Studio® 2010

Nick Randolph, David Gardner, Michael Minutillo, Chris Anderson

Publisher Resources

ISBN: 9780470229880Purchase book