Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Å×ÆúMS Access°É£¬ÇëʹÓÃSQLite

Å×ÆúMS Access°É£¬ÇëʹÓÃSQLite
1¡¢SQLite¼ò½é
SQLiteµÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾ­ÓÐ4¸öÄêÍ·ÁË. ¶øÔÚ½ñÄêµÄ5ÔÂSQLiteÒ²Ó­À´ÁËÒ»¸öеÄÀï³Ì: SQLite 3. SQLite¹Ù·½ÍøÕ¾: http://www.sqlite.org/
2¡¢SQLiteÀàÐÍ
SQLiteµÄÊý¾ÝÀàÐÍ
Ê×ÏÈÄã»á½Ó´¥µ½Ò»¸öÈÃÄ㾪ÑȵÄÃû´Ê: Typelessness(ÎÞÀàÐÍ). ¶Ô! SQLiteÊÇÎÞÀàÐ͵Ä. ÕâÒâζ×ÅÄã¿ÉÒÔ±£´æÈκÎÀàÐ͵ÄÊý¾Ýµ½ÄãËùÏëÒª±£´æµÄÈκαíµÄÈκÎÁÐÖÐ, ÎÞÂÛÕâÁÐÉùÃ÷µÄÊý¾ÝÀàÐÍÊÇʲô(Ö»ÓÐÔÚÒ»ÖÖÇé¿öϲ»ÊÇ, ÉÔºó½âÊÍ). ¶ÔÓÚSQLiteÀ´Ëµ¶Ô×ֶβ»Ö¸¶¨ÀàÐÍÊÇÍêÈ«ÓÐЧµÄ. Èç:
Create Table ex1(a, b, c);
³ÏÈ»SQLiteÔÊÐíºöÂÔÊý¾ÝÀàÐÍ, µ«ÊÇÈÔÈ»½¨ÒéÔÚÄãµÄCreate TableÓï¾äÖÐÖ¸¶¨Êý¾ÝÀàÐÍ. ÒòΪÊý¾ÝÀàÐͶÔÓÚÄãºÍÆäËûµÄ³ÌÐòÔ±½»Á÷, »òÕßÄã×¼±¸»»µôÄãµÄÊý¾Ý¿âÒýÇæ. SQLiteÖ§³Ö³£¼ûµÄÊý¾ÝÀàÐÍ, Èç:
CREATE TABLE ex2(
a VARCHAR(10),
b NVARCHAR(15),
c TEXT,
d INTEGER,
e FLOAT,
f BOOLEAN,
g CLOB,
h BLOB,
i TIMESTAMP,
j NUMERIC(10,5)
k VARYING CHARACTER (24),
l NATIONAL VARYING CHARACTER(16)
);
Ç°ÃæÌáµ½ÔÚijÖÖÇé¿öÏÂ, SQLiteµÄ×ֶβ¢²»ÊÇÎÞÀàÐ͵Ä. ¼´ÔÚ×Ö¶ÎÀàÐÍΪ”Integer Primary Key”ʱ.
SQLiteÖ§³ÖSQL92 ±ê×¼¡£
3¡¢ÓÃ.NET²Ù×÷sqliteÊý¾Ý¿â
System.Data.SQLite
ÊÇÒ»¸öԭʼSQLiteµÄ¼ÓÇ¿°æ.  Ëü½«ÊÇÒ»¸öÔ­°æµÄsqlite3.dllÍêÈ«Ìæ´úÆ· (ÄãÉõÖÁ¾Í¿ÉÒÔ°ÑËüÖØÃüÃûΪsqlite3.dll).  Ëü²»ÐèÒªÁ´½Ó.NET ÔËÐÐʱ£¬ËùÒÔ¿ÉÒÔÍÑÀë.NET¶ÀÁ¢·¢²¼, È»¶øËüÄÚǶÁËÒ»¸öÍêÕûµÄ ADO.NET 2.0 ÒýÇ棬Ϊ¿ª·¢ÌṩÁËÍêÕûµÄÖ§³Ö.
ÒÔÏÂÊÇËüµÄÌØÐÔ¼ò½é:
ÍêÕûµÄ ADO.NET 2.0 ʵÏÖ
Õû¸ö¹¤³ÌÍêÈ«»ùÓÚVS2005 ºÍ ADO.NET 2.0ȫй¹½¨, ʹÓÃÁËÈ«²¿µÄADO.NET frameworkÐÂÌØÐÔ.  °üÀ¨ÍêÕûµÄ DbProviderFactory Ö§³Ö, ×Ô¶¯µÄ·Ö²¼Ê½ÊÂÎñµ÷ÓÃ, ¹ã·ºµÄģʽ֧³Ö, ´ËÍâËùÓеÄÀ඼ÊÇ´Ó ADO.NET 2.0 µÄ»ùÀà¼Ì³ÐÏÂÀ´µÄ.
Ö§³ÖÍêÕûºÍ¾«¼òµÄ .NET Framework ÒÔ¼° C/C++
Õâ¸ö¿â²»ÐèÒªÁ´½ÓÒÀÀµ.NETÔËÐÐʱ£¬100%¼æÈÝԭʼµÄsqlite3.dll£¬¿ÉÒÔʹÓ÷ÇÍйܵÄC/C++ ½øÐпª·¢.
¿ÉÒÆÖ²µÄÊý¾Ý¿âÎļþ
δ¼ÓÃÜµÄ SQLite Êý¾Ý¿âÎļþ¿ÉÒÔ×ÔÓɵĿçƽ̨ºÍ´¦ÀíÆ÷ʹÓ㬰üÀ¨·ÇWindowsƽ̨. ¼ÓÃÜÖ®ºóµÄÊý¾Ý¿â¿ÉÒÔÔÚÈ«²¿Windowsƽ̨ÉÏʹÓÃ.
¿ÉÒÔÐÅÀµµÄËٶȣ¬±È°üÀ¨Sql Server Mobile ÔÚÄÚµÄÆäËü´ó¶àÊýǶÈëʽÊý¾Ý¿â¶¼Òª¿ìËÙ
SQLite'°²×°ËùÕ¼ÓõĿռäÏà¶ÔÓÚSql Mobile¿ÉνºöÂÔ²»¼ÆÁË. ËüÔ


Ïà¹ØÎĵµ£º

[Òý]SQLServerºÍAccess¡¢ExcelÊý¾Ý´«Êä¼òµ¥×ܽá

http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔ­Òò£¬¿Í»§ÒÔÇ°µÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾­³£ÐèÒª·ÃÎÊÎı¾Êý ......

NTDLL.DLL): 0xC0000005: Access Violation ½â¾ö·½·¨


ÔÚ±àд×Ô¼ºµÄdll³ÌÐòµÄʱºò£¬ÏÈ¿ªÊ¼ÔÚµ÷ÓÃdllµÄexeÉϳöÏÖ(AVIDLL.DLL): 0xC0000005: Access Violation£¬²»ÊǺÜÃ÷°×£¬ÎªÊ²Ã´»á³öÏÖÕâ¸öÎÊÌâ¡£
ÔÚÄÚ²¿½øÐе÷ÊÔµÄʱºò·¢ÏÖ£¬Êǵ÷ÓÃÁËnew²Ù×÷·ûµÄÔµ¹Ê¡£
ºÜ²»Àí½â£¬ÔÚdllÖе÷ÓÃnew²Ù×÷·û»á³öÏÖÕâôһ¸öÎÊÌ⣬ÍøÂçÉÏËÑË÷£¬ÔÚ΢ÈímsdnÂÛ̳£¨¾ßÌåµØÖ·£ºhttp://forums.msdn.mic ......

C#¹Ø¼ü×Ö£º·ÃÎʹؼü×Ö£¨access keyword£©

 C#ÖзÃÎʹؼü×Ö£¨access keyword£©ÓÐÁ½¸ö£ºbase¡¢this
 
1.base
   ÓÃÓÚ´ÓÅÉÉúÀàÖзÃÎÊ»ùÀàµÄ³ÉÔ±£¬°üÀ¨£º
     a.µ÷ÓûùÀàÉÏÒѱ»ÆäËü·½·¨ÖØд£¨override£©µÄ·½·¨¡£
     b.Ö¸¶¨´´½¨ÅÉÉúÀàʵÀýʱӦµ÷ÓõĻùÀ๹Ô캯Êý¡£
  ×¢Ò⣺¶Ô»ùÀàµÄ·ÃÎÊÖ»ÄÜ ......

»ñÈ¡AccessÓû§¶¨ÒåµÄ±íÃûºÍ¸÷±íµÄ×Ö¶ÎÃû

 public   static  DataTable GetSchemaTable(string connectionString)  //»ñÈ¡AccessËùÓеıíÃû£»
        {
            using (OleDbConnection connection = new
    &n ......

ACCESS¶¨Ê±Ô¶³Ì±¸·Ý

ACCESSÔ¶³Ì±¸·ÝÒ»Ö±ÊǸöÁîÈËÍ·ÌÛµÄÎÊÌâ ¿´µ½Ò»¸ö²»´íµÄ±¸·Ý·½·¨ ·ÖÏíÏ£º
Ô­ÎĵØÖ·£ºhttp://www.cnblogs.com/catcat811/archive/2009/12/31/1637186.html
ÍøÕ¾ÓÖ¹ØÁË~~~¹ØµÃºÜͻȻ£¬Êý¾ÝÒ²À´²»¼°±¸·Ý¡£ÒòΪ¹«Ë¾Óиö²Ö¿âµÄϵͳÔÚ×âÓ÷þÎñÆ÷ÉÏ£¬Èç¹ûÍ£Á˾͵ÃÖØеã²Ö£¬ÄÇÊǺÜÀÛÈ˵ÄÊ¡£×î½üÍøվʱ³£¹Ø£¬ÕæÈÃÈËÍ·Í´¡£ÎªÁ˱Üà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ