dz̸ÏÂÔØaccessÊý¾Ý¿âµÄ¹¥Óë·À
dz̸ÏÂÔØaccessÊý¾Ý¿âµÄ¹¥Óë·À
http://blog.csdn.net/cncco/archive/2009/06/06/4247474.aspx
Ò»¸öÍøÕ¾µÄ°²È«³É¹¦Óë·ñºÜ´ó³ÌÐòÉÏÈ¡¾öÓÚÄãµÄÊý¾Ý¿âÊÇ·ñ°²È«£¬Èç¹ûÄãµÄÊý¾Ý¿â±»ÏÂÔØµÄ»°£¬ÄÄô»ù±¾ÉÏÄãµÄÕâ¸öÍøÕ¾¾ÍÊDZðÈ˵ÄÁË¡£ÍøÉÏÓÐºÜ¶à¹ØÓÚÕâ·½ÃæÐÅÏ¢£¬ÎÒÓÎÀÀÁËÒ»Ð©ÍøÒ³½áºÏÎÒ×Ô¼ºµÄһЩÌå»á£¬¼òµ¥ËµËµÎҵĿ´·¨¡£
̸Êý¾Ý¿âµÄ°²È«Ê×ÏÈÒª¿´ÄãÊÇÐéÄâÖ÷»úµÄÓû§»¹ÊÇ×Ô¼ºÓµÓжÀÁ¢µÄ·þÎñÆ÷£¬Èç¹ûÊÇÐéÄâÖ÷»úÓû§ÄÄôÔÚ³ÌÐòÉÏÀ´·ÀÖÎÏÂÔØÒª¶àÏëµã°ì·¨£¬Èç¹ûÄãµÄ·þÎñÆ÷ÄØ£¬¿ÉÄÜÔÚȨÏÞÉèÖÃÉÏÉèÖøüÓÐЧ·½±ã¡£
Ê×ÏÈÍÆ¼ö¼¸ÆªÏà¹ØµÄÎÄÕ¡£
·ÀÖ¹ACCESSÊý¾Ý¿â±»ÏÂÔØµÄ9ÖÖ·½·¨
ʵÀý½²½âWebÊý¾Ý¿â°²È«·À»¤
Í»ÆÆMDBÊý¾Ý¿âµÄÏÂÔØÏÞÖÆ
Í»ÆÆÊý¾Ý¿â·ÀÏÂÔØµÄ¼òµ¥¼¸ÕÐ
ÈçºÎÍ»ÆÆÊý¾Ý¿âLoop·ÀÏÂÔØÊµÀý
Õ⼸ƪÎÄÕÂ×ÜºÍÆðÀ´²î²»¶à¿ÉÒÔÁ˽âÒ»¸ö·ÀÖÎaccessÊý¾Ý¿â·ÀÖÎÏÂÔØµÄ»ù±¾ÖªÊ¶ÁË¡£
1£¬¼¸¸ö¼òµ¥µÄ·ÀÖÎÏÂÔØºÍ½â¾ö°ì·¨¡£°ÑÊý¾Ý¿âÃûÉèÖÃΪ#data.mdb£¬Ö»Òª°Ñ#Ìæ»»Îª%23¾Í¿ÉÒÔ½â¾ö£»°ÑÓû§ÃûÉèÖÃΪ%55data.mdb£¬°Ñ%55Ìæ»»Îª%25¼´¿É£»Ò²ÓÐÅ£±ÆµÄ°ÑÊý¾Ý¿âÉèÖóÉ2wegodb%^&(bfjk&^%980995646563&^%$sdfda.mdb£¬Õâ¸öÄÑŪЩ£¬Èç¹ûÖ»ÊÇÖªµÀ·¾¶¿ÉÄÜÄÑÏÂÔØ£¬ÄÇÆªÎÄÕµÄ×÷ÕßÊDZ¸·ÝÖØÃüÃûµÄ·½·¨ÏÂÔØÏÂÀ´µÄ¡£
2£¬°ÑÊý¾Ý¿âµÄÀ©Õ¹ÃûÐÞ¸ÄΪasp¡£Èç¹ûÄã½ö½öÊǰÑmdbÊý¾Ý¿âÀ©Õ¹ÃûÐÞ¸ÄΪasp£¬ÄÇÊÇûÓÐË¿ºÁ×÷Óõģ¬ÕÕÑù±»ÏÂÔØ¡£Èç¹ûÎÒÔÚÊý¾Ý¿âÖÐдÈëûÓбպϵÄasp´úÂ룬ÒòΪasp³ÌÐòÊÇÔÚ·þÎñÆ÷Ö´Ðеģ¬ÄÇôasp³ÌÐò¾Í»á³ö´í£¬Êý¾Ý¿â×ÔÈ»¾ÍÎÞ·¨ÏÂÔØÁË¡£Õâ¸ö×î»ù±¾µÄ·½·¨¾ÍÊÇÔÚÊý¾ÝÖÐдÈë¶þ½øÖƵÄ<%£¬Õâ¸ö·½·¨Ò»°ãÊÇÔÚÊý¾Ý¿âÖн¨Á¢Ò»¸ö±ínotdownload£¬Ìí¼ÓÒ»¸önotdown×ֶΣ¬Ð´Èë<%£¬ÄÄôÕâ¸ö×î»ù±¾·ÀÓù·½·¨¾Í³öÀ´ÁË¡£Õª³×ÓÍøÉϵĴúÂ룺
view plaincopy to clipboardprint?
<%
db="access.mdb" 'Äã×Ô¼ºÊý¾Ý¿âµÄµØÖ·
set conn=server.createobject("Adodb.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(db)
conn.open connstr
conn.execute("create table notdownload(notdown oleobject)") 'Ìí¼Ónotdownload±í
set rs=server.createobject("adodb.recordset") &nb
Ïà¹ØÎĵµ£º
1¡¢Ìí¼ÓADODC1µ½´°Ìå
2¡¢×¼±¸ºÃÒ»¸öACCESSн¨µÄ¿ÕÊý¾Ý¿â66.mdb
Private Sub Form_Load()
With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Documents and Settings\Administrator\" & _
"My Docume ......
±¾ÎĽ«c#ÓïÑÔ²Ù×÷AccessÊý¾Ý¿âµÄ·½·¨¼ÓÒÔ×ܽᣬÖ÷Òª½â¾öµÄÎÊÌâÈçÏ£º
´´½¨mdb
´´½¨table
¶ÁÈ¡tableÄÚÈÝ
²é
ѯtableÖеÄÄÚÈÝ
ÏòtableÖвåÈëÊý¾Ý
ɾ³ýtableÖеļǼ
ÏòtableÖвåÈëÕÕÆ¬
¶ÁÈ¡tableÖеÄÕÕÆ¬µÈ¡£
ÎÄ
½éÉÜC#
·ÃÎʲÙ×÷AccessÊý¾Ý¿âµÄ»ù´¡ÖªÊ¶£¬²¢Ìá
¹©Ò»¸öÏà¹ØµÄÀý³Ì¡£C#µÄADO.NET»¹²»ÄÜͨ¹ý±à³Ì·½Ê½´ ......
ÉÏһƪÖÐÎÒÒѾ˵ÁËÏÂÈçºÎ²Ù×÷ACCESSÊý¾Ý¿â£¬ÏÂÃæÀ´ËµËµ´æÈ¡Í¼Æ¬£¬ÉùÒôÖ®ÀàµÄÎÊÌâ¡£
ÓÉÓÚͼƬ£¬ÉùÒô²»ÄÜÖ±½Ó´æ´¢£¬ÕâÀï¾ÍÒªÓõ½Êý¾ÝÁ÷·½Ê½ÁË¡£¶ÔÓÚ.NETÖеÄһЩÊõÓï¸ÅÄîÎÒÈÔÈ»ºÜÃÔºý£¬ÔÚѧϰÖС£Ö÷ÒªÎÒ²»ÊÇרҵµÄ£¬
Ö»ÊÇ¿ªÊ¼Ñ§Á˵ãVB6´úÂ룬Ȼºó¾ÍÓÃVB.NETÁË£¬ËùÒÔĿǰֻÊÇ»áдµã´úÂ룬ȴ²»Öªµ ......
C# accessÈÕÆÚ²éѯ¼Ó#
if (((string)((ComboBoxItem)cmbField.SelectedItem).Value).Equals("System.DateTime"))
{
//ÅжÏÈÕÆÚµÄ;
& ......
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.spri ......