.NET2008 编程实现向远程数据库提交SQL语句
string str = @"Provider = SQLOLEDB;Data Source=zhySys_sy;Initial Catalog=数据同步";
rda = new SqlCeRemoteDataAccess();
try{
rda.InternetUrl=(
http://www.adventure-works.com/sqlmobile/sqlcesa30.dll);
rda.LocalConnectionString=("Data Source=MyDatabase.sdf");
rda.SubmitSql("create table qq (name varchar(32))",str);
}catch (SqlCeException ex){
MessageBox.Show(ex.Message);
}finally {
rda.Dispose();'释放资源
}
匿名2008-08-14 15:26:45121.32.185.*