C#ʹÓÃSQLiteÊý¾Ý¿â(asp.net/winform)
C#ʹÓÃSQLiteÊý¾Ý¿â(asp.net/winform)
2009Äê1ÔÂ7ÈÕ
ÆÀÂÛ
·¢±íÆÀÂÛ
SQLite
ÊÇĿǰ±È½ÏÁ÷ÐеÄÒ»¸ö¿ªÔ´¡¢Ãâ·ÑµÄСÐ͵ÄEmbeddable RDBMS(¹ØÏµÐÍÊý¾Ý¿â)£¬ÓÃCʵÏÖ£¬ÄÚ´æÕ¼ÓýÏС£¬Ö§³Ö¾ø´óÊýµÄSQL92±ê×¼£¬¸ö±ð²»Ö§³ÖµÄÇé¿ö£¬ÔÚÕâÀï
˵Ã÷
¶Ô¸÷ÖÖÓïÑÔµÄÖ§³ÖÒ²±È½Ï²»´í£¬wrapperºÜ¶à¡£
Google
Gears ¡¢Mozilla
ºÍ Adobe AIR ¶¼ÔÚʹÓÃsqlite£¬Ó¦¸Ã˵Ã÷Æä»¹ÊǺܲ»´íµÄ
SQLite µÄ¹Ø¼ü×ÖÁÐ±í£¬ÕâÀï
Ö§³ÖµÄsqlÓï·¨£¬ÔÚÕâÀï
ÔÚ .NET
ÀïÃæÊ¹Óà SQLite
£¬ ÎÒÕâÀïʹÓõÄwrapperÊÇ System.Data.SQLite
£¬ËüÖ»ÐèÒªÒ»¸ödll,½Ó¿Ú·ûºÏADO.Net 2.0µÄ¶¨Òå,ÐÔÄÜÒ²²»´í,NHibernateÓõÄÒ²ÊÇËü£¬Ä¿Ç°Ö§³ÖADO.NET 3.5ÁË£¬Ö§³Ö¼¯³ÉÔÚ VS2005 ºÍ VS2008ÀïÃæ£¬¶øÇÒÖ§³Öwince£¬ÊǸöÁÁµã
ÒòΪ·ûºÏADO.NETµÄ¹æ·¶£¬ËùÒÔʹÓ÷½Ê½£¬»ù±¾ºÍ SqlClient
, OleDb
µÈÔÉúµÄÒ»ÖÂ
using System.Data;
using System.Data.SQLite;
//...
using (SQLiteConnection cn = new SQLiteConnection(
"Data Source=Test.db3;Pooling=true;FailIfMissing=false")
)
{
//ÔÚ´ò¿ªÊý¾Ý¿âʱ£¬»áÅжÏÊý¾Ý¿âÊÇ·ñ´æÔÚ£¬Èç¹û²»´æÔÚ£¬ÔòÔÚµ±Ç°Ä¿Â¼Ï´´½¨Ò»¸ö
cn.Open();
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = cn;
//½¨Á¢±í£¬Èç¹û±íÒѾ´æÔÚ£¬Ôò±¨´í
cmd.CommandText = "CREATE TABLE [test] (id int, name nvarchar(20))";
cmd.ExecuteNonQuery();
//²åÈë²âÊÔÊý¾Ý
for (int i = 2; i < 5; i++)
{
cmd.CommandText = string.Format("INSERT INTO [test] VALUES ({0}, 'ÖÐÎIJâÊÔ')", i);
cmd.ExecuteNonQuery();
}
for (int i = 5; i < 10; i++)
{
cmd.CommandText = string.Format("INSERT INTO [test] VALUES ({0}, 'English Test')", i);
cmd.ExecuteNonQuery();
}
//¶ÁÈ¡Êý¾Ý
cmd.CommandText = "SELECT * from [test]";
using (SQLiteDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
Console.WriteLine("µÚ{0} Ìõ£º{1}&q
Ïà¹ØÎĵµ£º
³ÌÐò¿ª·¢ÖУ¬Êý¾ÝÁ÷°´ÕÕÒ»¶¨µÄ¹æÂɽøÐд«Ê䣬Èç¹ûÓû§ºÍ³ÌÐòÖ®¼äµÄ½»»¥ÍêÈ«°´ÕÕÔ¤¶¨µÄЧ¹ûÔËÐУ¬³ÌÐò²»»á³öÏÖÎÊÌâ¡£¿ÉÒÔ¼ÙÉèËù´¦ÀíµÄÊý¾Ý¶¼·ûºÏÒªÇó£¬Í¨¹ý½çÃæ×÷¸ñʽÅж¨£¬ËùÓÐ×ÊÔ´¶¼ÕýÈ·£¬µ«ÊÇΪÁËϵͳµÄ°²È«£¬ÐèÒª´¦Àí´æÔÚµÄÒþ»¼£¬²»ÄܶÔÊý¾Ý°²È«±§ÓÐÀíÏ뻯µÄÏë·¨¡£
ÔÚASP.NET ......
ÕâÁ½ÌìÒòΪҪ×öÒ»¸ö¿ÉÒÔÊÕ¼¯Óû§Ìá½»ÐÅÏ¢£¬È»ºó·¢ËÍÓʼþµ½Ö¸¶¨ÓÊÏäµÄÍøÒ³¡£ÔÚ asp.net 2.0 ÀïÃæ·¢ËÍÓʼþ¿ÉÒÔʹÓà System.Net.Mail ÏÂÃæµÄÀà¡£http://www.systemnetmail.com/faq/2.1.aspx Õâ¸öµØÖ·ÓÐ System.Net.Mail µÄ×÷ÕßдµÄ·Â·ðÊÇ MSDN ÀàËÆµÄ Faq£¬¿´´úÂëµÄʱºò¿ÉÒԲο¼ÒÔÏ¡£Ê²Ã´¶¼²»ËµÁË£¬ÏÂÃæÌù³öÀ´´úÂë°É£¬±Ï¾¹´ú ......
ASP.NETÈí¼þ¹¤³ÌÊ¦ÃæÊÔÌâ
Ò»¡¢Ñ¡ÔñÌâ
1. int[][] myArray3=new int[3][]{new int[3]{5,6,2},new int[5]{6,9,7,8,3},new int[2]{3,2}}; myArray3[2][2]µÄÖµÊÇ£¨£©¡£
A. 9
B. 2
C. &n ......
ÔÚÏàͬ×Ö·û´®µÄÐí¶à²Ù×÷ÉÏ£¬Ê¹ÓÃStringBuilderÀà»á±ÈʹÓÃString¶ÔÏó¸üÓÐЧÂÊ¡£
µ±Äã¶ÔÒ»¸östring¶ÔÏó¸³ÖµÊ±£¬Õâʱ»áÉú³ÉÒ»¸öÕâ¸ö¶ÔÏóµÄ¸±±¾£¬Èç¹ûÄ㸳ֵ¶à´ÎµÄ»°ÔÚϵͳÖоͻᱣ´æ¶à¸öÕâ¸ö¶ÔÏóµÄ¸±±¾£¬»á¶Ôϵͳ×ÊÔ´Ôì³ÉºÜ´óµÄÀË·Ñ£¬µ«ÊÇStringBuilder²»»á³öÏÈÉÏÊöÇé¿ö
StringÊý¾ÝÀàÐÍ´ú±íµÄ ......
¾¹ýÒ»¸ö¶àÔµÄ×¼±¸£¬ÎÒµÄСվASP.NETÑ§Ï°Íø(www.17aspx.com)ÖÕÓÚÉÏÏßÁË¡£½çÃæÍ¼ÈçÏ£º
ASP.NETÑ§Ï°Íø(www.17aspx.com)£¬ÎªASP.NETѧϰÕßÌṩ½Ì³Ì¡¢Ê¾Àý¡¢Ô´Âë¡¢¹¤¾ßµÈѧϰ×ÊÁÏ£¬Íƶ¯ASP.NETѧϰÕßÖ®¼äµÄ½»Á÷¡£Éæ¼°ASP.NET¡¢ASP.NET MVC¡¢LINQ¡¢VS2010¡¢WPF¡¢Silverlight¡¢C#3.5µÈ·½Ãæ¡£ ......