读书人

RDA,pda与SQL2000/SQL2005数据同步的有

发布时间: 2012-03-28 15:40:03 作者: rapoo

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的不多。很多问题没人解答。奇怪了。

读书人网 >Windows Mobile

热点推荐