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

转载别人

  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();
            }
        }