Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡£


Ïà¹ØÎĵµ£º

asp.net(c#)ÍøÒ³Ìø×ªÆßÖÖ·½·¨Ð¡½á

asp.net(c#)ÍøÒ³Ìø×ªÆßÖÖ·½·¨Ð¡½á
·¢²¼Ê±¼ä£º2009-11-25 11:13:03
¡¡¡¡1.Response.Redirect("http://www.yayiba.com",false);
¡¡¡¡Ä¿±êÒ³ÃæºÍÔ­Ò³Ãæ¿ÉÒÔÔÚ2¸ö·þÎñÆ÷ÉÏ£¬¿ÉÊäÈëÍøÖ·»òÏà¶Ô·¾¶¡£ºóÃæµÄboolֵΪÊÇ·ñÍ£Ö¹Ö´Ðе±Ç°Ò³¡£
Ìø×ªÏòеÄÒ³Ãæ£¬Ô­´°¿Ú±»´úÌæ¡£"
ä¯ÀÀÆ÷ÖеÄURLΪз¾¶¡£
:Response.Redirect·½ ......

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

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

VBÓëC#»¥×ª¹¤¾ß

http://www.carlosag.net/Tools/CodeTranslator/ Õâ¸öÒ²Ðíѧ¼ÆËã»úµÄ¸ç¸ç½ã½ãÃÇ»áÓõõ½£¬£¬¾ÍתÁËÏ£Íû¶à¶àÖ§³ÖŶ Î÷Î÷  Óõõ½¾Í¶¥Å¶
²îµãÍüÁËŶ    £¬Åº»¹ÓÐÒ»¸ösqlµÄ²å¼þºÜºÃÓõÄѽ¡£¡£¡£¡£ÓÐÏëÒªµÄ¾ÍÁôÑÔÏÂÒª¿©¡£¡£¡£¡£¡£ ......

C#Á¬½ÓACESSʱ£¬sqlÓï¾äÓдí

ÔÚдsqlÓï¾äʱ£¬Ò»°ã¶¼ÊÇÒ»¾ä½â¾ö£¬´ÓÀ´Ã»Ïë¹ý˵£¬°ÑsqlÓï¾ä²ð¿ªÀ´Ð´¡£
ÀýÈçÏÂÃæÕâ¾ä£º  string readstring = "select * from ʵÀý where ʵÀýID='"+eid+"'";
È»ºóÖ´ÐÐ Myconnection();
        DataSet ds = new DataSet();
        OleD ......

socketͨÐÅjava»òc#ÖÐÎÄÂÒÂëÎÊÌâ

C#ÖÐÏÔʾÖÐÎÄ£º
¡¾
·¢ËÍÊý¾Ý£º  
  string   sReturnData   =   "ÄãºÃ";  
  Byte[]  
bReturnData   =   Encoding.ASCII.GetBytes(sReturnData.ToCharArray());  
 
m_sktSession.Send(bReturnData); 
¡¾½«³öÏÖÂÒÂë¡¿
¡¿  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ