ÎÒÊÇÒ»¸öÐÂÊÖ£¬¶Ôaccess»ù±¾ÉÏûÔõô½Ó´¥¹ý£¬ÏÖÔÚÎÒÏë±à¼ÖÆ×÷Ò»¸öÊý¾Ý¿â£¬ Ö÷ÒªÊǰÑÒ»Ð©ÍøÖ··Å½øÕâÖÖ¸ñʽµÄÊý¾Ý¿â{ÎļþÒÑÉÏ´«}
http://www.access911.net/csdn/filedescription.asp?mdb=2010-3-31&id=41&mode=3£¬ÎÒÖ±½Ó¸´ÖƽøÈ¥Óò»ÁË£¬²»ÖªµÀΪʲô£¬ÔÚÕâÀïÇë½Ì¸÷λ´óÏÀÂð£¿Ð»Ð»ÁË
²»ÊÇÒѾÊäÈë½øÈ¥ÁËÂ𣿠ÄãµÄ ......
C# code:
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("Ex07_01.mdb") + ";Connect Timeout=60;";
OleDbConnection oc = new OleDbConnection(ConStr);
Response.Write(ConStr + "<br>");
......
C# code:
string sql = "insert into [CompInfor]([ZhDetails],[EnDetails])values('" + compinfor.ZhDetails + "','" + compinfor.EnDetails + "') where classid='" + compinfor.classid + "' and Language='" + compinfor.Language + "'";
accessÊ ......
access δָ¶¨´íÎó
·Åµ½IISÉÏˢм¸´Î¾Í»á³öÏÖ
ʹÓö¯ÈíµÄDbHelperOleDb.csÀà·ÃÎÊDatabase.accdbÊý¾Ý¿â
ˢм¸´Î¾Í»á³öÏÖ???
»¹ÓÐÕý³£µÄʱºò£¿
ÊÇ·ñ´ò¿ªÁËÊý¾Ý¿â£¬ÓÃÍêδ¶Ï¿ª£¨¹Ø±Õ£©Á¬½Ó£¿
ÓÑÇé°ï¶¥
×Ô¼º½â¾öÁË£¬ÊÇExecuteReaderÕâ¸öÔĶÁÆ÷£¬ËûÔÚUSINGÖв¢Ã»Óйرգ¬ÔÚËû¶ÁÈ¡µÄʱºóÒª±£³ÖÁ¬½Ó£¬¿ÉÊÇËû¶ÁÈ¡º ......
ÏÖÔÚÓÖ±íTT£¬×Ö¶Îname,dateday(ʱ¼ä/ÈÕÆÚÐÍ)¡£
ÎÒÏëÔڼǼ±£´æÖ®Ç°¼ì²éÊý¾Ý¿âÖÐÓÐûÓÐÏàͬµÄ¼Ç¼£¬Óеϰ¾Í²»±£´æ£¬Ò²¾ÍÊǼì²éname ºÍ timedayÏàͬʱ¾Í²»±£´æ¡£µ«ÏÂÃæµÄSELECTÓï¾äÀÏÊDZ¨´í¡£Çë´ó¼Ò°ï濴һϣ¬Ð»Ð»£¡
Êǵڶþ¸öÌõ¼þ£¨ÈÕÆÚÌõ¼þ£©³ö´íÁË£¬µ«ÎÒ²»ÖªµÀÔõôÐ޸ġ£
ADOQuery1.Close;
ADOQuery ......
ACCESSÖвéѯÈçÏ£º
PARAMETERS letter Text ( 255 );
SELECT ¡¡¡¡ from table1 WHERE letter = letter
ÎÒ¿´µ½¹ý´«µÝÁ½¸ö²ÎÊý£¨Ê±¼ä£©µÄÀý×Ó¡£ÒòΪСµÜÊǰ®ºÃ£¬²»ÊÇרҵ³ÌÐòÔ±£¬ËùÒÔ²»ÖªµÀÔõô¸Ä¡£Çë¸ßÈËÖ¸µã£¬ÎÒÐèÒª´«µÝµÄÊÇ×Ö·û¡£
ÏÂÃæÊÇ´«µÝʱ¼äµÄÀý×Ó£º
C# code:
this.conn.Open(); ......