SQL Server 2005 Compact Edition - MS Tutorials (Full Version)

All Forums >> [SQL Server CE] >> SQL Server 2005 Compact Edition



Message

devbuzz -> SQL Server 2005 Compact Edition - MS Tutorials (7/20/2007 7:37:45 AM)

These tutorials are an excellent way to get started with SQL Server 2005 Compact Edition.

SQL Server 2005 Compact Edition How-to Tutorials
http://msdn2.microsoft.com/en-us/sql/bb219480.aspx

All the tutorials support both C# .NET and VB.NET code samples. I've only included the VB.NET links below but you can get C# here.

Tutorial 1: Application Deployment with Shared & Private Deployment
Learn about two different scenarios available for deploying SQL Server 2005 Compact Edition with your applications.
tutorial1_Deployment-vb.EXE
[image]http://www.devbuzz.com/images/sql_compact_edition_tutorial1.jpg[/image]


Tutorial 2: Rapid Application Development Using SQL Server 2005 Compact Edition
In this tutorial, you will learn how to leverage the design capabilities integrated into Visual Studio 2005 in order to rapidly develop applications that use data stored in a SQL Server 2005 Compact Edition database.
tutorial2_RadData-vb.EXE
[image]http://www.devbuzz.com/images/sql_compact_edition_tutorial2.jpg[/image]


Tutorial 3: SQL Server 2005 Compact Edition Data Access with the SqlCeResultSet
Learn how to leverage the design capabilities integrated into Visual Studio 2005 in order to rapidly develop applications that use data stored in a SQL Server 2005 Compact Edition database.
tutorial3_resultset-vb.EXE
[image]http://www.devbuzz.com/images/sql_compact_edition_tutorial3.jpg[/image]


Tutorial 4: Remote Data Access Synchronization with SQL Server 2005 Compact Edition
In this tutorial, you will learn how to create a Windows Forms application that synchronizes data between a SQL Server 2005 database and a SQL Server 2005 Compact Edition database using SQL Server 2005 Compact Edition Remote Data Access (RDA).
tutorial4_RDASync-vb.EXE
[image]http://www.devbuzz.com/images/sql_compact_edition_tutorial4.jpg[/image]


Tutorial 5: SQL Server 2005 Compact Edition Remote Data Access and Merge Replication
This tutorial covers everything that you need to do to configure a server for data synchronization using Remote Data Access.  Learn how to configure Internet Information Services (IIS) for both remote data access (RDA) and merge replication, two technologies that you can use to synchronize data between a Microsoft® SQL Server™ 2005 backend database and a local Microsoft® SQL Server™ 2005 Compact Edition database.
tutorial5_RDAConfig.EXE
[image]http://www.devbuzz.com/images/sql_compact_edition_tutorial5.jpg[/image]



devbuzz -> RE: SQL Server 2005 Compact Edition - MS Tutorials (8/6/2007 3:09:32 AM)

Here's another good tutorial:

Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005



ranveer -> RE: SQL Server 2005 Compact Edition - MS Tutorials (1/19/2009 1:04:36 AM)

Thanks man its really sool article and tutorial so its really a good to have you here thanks again...



binujohnp -> RE: SQL Server 2005 Compact Edition - MS Tutorials (2/4/2009 9:53:37 PM)

I have created an application in VS 2008 and SQL compact 3.5. I created an .sdf file and created 3 tables. I can insert data manually, but through the program i am unable to insert data. What will the problem?

Code is pasted below:
bjNetworkNestConn = new SqlCeConnection("Data Source = \\Program Files\\Bidding\\NetworkNest.sdf");
           objNetworkNestConn.Open();
objNetworkNestCmd = new SqlCeCommand("INSERT INTO Bid VALUES (" + bidNO + ", '" + LoginForm.BidrID + "','" + _itemID +"',"+ yourPrice+", '" + this.txtBidDate.Text + "') ",objNetworkNestConn);
objNetworkNestCmd = new SqlCeCommand("INSERT INTO Bid VALUES (4,'hitl','S042',101, '2/4/2009')", objNetworkNestConn);
int result = objNetworkNestCmd.ExecuteNonQuery(); 

The result is showing a value 1, that means it is successful.

But if i query the table in server explorer, it is not showing the data. Please help me.



petevick -> RE: SQL Server 2005 Compact Edition - MS Tutorials (2/5/2009 2:15:29 AM)

Hi,
this should be a new post - not tagged on the end of an old one.

Put a try catch around your insert statement. Try the same code in query analyser to see if you get an error.



jamesparker -> SQL Server is the key for web designing (10/12/2009 6:50:38 AM)

SQL Server is widely using in the web designing and most of the firms are using the SQL Server 2005edition as it has some very nice features!



Page: [1]



Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 Unicode

0.016