using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.IO;

using System.Windows.Forms;

using System.Data.SqlServerCe;

using System.Reflection; 

设置数据连接及相关连接属性

private string AppPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase.ToString());//程序运行目录

      private SqlCeCommand cmd = new SqlCeCommand();

      private SqlCeConnection con = new SqlCeConnection();

      private string dataBaseName = "test.sdf";

      private string dbFile = string.Empty;

      private string internetURL = "http://192.168.1.187/sqlce20/sscesa20.dll; //IIS代理服务器

      private string remoteConStr = "Provider=sqloledb;Data Source=(local);Initial Catalog=test;User Id=sa; Password=sa;";//IIS代理服务器上能访问到的数据库配置

      private SqlCeEngine se = new SqlCeEngine();

      private SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess(); 

窗体加载项 

private void Form1_Load(object sender, EventArgs e)

        {

            this.dbFile = this.AppPath + @"\" + this.dataBaseName;//数据库

            string str = "DataSource=" + this.dbFile;

            this.con.ConnectionString = str;//终端数据库配置

            this.rda.InternetLogin = "";//访问IIS代理服务器的用户

            this.rda.InternetPassword = "";//访问IIS代理服务器的密码

            this.rda.InternetUrl = this.internetURL;//服务器数据库配置

            this.rda.LocalConnectionString = str;//终端数据库配置

        } 

下载

private void btnPull_Click(object sender, EventArgs e)

      {

          try

          {

              this.ExecuteSql("drop table gdinfos");//先要删除本地数据表如果存在的话，否则会报错

              int tickCount = Environment.TickCount;

              this.rda.Pull("gdinfos", "select * from gdinfos", this.remoteConStr, RdaTrackOption.TrackingOnWithIndexes);

              int num2 = Environment.TickCount - tickCount;

              MessageBox.Show(string.Format("下载成功\n用时{0}毫秒", num2));

          }

          catch (Exception exception)

          {

              MessageBox.Show(exception.Message);

          }

      } 

上传

private void btnPush_Click(object sender, EventArgs e)

       {

           try

           {

               int tickCount = Environment.TickCount;

               this.rda.Push("gdinfos", this.remoteConStr);

               int num2 = Environment.TickCount - tickCount;

               MessageBox.Show(string.Format("上传成功\n用时{0}毫秒", num2));

           }

           catch (Exception exception)

           {

               MessageBox.Show(exception.Message);

           }

       }