SQL Server 2005 Compact Edition

DEVBUZZ Forums 2009

Home Forums Register Login My Profile Inbox Address My Subscription My Forums

Photo Gallery Member List UserGroups List Search Calendars FAQ Tickets Log Out

SQL Server 2005 Compact Edition - MS Tutorials

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [SQL Server CE] >> SQL Server 2005 Compact Edition >> SQL Server 2005 Compact Edition - MS Tutorials

Page: [1]

Message

<< Older Topic Newer Topic >>

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

devbuzz

Posts: 457
Score: 0
Joined: 4/26/2002
From: New Jersey, USA & Cape Town, SA
Status: offline

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

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

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

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

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

< Message edited by devbuzz -- 7/20/2007 7:42:39 AM >

_____________________________

Derek Mitchell
http://www.devbuzz.com
Windows Mobile Developer
--------------------------------------
* Share the .NET love when you solve *
* issues by posting your solutions!! *
--------------------------------------

Post #: 1

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

devbuzz

Posts: 457
Score: 0
Joined: 4/26/2002
From: New Jersey, USA & Cape Town, SA
Status: offline

Here's another good tutorial:

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

_____________________________

Derek Mitchell
http://www.devbuzz.com
Windows Mobile Developer
--------------------------------------
* Share the .NET love when you solve *
* issues by posting your solutions!! *
--------------------------------------

(in reply to devbuzz)

Post #: 2

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

ranveer

Posts: 4
Score: 0
Joined: 1/19/2009
Status: offline

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

_____________________________

Web design services
Website Designing Company

(in reply to devbuzz)

Post #: 3

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

binujohnp

Posts: 3
Score: 0
Joined: 2/4/2009
Status: offline

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.

(in reply to ranveer)

Post #: 4

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

petevick

Posts: 3471
Score: 0
Joined: 4/26/2002
From: Bolton - UK
Status: offline

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.

_____________________________

Pete Vickers - Microsoft MVP - Device Application Development
www.gui-innovations.com

Please do not email me with questions. Posting your questions in the forums will get a quicker response - Thanks.

(in reply to binujohnp)

Post #: 5

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

jamesparker

Posts: 1
Score: 0
Joined: 10/12/2009
Status: offline

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!

< Message edited by jamesparker -- 10/12/2009 6:59:35 AM >

(in reply to devbuzz)

Post #: 6