Condividi tramite


SqlCeRemoteDataAccess.Push Method

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Overload List

Transmits changes from a pulled tracked table in SQL Server CE back to the originating SQL Server table. These changes are individually applied to the server in separate transactions.

Supported only by the .NET Compact Framework.

[Visual Basic] Overloads Public Sub Push(String, String)

[C#] public void Push(string, string);

[C++] public: void Push(String*, String*);

[JScript] public function Push(String, String);

Transmits changes from a pulled tracked table in SQL Server CE back to the SQL Server table. These changes can be either individually applied to the server or batched together in a single transaction.

Supported only by the .NET Compact Framework.

[Visual Basic] Overloads Public Sub Push(String, String, RdaBatchOption)

[C#] public void Push(string, string, RdaBatchOption);

[C++] public: void Push(String*, String*, RdaBatchOption);

[JScript] public function Push(String, String, RdaBatchOption);

Example

[Visual Basic, C#] Note   This example shows how to use one of the overloaded versions of Push. For other examples that might be available, see the individual overload topics.

  [Visual Basic] 
' Connection String to the SQL Server.
Dim rdaOleDbConnectString As String = _
    "Provider=sqloledb; Data Source=MySqlServer;Initial Catalog=Northwind; " + "User Id=username;Password = <password>"

' Initialize RDA Object.
Dim rda As SqlCeRemoteDataAccess = Nothing

Try
   'Try the Pull Operation.
   rda = New SqlCeRemoteDataAccess()
   
   rda.InternetLogin         = "MyLogin"
   rda.InternetPassword      = "<password>"
   rda.InternetUrl           = "<http://www.northwindtraders.com/sqlce/sscesa20.dll>"
   rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\ssce.sdf"
   
   rda.Push("MyLocalTable", rdaOleDbConnectString, RdaBatchOption.BatchingOn)

Catch e As SqlCeException
'Use you own Error Handling Routine.
'ShowErrors(e);
Finally
   'Dispose of the RDA Object.
   rda.Dispose()
End Try

[C#] 

        // Connection String to the SQL Server.
        string rdaOleDbConnectString  = "Provider=sqloledb; Data Source=MySqlServer;Initial Catalog=Northwind; " +
            "User Id=username;Password = <password>"; 
                                      
        // Initialize RDA Object.
        SqlCeRemoteDataAccess rda = null;

        try {
            //Try the Pull Operation.
            rda = new SqlCeRemoteDataAccess();
            
            rda.InternetLogin          = "MyLogin";
            rda.InternetPassword       = "<password>";
            rda.InternetUrl            = "<http://www.northwindtraders.com/sqlce/sscesa20.dll>";
            rda.LocalConnectionString  = @"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\ssce.sdf";
           
            rda.Push("MyLocalTable", 
                rdaOleDbConnectString, 
                RdaBatchOption.BatchingOn);
        }
        catch(SqlCeException) {
            //Use you own Error Handling Routine.
        }
        finally {
            //Dispose of the RDA Object.
            rda.Dispose();
        }

[C++, JScript] No example is available for C++ or JScript. To view a Visual Basic or C# example, click the Language Filter button Language Filter in the upper-left corner of the page.

See Also

SqlCeRemoteDataAccess Class | SqlCeRemoteDataAccess Members | System.Data.SqlServerCe Namespace

Syntax based on .NET Framework version 1.1.
Documentation version 1.1.1.

Send comments on this topic.

© Microsoft Corporation. All rights reserved.