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#)ÍøÒ³Ìø×ªÆßÖÖ·½·¨Ð¡½á
·¢²¼Ê±¼ä£º2009-11-25 11:13:03
¡¡¡¡1.Response.Redirect("http://www.yayiba.com",false);
¡¡¡¡Ä¿±êÒ³ÃæºÍÔÒ³Ãæ¿ÉÒÔÔÚ2¸ö·þÎñÆ÷ÉÏ£¬¿ÉÊäÈëÍøÖ·»òÏà¶Ô·¾¶¡£ºóÃæµÄboolֵΪÊÇ·ñÍ£Ö¹Ö´Ðе±Ç°Ò³¡£
Ìø×ªÏòеÄÒ³Ãæ£¬Ô´°¿Ú±»´úÌæ¡£"
ä¯ÀÀÆ÷ÖеÄURLΪз¾¶¡£
:Response.Redirect·½ ......
sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
ÔÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......
http://www.carlosag.net/Tools/CodeTranslator/ Õâ¸öÒ²Ðíѧ¼ÆËã»úµÄ¸ç¸ç½ã½ãÃÇ»áÓõõ½£¬£¬¾ÍתÁËÏ£Íû¶à¶àÖ§³ÖŶ Î÷Î÷ Óõõ½¾Í¶¥Å¶
²îµãÍüÁËŶ £¬Åº»¹ÓÐÒ»¸ösqlµÄ²å¼þºÜºÃÓõÄѽ¡£¡£¡£¡£ÓÐÏëÒªµÄ¾ÍÁôÑÔÏÂÒª¿©¡£¡£¡£¡£¡£ ......
ÔÚдsqlÓï¾äʱ£¬Ò»°ã¶¼ÊÇÒ»¾ä½â¾ö£¬´ÓÀ´Ã»Ïë¹ý˵£¬°ÑsqlÓï¾ä²ð¿ªÀ´Ð´¡£
ÀýÈçÏÂÃæÕâ¾ä£º string readstring = "select * from ʵÀý where ʵÀýID='"+eid+"'";
È»ºóÖ´ÐÐ Myconnection();
DataSet ds = new DataSet();
OleD ......
C#ÖÐÏÔʾÖÐÎÄ£º
¡¾
·¢ËÍÊý¾Ý£º
string sReturnData = "ÄãºÃ";
Byte[]
bReturnData = Encoding.ASCII.GetBytes(sReturnData.ToCharArray());
m_sktSession.Send(bReturnData);
¡¾½«³öÏÖÂÒÂë¡¿
¡¿  ......