Share via


Push Method (String, String)

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

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

Syntax

'Declaration
Public Sub Push ( _
    localTableName As String, _
    oleDBConnectionString As String _
)
'Usage
Dim instance As SqlCeRemoteDataAccess
Dim localTableName As String
Dim oleDBConnectionString As String

instance.Push(localTableName, oleDBConnectionString)
public void Push(
    string localTableName,
    string oleDBConnectionString
)
public:
void Push(
    String^ localTableName, 
    String^ oleDBConnectionString
)
member Push : 
        localTableName:string * 
        oleDBConnectionString:string -> unit 
public function Push(
    localTableName : String, 
    oleDBConnectionString : String
)

Parameters

  • localTableName
    Type: System. . :: . .String
    The name of the table that will receive the extracted records. An error occurs if the table already exists.

Remarks

Applications call the Push method to transmit changes from a pulled tracked table back to a  table. The application must have created the local table by calling the Pull method with RdaTrackOption set to TrackingOn or TrackingOnWithIndexes.

oledbConnectionString specifies all the connect information used while connecting to .

If Authentication is used, the user ID specified in OLEDBConnectionString must have the authority to read the table.

If Windows Authentication is used by setting INTEGRATED SECURITY="SSPI" in OLEDBConnectionString, the Internet user must have the authority to read the table. The following identifies the Internet user based on the authentication method:

  • When Internet Information Services (IIS) virtual directory is configured to use anonymous access, the Internet user runs under the identity of the Internet Guest Account (IUSR_computername). If you configure another Windows user account as the Internet Guest Account, the Internet user runs under the identity of that account.

  • When IIS virtual directory is configured to use Basic authentication, the Internet user runs under the identity of the Windows user account for which the client supplied the Internet user name and password.

  • When IIS virtual directory is configured to use Integrated Windows authentication, the Internet user runs under the identity of the Windows user account for which the client supplied the Internet user name and password.

If errorTableName was specified when the Pull method was called, any errors that are detected during the Push are logged in the error table. For more information about how the error table works, see "RDA Conflict Detection and Resolution" in Books Online.

Examples

The following example creates a SqlCeRemoteDataAccess object, sets several properties, and then calls the Push method.

' Connection String to the SQL Server
'
Dim rdaOleDbConnectString As String = "Data Source=MySqlServer;Initial Catalog=AdventureWorks; " & _
    "User Id=username;Password = <password>"

' Initialize RDA Object
'
Dim rda As SqlCeRemoteDataAccess = Nothing

Try
    ' Try the Push Operation
    '
    rda = New SqlCeRemoteDataAccess( _
        "https://www.adventure-works.com/sqlmobile/sqlcesa35.dll", _
        "Data Source=MyDatabase.sdf")

    rda.InternetLogin = "MyLogin"
    rda.InternetPassword = "<password>"

    rda.Push("MyLocalTable", rdaOleDbConnectString, RdaBatchOption.BatchingOn)

    ' or, try this overload:
    '
    ' rda.Push("MyLocalTable", rdaOleDbConnectString)

Catch
    ' Handle errors here
    '
Finally
    ' Dispose of the RDA Object
    '
    rda.Dispose()
End Try
// Connection String to the SQL Server
//
string rdaOleDbConnectString = "Data Source=MySqlServer;Initial Catalog=AdventureWorks; " +
    "User Id=username;Password = <password>";

// Initialize RDA Object
//
SqlCeRemoteDataAccess rda = null;

try
{
    // Try the Push Operation
    //
    rda = new SqlCeRemoteDataAccess(
        "https://www.adventure-works.com/sqlmobile/sqlcesa35.dll",
        "Data Source=MyDatabase.sdf");

    rda.InternetLogin = "MyLogin";
    rda.InternetPassword = "<password>";

    rda.Push("MyLocalTable", rdaOleDbConnectString, RdaBatchOption.BatchingOn);

    // or, try this overload:
    //
    // rda.Push("MyLocalTable", rdaOleDbConnectString);
}
catch (SqlCeException)
{
    // Handle errors here
    //
}
finally
{
    // Dispose of the RDA Object
    //
    rda.Dispose();
}

See Also

Reference

SqlCeRemoteDataAccess Class

SqlCeRemoteDataAccess Members

Push Overload

System.Data.SqlServerCe Namespace