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

aspÁ¬½ÓaccessÊý¾ÝÀý×Ó

<%Dim connstrconnstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Stu.mdb")
Set bb = Server.CreateObject("ADODB.Connection")
bb.Open connstr%>
<html>
<head>
<meta http-equiv="content-Language" content="zh-cn" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>Asp+Access¶ÁÈ¡Êý¾Ý¿â</title>
</head>
<body>
<%Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "select * from StuInfo",bb
if rs.eof and rs.bof then
response.Write "Êý¾Ý¿âÖÐûÓÐÊý¾Ý"
response.End()
end if
response.Write rs("Name")response.Write rs("Sex")
%>
</body>
</html>


Ïà¹ØÎĵµ£º

ʹÓÃxml flashÓëASPͨÐŵļ¸ÖÖ·½·¨

FlashÖеÄXML¶ÔÏóÒ²Óз½·¨¿ÉÒÔ½«XMLÊý¾ÝÏò·þÎñÆ÷·¢ËÍ¡£¼´sendºÍsendAndLoad¡£send·½·¨Ïòij¸ö URL ´«µÝ XML ¶ÔÏ󣬷µ»ØµÄÐÅÏ¢¶¼±»·¢Ë͵½ÁíÍâÒ»¸öä¯ÀÀÆ÷´°¿Ú£»sendAndLoad ·½·¨Ïòij¸ö URL ·¢ËÍÒ»¸ö XML ¶ÔÏó¡£·µ»ØµÄÐÅÏ¢¶¼·ÅÔÚÒ»¸öXML¶ÔÏóÖС£
ÔÚijÖ̶ֳÈÉÏ£¬ XMLµÄsend·½·¨ºÍsendAndLoad·½·¨ÀàËÆÓÚloadVars¶ÔÏóµÄsend·½·¨ºÍ ......

·þÎñÆ÷ʵÀý£ºÓÃASP¼ÜÉè¸øÿ¸öIISÕ¾µã½¨Á¢Ò»¸öÓû§


Ò»¡¢ÕâÑùÅäÖõĺô¦£¿
²»Öª´ó¼ÒÓÐûÓÐÌý¹ýÅÔ×¢£¿ÎÒ¼òµ¥µÄ½âÊÍһϰɣºÓиöÈËÏëºÚµôAÕ¾µã£¬µ«ÕÒÀ´ÕÒÈ¥¶¼Ã»·¢ÏÖ¿ÉÀûÓõÄ©¶´£¬ÎÞÒâÖÐËû·¢ÏÖÓëAͬ·þÎñÆ÷ÉÏ»¹ÓиöBÕ¾µã£¬²¢ÇÒÔÚBÕ¾µãÉÏÕÒµ½ÁË¿ÉÀûÓõÄ©¶´£¬ÓÚÊÇËû½«Ä¾Âí´ÓBÕ¾ÖÐÉÏ´«ÖÁ·þÎñÆ÷£¬Èç¹û·þÎñÆ÷ȨÏÞÅäÖò»µ±£¬ÄÇôÏÖÔÚËû¾Í¿ÉÒÔºÚµô·þÎñÆ÷ÉϵÄËùÓÐÕ¾µãÁË£¡Èç¹ûÎÒÃÇΪà ......

¹ØÓÚACCESSÏÂOleDbParameterµÄʹÓÃ

½ñÌ죬»¹ÊÇÔÚ×öÄǸöÏîÄ¿£¬ÒÀȻʹÓÃÍù³£µÄsqlhelperÓ÷¨£¬Íù³£µÄÊý¾Ý¿â²Ù×÷À࣬µ«ÊÇÆ«Æ«µ÷ÊÔ²»³É¹¦£¬¶øÇÒ×îÖØÒªµÄÊÇ£¬Ëü²»±¨´í
ÖÐÎç³Ô·¹»ØÀ´£¬±¾À´Ïë´òËã˯¸öÎç¾õµÄ£¬µ«ÊÇÏîÄ¿Ì«½ôÆÈÁË£¬ÓÚÊÇÓÖ¸ú³µ³µÑо¿ÁËÒ»ÖÐÎ磬×îºó£¬·¢ÏÖÈç¹û²»ÓÃ@²ÎÊý´«µÝµÄ»°£¬ÊÇÕý³£ÔËÐеģ¬ÓÚÊÇ°Ù¶ÈÁËһϣ¬ÄÇЩÈË˵ҪÓÓ£¿”µ±Õ¼Î»·û
......

asp´ÓÊý¾Ý¿âÖÐÊä³öµÄ¶«Î÷»»ÐÐ

 <%  
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from 0791idc_News where BigClassName='¼Ò×°¿ÎÌÃ' order by ID desc"
rs.Open sql,Conn,1,1
if rs.eof and rs.bof then
  response.Write("ÔÝʱûÓмǼ")
else
%>
         ......

¹ØÓÚAccessºÍExcelµÄÁ¬½Ó×Ö·û´®

1.Á¬½ÓAccessµÄÁ¬½Ó×Ö·û´®
string strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @FileName;
2.Á¬½ÓExcel
string strExcel = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + @FileName + ";Extended Properties=Excel 8.0;"; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ