Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SqlCeRemoteDataAccess Constructor

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

Overload List

Initializes a new instance of the SqlCeRemoteDataAccess object.

Supported only by the .NET Compact Framework.

[Visual Basic] Public Sub New()
[C#] public SqlCeRemoteDataAccess();
[C++] public: SqlCeRemoteDataAccess();
[JScript] public function SqlCeRemoteDataAccess();

Initializes a new instance of the SqlCeRemoteDataAccess object and configures it for Anonymous access to Microsoft Internet Information Services (IIS).

Supported only by the .NET Compact Framework.

[Visual Basic] Public Sub New(String, String)
[C#] public SqlCeRemoteDataAccess(string, string);
[C++] public: SqlCeRemoteDataAccess(String*, String*);
[JScript] public function SqlCeRemoteDataAccess(String, String);

Initializes a new instance of the SqlCeRemoteDataAccess object and configures it for a Basic or Integrated Windows authentication to Microsoft Internet Information Services (IIS).

Supported only by the .NET Compact Framework.

[Visual Basic] Public Sub New(String, String, String, String)
[C#] public SqlCeRemoteDataAccess(string, string, string, string);
[C++] public: SqlCeRemoteDataAccess(String*, String*, String*, String*);
[JScript] public function SqlCeRemoteDataAccess(String, String, String, String);

Example

[Visual Basic, C#] Note   This example shows how to use one of the overloaded versions of the SqlCeRemoteDataAccess constructor. 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.Pull("Employees", "Select * from Employees", _
       rdaOleDbConnectString, _
       RdaTrackOption.TrackingOnWithIndexes, _
       "ErrorTable")

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.Pull(
                "Employees", 
                "Select * from Employees", 
                rdaOleDbConnectString, 
                RdaTrackOption.TrackingOnWithIndexes , 
                "ErrorTable");
        }
        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

Show:
© 2015 Microsoft