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

c# sqlite Êý¾Ý¿â¼ÓÃÜ


ÓÃÁËADO.NET 2.0 SQLite Data Provider ÕâÑù¿ÉÒÔÖ±½ÓÀûÓÃËüÀ´´´½¨Ò»¸ö¼ÓÃܵÄsqliteÊý¾Ý¿â¡£
ÓйØc#´úÂëÈçÏ£º
1¡¢´´½¨¿ÕµÄsqliteÊý¾Ý¿â¡£
//Êý¾Ý¿âÃûµÄºó׺Äã¿ÉÒÔÖ±½ÓÖ¸¶¨£¬ÉõÖÁûÓкó׺¶¼¿ÉÒÔ
//·½·¨Ò»£º´´½¨Ò»¸ö¿ÕsqliteÊý¾Ý¿â£¬ÓÃIOµÄ·½Ê½
FileStream fs = File.Create(“c:\\test.db“);
//·½·¨¶þ£ºÓÃSQLiteConnection
SQLiteConnection.CreateFile(“c:\\test.db“);
´´½¨µÄÊý¾Ý¿âÊǸö0×Ö½ÚµÄÎļþ¡£
2¡¢´´½¨¼ÓÃܵĿÕsqliteÊý¾Ý¿â
//´´½¨Ò»¸öÃÜÂëΪpasswordµÄ¿ÕµÄsqliteÊý¾Ý¿â
SQLiteConnection.CreateFile£¨“c:\\test2.db“);                
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\\test2.db“);
SQLiteConnection cnn = new SQLiteConnection(“Data Source=D:\\test2.db“);
cnn.Open();
cnn.ChangePassword(“password“);
3¡¢¸øÎ´¼ÓÃܵÄÊý¾Ý¿â¼ÓÃÜ
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\\test.db“);
cnn.Open();
cnn.ChangePassword(“password“);
4¡¢´ò¿ª¼ÓÃÜsqliteÊý¾Ý¿â
//·½·¨Ò»
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\\test2.db“);
cnn.SetPassword(“password“);
cnn.Open();
//·½·¨¶þ
SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder();
builder.DataSource = @”c:\test.db“;
builder.Password = @”password“;
SQLiteConnection cnn = new SQLiteConnection(builder.ConnectionString);
cnn .Open();
×¢£º
A¡¢ÒòΪ¼ÓÃܵĺ¯ÊýÊÇÀûÓÃwindows api£¬¹Ê¼ÓÃܺóµÄÊý¾Ý¿âÖ»ÄÜÊÊÓÃÔÚwindowsƽ̨£¬¼ÓÃܵķ½Ê½ÊÇÕûÌåÎļþ¼ÓÃÜ¡£
B¡¢¼ÓÃܵÄËã·¨ÊÇRC4£¬Èç¹ûÄãÏë²ÉÓñðµÄ¼ÓÃÜËã·¨À´¼ÓÃÜ£¬Çë²Î¿¼ADO.NET 2.0 SQLite Data Provider µÄÔ´ÂëÀ´Ð޸ġ£
c¡¢Ïà¹ØsqliteÊý¾Ý¿â²Ù×÷ÀàËÆADO.NET 2.0¡£Ïê¼ûADO.NET 2.0 SQLite Data ProviderµÄ°ïÖúÎĵµ¡£
c¡¢ADO.NET 2.0 SQLite Data Provider °æ±¾Îª£º1.0.53.0 £¬SQLite°æ±¾ : 3.6.0¡£
d¡¢¿ª·¢»·¾³Îªvs2008¡£


Ïà¹ØÎĵµ£º

IBatisNet SQL ServerµÄfloatÀàÐÍת»»Îªc# float³ö´í

½ñÌìдһ¸öÉÌÆ·µÄÐ޸ŦÄÜʱÓöµ½µÄÎÊÌâ
ÉÌÆ·ÖÐÖØÁ¿ weight µÄÊý¾Ý¿â(SQL Server2005)ÀàÐͶ¨ÒåΪ float
ÔÚmappings ÖÐת»»Îªc#ÀàÐ͵ÄÒ»¾äΪ
<result property="Goods_Weight" column="Goods_Weight" type="float" dbType="float"/>
°´Àí˵Õâ¸ö float ÊÇÒ»ÑùµÄ£¬×ª»»ÍêÈ«²»»á³öÏÖÎÊÌ⣬
ʵ¼Ê³ÌÐòÔËÐÐʱ£¬ÏµÍ³±¨´í ......

SqLite ʱ¼ä¸ñʽ


sqliteʱ¼äº¯Êý£¨×ª£©
2007Äê12ÔÂ10ÈÕ ÐÇÆÚÒ» 13:33
תÌùÔ­Òò£º×î½üÉè¼ÆÁËÒ»¸ö¿çÊý¾Ý¿âµÄº¯Êý£¬À´²âÊÔ²âÊÔsqlite¡£
SQLite·ÖÒ³ÏÔʾ£ºSelect * from news order by id
desc Limit 10 Offset 10
ÕâÆªÎÄÕÂÊǸù¾Ý SQLite ¹Ù·½ WIKI ÀïµÄÄÚÈÝ·­Ò룬Èç¹ûÓÐʲô·­Òë²»µ±µÄµØ·½Ï£Íû´ó¼ÒÖ¸³ö£¬±Ï¾¹ÎÒµÄÓ¢ÎÄˮƽʵÔںܲ SQ ......

SQLiteÃüÁîÐгÌÐò˵Ã÷

sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
Ô­ÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
    SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
    Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......

SQLite ³õÌåÑé

1. ÏÂÔØ×îаæ SQLite (sqlite-3_6_23_1), copyµ½C:\ÏÂ.
2. н¨Êý¾Ý¿â:
C:\>sqlite3.exe "d:\testdb.db"
3.½øÈëÁËsqlite3Ö®ºó£¬»á¿´µ½ÒÔÏÂÎÄ×Ö£º
SQLite version 3.1.3
Enter ".help" for instructions
sqlite>
4.½¨Ò»¸öÃû½ÐfilmµÄÊý¾Ý¿â±í
create table film(title, length, year, starring);
5.²åÈë¼Ç¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ