Çë½ÌRDAÓësqlserverÊý¾Ýͬ²½ÎÊÌ⣨¼±£©
ÎҵĻ·¾³ÊÇ£ºsqlserver2000+sqlce3.5+sqlcesa3.5+vs2008
ÔÚ½øÐвâÊÔʱÎÒ²ÉÓÃÁËÒÔÏ·½·¨£º
C# code:
SqlCeRemoteDataAccess access = new SqlCeRemoteDataAccess(@"http://localhost/sqlce3.5/sqlcesa35.dll", @"Data source=MyTest.sdf");
string ConnectStr = "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=MyTest;User Id=sa;Password=sa;";
access.InternetLogin = "";
access.InternetPassword = "";
access.Pull("person", "select * from person", ConnectStr, RdaTrackOption.TrackingOnWithIndexes,"errortable");
È»ºó³öÏÖÒÔÏÂÒì³££¬ÏêϸÐÅÏ¢ÈçÏ£º
C# code:
source:Microsoft SQL Server Compact
message:
data:System.Collections.ListDictionaryInternal
errors:System.Data.SqlServerCe.SqlCeErrorCollection
HResult:-2147024891
Source:Microsoft SQL Server Compact
StackTrace: at System.Data.SqlServerCe.NativeMethods.CheckHRESULT(IntPtr pISSCEErrors, Int32 hr)
at System.Data.SqlServerCe.SqlCeRemoteDataAccess.Pull(String localTableName, String sqlSelectString, String oleDBConnectionString, RdaTrackOption trackOption, String errorTable)
at SqlCE__PC.Form1.button5_Click(Object sender, EventArgs e) in C:\Documents and Settin
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
flash ÔõÑùÌáÈ¡ms sqlserverÊý¾Ý¿âµÄÊý¾Ý¡£×îºÃ¸ø¸öÍêÕû´úÂë¿´¿´
flash²»ÄÜÖ±½Ó¶ÁÈ¡Êý¾Ý¿âµÄÊý¾Ý ÓëÊý¾Ý¿âͨѶ¿ÉÒÔ½èÖúxml»òÕßÒ³ÃæÖ®ÀàµÄ
¾ßÌåÊÇÔõÑùÌáÈ¡µÄ£¿
ÈçLZÊìϤ·þÎñÆ÷¶Ë¿ª·¢¿É¿´ÎÒµÄBLOGhttp:/ ......
¶Ô»°¿òÓõ½ÁËdatagrid¿Ø¼þºÍado data control¿Ø¼þ£¬ÓÃinstallshield¶Ô³ÌÐò´ò°üºó£¬¿½±´µ½±ðµÄ»úÆ÷ÉÏÔËÐУ¬datagrid¿ÉÒÔÏÔʾ£¬Ìí¼ÓÊý¾Ýºó£¬datagrid²»Ë¢Ð£¬µ«ÊÇÊý¾Ý¿âÖÐÒѾÓÐÁËÌí¼ÓµÄÊý¾ÝÁË¡£ÇëÎÊÊÇʲôÎÊÌ⣿ÊDz»Ê ......