aspÁ¬½Óacess³ö´í - .NET¼¼Êõ / VB.NET
ÔÚͬһ¸öÕ¾µãϽ¨Á¢ÁËfifasp.mdb
£¬ÈúóÓÃÕâ¸ö
<%
'DSNÁ¬½ÓÊý¾Ý¿â·½·¨
set conn=server.CreateObject("ADODB.Connection")
conn.open "DSN=fifasp;UID=admin;PWD=;"
'×Ö·û´®Á¬½ÓÊý¾Ý¿â·½·¨
set conn1=Server.CreateObject("ADODB.Connection")
conn1.open "DRIVER=Driver do Microsoft Access (*.mdb);UID=admin;PWD=;DBQ="&Server.MapPath("fifasp.mdb")
%>
ÔÚÔ¤ÀÀµÄʱºò³ö´íÁË¡£
´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Microsoft Jet Êý¾Ý¿âÒýÇæ´ò²»¿ªÎļþ'(δ֪µÄ)'¡£ ËüÒѾ±»±ðµÄÓû§ÒÔ¶ÀÕ¼·½Ê½´ò¿ª£¬»òûÓв鿴Êý¾ÝµÄȨÏÞ¡£
/result.asp, µÚ 7 ÐÐ
ÇëÎÊÊÇʲôÔÒò£¬Ó¦ÈçºÎÐÞ¸Ä
°ï¶¥ÁË
ÎÒ°´ÕÕ¶þ¥˵µÄ·½·¨£¬ÔÚÊý¾Ý¿âÉϼ¶Îļþ¼ÐÉèÖÃÁ˰²È«ÉèÖ㬿ÉÊÇÎÊÌâÒÀ¾É³öÏÖ£¬ÎÒ°ÑÍêÕûµÄÌáʾÐÅÏ¢Õ³ÔÚÏÂÃæ
´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Microsoft Jet Êý¾Ý¿âÒýÇæ´ò²»¿ªÎļþ'(δ֪µÄ)'¡£ ËüÒѾ±»±ðµÄÓû§ÒÔ¶ÀÕ¼·½Ê½´ò¿ª£¬»òûÓв鿴Êý¾ÝµÄȨÏÞ¡£
/untitled1.asp, µÚ 4 ÐÐ
ä¯ÀÀÆ÷ÀàÐÍ£º
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; 360SE)
ÍøÒ³£º
GET /untitled1.asp
ʱ¼ä£º
2010Äê6ÔÂ8ÈÕ, 9:57:59
ÏêϸÐÅÏ¢£º
Microsoft Ö§³Ö
²¹³äһϣ¬ÎÒÓõÄÊÇÁªÏë×Ô´øµÄxpϵͳ
ȨÏÞÐÞ¸ÄÁËû?ÒýÓÃAccess·¾¶ÓÐûÎÊÌ
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØÐ´url²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖØµã£¬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
dim a as string,b as string£¬c as string
a="¹¤³Ì±àºÅ,µ¥Î»¹¤³ÌÃû³Æ,·Ö²¿¹¤³Ì±àºÅ"
b="µ¥Î»¹¤³ÌÃû³Æ"
c="µ¥Î»"
Ôõô²ÅÄÜÅжϳöa×Ö·û´®ÖдæÔÚb×Ö·û´®£¬¶ø²»´æÔÚc×Ö·û´®
¿´¿´i ......
ÎÊÌ⣺
ÏÖÔÚAccessÊý¾Ý¿âÖÐÓÐÁ½ÕűíTableAºÍTableB
TableAÖÐÓмǼÈçÏÂ:
×Ö¶Î1(Name) ×Ö¶Î2(Num)
A 3
A 4
B 6
... ......