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
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
dwr.xml: <create creator="struts" javascript="PrisonerActionForm"> <param name="formBean" value="prisonerForm"/> < ......
´ó¼Ò°ïÏÂæÁË Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ ±ÈÈçÎÒÏÖÔÚ²éѯ SELECT * from XS WHERE רҵÃû='¼ÆËã»ú' ²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿ ±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡ ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡ ¸ù¾ÝÕâ¸ö¸Ä°É C# code: public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
±í½á¹¹: table1 Ö¤¼þºÅ ʱ¼ä X31 2010-01-11 3BC 2010-02-03 3AD 2010-02-03 F23 2010-02-09 ...... ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý, ÆÚ´ý½ ......