Çë½Ì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
Ïà¹ØÎÊ´ð£º
ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾
ʲôÐÐÒµ°¡....
µ½51aspx.co ......
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÈçÌâ
±¾È˲ËÄñ
²»ÊÇÓÃsql×öµÄÊý¾Ý¿âÈí¼þ µÄʹÓûúÆ÷ÉÏ ¶¼µÃ°²×° sqlServer°É¡£¡£..
ÎÒ¿´µ½ÓÐЩÈí¼þ µã¿ªÈí¼þ Êý¾Ý¿â¾ÍÒѾµ¼Èë½øÈ¥ÁË ¸ùĿ¼ֻÓиömdb
ÇëÎʸßÊÖÃÇÓûùÓÚsqlµÄ c#³ÌÐò Ôõô×ö³ÉÄÇÑù ......
ÔõôÔÚjspÁ´½Ósqlserver2000£¬Ìø×ªÀϲ»³É¹¦£¬²»¹ÜÔõôÊäÈ룬ÃÜÂëÓû§Ãû¶¼ÓÐ´í£¬Õâ¸öµÄÎÊÌâÊdzöÔÚÄÇ£¬Çë¸ßÊÖÒ»¶¨Òª°ïÎÒ°¡£¬Ð»Ð»
°ÑÄãµÄjsp¶«Î÷Ìù³öÀ´°¡
ÏȰѴúÂëÌù³öÀ´²ÅÄÜÖ»Äܵ½ÊÇʲô´í¡£
±¨µÄɶ´í
ÄãÁ¬½ ......