网上去收集的信息:用RDA把sql与sqlce数据同步问题

最新推荐文章于 2014-08-28 12:18:00 发布

diaowen3694

最新推荐文章于 2014-08-28 12:18:00 发布

阅读量89

点赞数

原文链接：http://www.cnblogs.com/bobosoft/archive/2008/04/28/1173900.html

版权

本文介绍了一种使用SqlCeRemoteDataAccess类在SQL Server Compact Edition (SQL Server CE) 和 SQL Server之间进行数据同步的方法。具体展示了如何通过Pull操作从SQL Server拉取数据到SQL Server CE，以及如何通过Push操作将SQL Server CE的更改推送回SQL Server。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

转载别人

public void Pull(string localTableName, string sqlSelectString, string oleDBConnectionString, RdaTrackOption trackOption)
        {
            // Connection String to the SQL Server
            string rdaOleDbConnectString = "Provider=sqloledb;Data Source=10.102.197.20;Initial Catalog=Example;Integrated Security=False;User ID=sa;password=;";
            string localString = (@"Data Source =\My Documents\Example.sdf");

            SqlCeRemoteDataAccess rda = null;

            try
            {
                // Try the Pull Operation

                rda = new SqlCeRemoteDataAccess();
               // rda = new SqlCeRemoteDataAccess( "http://10.102.197.20/sqlce3/sqlcesa30.dll", localString);
                rda.InternetLogin = "";
                rda.InternetPassword = "";
              rda.InternetUrl = "http://10.102.197.20/sqlce3/sqlcesa30.dll";
                rda.LocalConnectionString = localString;

rda.Pull("worktime1", "SELECT * FROM WorkTime where 1<>1", rdaOleDbConnectString, RdaTrackOption.TrackingOnWithIndexes, "ErrorTable");
MessageBox.Show("ok");

            }
            catch (SqlCeException e)
            {
               MessageBox.Show(e.Message);
            }
            finally
            {
                rda.Dispose();
            }
        }

        //rda.push方法将 SQL Server CE 跟踪提取表中的更改传送回原始 SQL Server 表。
        public void Push(string localTableName, string oleDBConnectionString, RdaBatchOption batchOption)
        {
             string rdaOleDbConnectString = "Provider=SQLOLEDB; Data Source=10.102.197.20;Initial Catalog=Example;Integrated Security=False;User ID=sa;password=;";
             string localString = (@"Data Source =\My Documents\Example.sdf");

// Initialize RDA Object

SqlCeRemoteDataAccess rda = null;

            try
            {
                rda = new SqlCeRemoteDataAccess();
                rda.LocalConnectionString = localString;
                rda.InternetLogin = "MyLogin";
                rda.InternetPassword = " ";
                rda.InternetUrl = "http://10.102.197.20/sqlce3/sqlcesa30.dll";
                rda.LocalConnectionString = (@"Data Source =\My Documents\Example.sdf");

                rda.Push("WorkTime1", rdaOleDbConnectString, RdaBatchOption.BatchingOn);
                MessageBox.Show("success");
                // "insert into WorkTime1 select * from WorkTime ",

            }
            catch (SqlCeException e)
            {
                MessageBox.Show(e.Message);
               // ShowErrors(e);
            }
            finally
            {
                rda.Dispose();
            }
        }

转载于:https://www.cnblogs.com/bobosoft/archive/2008/04/28/1173900.html