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

Çó¸ßÊÖÖ¸µã£¬Ò»¸öPDA³ÌÐò£¬sqliteÊý¾Ý¿âÁ¬½Ó²»ÉÏ£¬¼±

string ConStr="data source=C:\ceshi.db;verson=3;password=123456";
  SQLiteConnection MyConnection = new SQLiteConnection(ConStr);
  try
  {
  MyConnection.Open();
  MessageBox.Show("OK");

  using (SQLiteCommand SQLCom = new SQLiteCommand(MyConnection))
  {
  string strSQL = @"SELECT num from ceshi;";

  SQLCom.CommandText = strSQL;

  SQLiteDataReader SQLReader = SQLCom.ExecuteReader();

  while (SQLReader.NextResult() != false)
  {

  this.label1.Text = SQLReader["num"].ToString();

  }

  }

  MyConnection.Close();

  }

  catch (Exception err)
  {

  throw err;

  }


·¾¶²»¶Ô°É¡£
string ConStr="data source=C:\ceshi.db;verson=3;password=123456"; 

PDAÉϲ»´æÔÚÀàËÆC£º\Õâ¶«¶«°É¡£

ÒýÓÃ
·¾¶²»¶Ô°É¡£
string ConStr="data source=C:\ceshi.db;verson=3;password=123456&


Ïà¹ØÎÊ´ð£º

winceÏÂʹÓÃsqliteµÄ¿ìËÙ²éѯ£¿

´ó¼ÒºÃ£º
      ×î½üÔÚwinceÏÂʹÓÃsqlite£¬µ«ÊÇÓÉÓÚ±íµÄÄÚÈÝÁ¿´ó£¬ËùÒÔ²éѯЧÂʺܵͣ¬²»ÖªµÀʲôÎÊÌâ¼°Ôõô½â¾ö¡£
      ÎҵıíµÄ½á¹¹ÈçÏ£º
      name&nbs ......

SQliteµÄÒ»¸öÎÊÌâ

ÈçÏÂÓï¾ä £º
select TimeSpan from T_Table where onlineDate = '2009-12-2'
Êý¾Ý¿âÀïÃæÓзûºÏÌõ¼þµÄÖµµ«ÊDz鲻³öÀ´
Èç¹û¸Ä³ÉÈçÏ£º
select TimeSpan from T_Table where onlineDate = '200 ......

sqliteÔÚvs2005ÖеÄʹÓñ¨´í

ÔÚvs2005ÖÐÒýÓÃÁËusing System.Data.SQLite;
¶¨ÒåÁËÒ»¸öÁ¬Êý¾Ý¿âÁ¬½Ó±äÁ¿public SQLiteConnection dBConn;
¾Í±¨ÏÂÃæÕâ¸ö´íÎóÁË.
The type 'System.Data.Common.DbConnection' is defined in an ass ......

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý

sqlite ²éѯijһÊý¾ÝËùÔÚµÄÐÐÊý£º

ÆäÖÐÊý¾Ý±íÖÐûÓÐרÃűêʶÌõÊýµÄË÷ÒýÖµ£¬ÎÒÃǸù¾ÝÆäËûһЩ×ֶβéÕÒµ½Á˸ÃÊý¾Ý£¬ÏÖÔÚÐèÒª·µ»Ø¸ÃÊý¾ÝËùÔÚµÄÐÐÊý¡£

ÆäÖÐsqlite manager ÖÐÓÐÒ»¸örowid£¬µ«ÊÇÕâ¸ö²¢ÎÞ·¨· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ