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

Access²Ù×÷ÎÊÌâ-ÐÂÈËÇóÖú

ÓÐÒ»¸öAccess 2000¸ñʽµÄMDBÊý¾Ý¿â£¬ÉèÓÐÃÜÂ룬ÎÒÄܶÔËû½øÐвéѯ²Ù×÷£¬
µ«Ö´ÐÐÔöɾ¸Äʱ¾Í»á³ö´í£¬Å׳öSQLÓï·¨´íÎ󣬵«SQLÓï¾äÔÚAccessÏÂÖ±½ÓÔËÐÐûÓÐÈκÎÎÊÌ⣬Çë¸÷λ´óÏÀÖ¸µãÒ»ÏÂ
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\abc.mdb;Jet OLEDB:Database Password=123";
²éѯ£¬Ã»ÎÊÌ⣺
OleDbConnection objConn = new OleDbConnection(connectionString);
OleDbCommand objComm = new OleDbCommand("select count(*) from table1",objConn);
objConn.open();
response.write(objComm.ExecuteScalar().ToString());
objConn.close();

Ö´ÐÐÔöɾ¸Ä¾ÍÂíÉϱ¨´í£º
OleDbConnection objConn = new OleDbConnection(connectionString);
OleDbCommand objComm = new OleDbCommand("insert into table1(f01,f02) values('abc','cba')",objConn);
objConn.open();
objComm.ExecuteNonQuery();
objConn.close();

catch (Exception er)
er.MessageÌáʾ£ºINSERT INTO Óï¾äµÄÓï·¨´íÎó¡£

ÊDz»ÊÇÎÒµÄÁ¬½Ó×Ö´®³öÁËʲôÎÊÌ⣬»¹ÊÇ´úÂëÉÏÓÐÎÊÌ⣬»¹Çë¸ßÊÖÖ¸µãһϣ¬Ð»Ð»£¡
insert into table1(f01,f02) values('abc','cba')

table1µÄ×Ö¶ÎÈ«²¿Ð´ÍêÁËÂð£¬ÓÐûÓÐÒÅ©£¿ÌرðÊÇ·Ç¿Õ×Ö¶Î

ÔËÐл·¾³ÊÇVS2008£¬ÓõÄÊÇC#£¬ÔÚWebÒ³ÃæÊý¾Ý³õʼ»¯Ê±·¢ÏÖÕâ¸öÎÊÌâ

ÒýÓÃ
ÓÐÒ»¸öAccess 2000¸ñʽµÄMDBÊý¾Ý¿â£¬ÉèÓÐÃÜÂ룬ÎÒÄܶÔËû½øÐвéѯ²Ù×÷£¬
µ«Ö´ÐÐÔöɾ¸Äʱ¾Í»á³ö´í£¬Å׳öSQLÓï·¨´íÎ󣬵«SQLÓï¾äÔÚAccessÏÂÖ±½ÓÔËÐÐûÓÐÈκÎÎÊÌ⣬Çë¸÷λ´óÏÀÖ¸µãÒ»ÏÂ
connectionString="Provider=Microsoft.J


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

dwr Illegal access to default constructor´íÎó

dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
  <param name="formBean" value="prisonerForm"/>
  < ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......

ACCESSµÈ¿âʵÏÖÖðÈÕͳ¼Æ - MS-SQL Server / »ù´¡Àà

±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä  
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ