RDA,pda与SQL2000/SQL2005数据同步的问题
1、按照网上介绍,已经配置好了环境,在IE输入http://192.168.1.250/sqlce/sqlcesa30.dll,已经可以看到AGNET的提示
用以下代码
- C# code
private string sqlAgent = "http://192.168.1.250/sqlce/sqlcesa30.dll"; string rdaOleDbConnStr = "Provider=sqloledb;Data Source=192.168.1.250;Initial Catalog=k6;" + "User Id=sa;Password=123";SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess(sqlAgent, connStr); rda.Pull( "mytable", "Select uid, upsw From mytable ", rdaOleDbConnStr, RdaTrackOption.TrackingOnWithIndexes, "errTest"); rda.Dispose(); MessageBox.Show("数据下载成功!");下载下来的表,为什么比原表多了几个字段:
如_sysid bigint,
_syscd datetime,
_syspi varbinary(8000)
_sysmc,_sysmcs,_syssr
?
3:在MOBILE中直接连接SQL2000\SQL2005要怎么做,我试了几天都没有成功。如下代码:
- C# code
string s="Data Source=192.168.1.250;Initial Catalog=k6;User Id=sa;Password=123;"; string s1 = "Data Source=192.168.1.250;Initial Catalog=k6;User Id=sa;Password=;"; string s2 = "Provider=sqloledb;Data Source=192.168.1.250;Initial Catalog=k6;" + "User Id=sa;Password=;"; SqlConnection ccon = new SqlConnection(s); ccon.Open(); SqlDataAdapter ssda = new SqlDataAdapter("select * from mytable", ccon); DataSet sds = new DataSet(); ssda.Fill(sds); dataGrid1.DataSource = sds;4、还有一个问题,在移动平台上,查询SQLCE表的内容,为什么dataGrid1里面的内容显示不出来?
而用LISTBOX就能显示出来?
- C# code
listBox1.Items.Clear(); cmd = new SqlCeCommand("SELECT * FROM mytable", conn); SqlCeDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { listBox1.Items.Add(reader[0].ToString() + ';' + reader[1].ToString()); } SqlCeDataAdapter sda = new SqlCeDataAdapter("SELECT * FROM mytable", conn); DataSet ds = new DataSet(); sda.Fill(ds); dataGrid1.DataSource = ds;[解决办法]
帮你顶一下。好像这个论坛做MOBILE的不多。很多问题没人解答。奇怪了。