sql数据推送到远程sql服务器,如何将 SQL 语句提交到远程 SQL 服务器（以编程方式）...

如何将 SQL 语句提交到远程 SQL 服务器(以编程方式)

05/21/2007

本文内容

通过使用 SqlCeRemoteDataAccess 对象，您可以将 SQL 语句直接提交到运行 Microsoft SQL Server 的计算机。

提交 SQL 语句

初始化 SqlCeRemoteDataAccess 对象，并设置连接的属性。

SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess("http://www.adventure-works.com/sqlmobile/sqlcesa30.dll", "Data Source=MyDatabase.sdf");

调用 SubmitSql 方法，将 SQL 语句(或存储过程名称)和连接字符串传递到 SQL Server 数据库。

rda.SubmitSql("sp_ValidateData", strConn);

示例

此示例说明如何使用 SubmitSQL 方法在运行 SQL Server 的远程计算机上运行 SQL 命令。

string rdaOleDbConnectString = @"Provider = SQLOLEDB;Data Source=MySqlServer;

Initial Catalog=AdventureWorks; User Id=username;

Password = ";

// Initialize RDA Object

//

SqlCeRemoteDataAccess rda = null;

try

{

// Try the SubmitSql Operation

//

rda = new SqlCeRemoteDataAccess();

rda.InternetLogin = "MyLogin";

rda.InternetPassword = "";

rda.InternetUrl = "http://www.adventure-works.com/sqlmobile/sqlcesa30.dll";

rda.LocalConnectionString = "Data Source=MyDatabase.sdf";

rda.SubmitSql("CREATE TABLE MyRemoteTable (colA int)", rdaOleDbConnectString);

}

catch (SqlCeException)

{

// Handle errors here

//

}

finally

{

//Dispose of the RDA object

//

rda.Dispose();

}

Dim rdaOleDbConnectString As String = @"Provider = SQLOLEDB;Data Source=MySqlServer;" & _

"Initial Catalog=AdventureWorks; " & _

"User Id=username; Password = "

' Initialize RDA Object

'

Dim rda As SqlCeRemoteDataAccess = Nothing

Try

' Try the SubmitSql Operation

'

rda = New SqlCeRemoteDataAccess()

rda.InternetLogin = "MyLogin"

rda.InternetPassword = ""

rda.InternetUrl = "http://www.adventure-works.com/sqlmobile/sqlcesa30.dll"

rda.LocalConnectionString = "Data Source=MyDatabase.sdf"

rda.SubmitSql("CREATE TABLE MyRemoteTable (colA int)", rdaOleDbConnectString)

Catch

' Handle errors here

'

Finally

'Dispose of the RDA object

'

rda.Dispose()

End Try

请参阅

概念

帮助和信息