Á¬½ÓACCESSÓÐ´í£¿
´úÂ룺Dim ConnStr
connstr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=c:\a\xueziArticle.mdb;"
Const sCacheName="NB743969143"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnStr
-------------------------------------------------------------------------------------
IE´íÎóÌáʾ£º´íÎóÀàÐÍ£º
ADODB.Connection (0x800A0E78)
¶ÔÏ󹨱Õʱ£¬²»ÔÊÐí²Ù×÷¡£
/a/Include/Function.asp, µÚ 612 ÐÐ
ä¯ÀÀÆ÷ÀàÐÍ£º
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
ÍøÒ³£º
GET /a/index.asp
---------------------------------------------------------------------
²é¿´Include/Function.aspµÄ µÚ 612 ÐÐÊÇÕâ¾ä£ºSet Rs=Conn.Execute(SQL)
ûÈ˰¡£¿
<%
dim db,conn,connstr
db="Êý¾Ý¿â·¾¶"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open connstr
%>
½á¹û»¹ÊÇÒ»ÑùµÄ£¬Ôõô¿´ÎÒÓÐûÓÐ×°OLEDBÇý¶¯°¡
×öÅжϰÉ
VBScript code:
dim db,conn,connstr
db="Êý¾Ý¿â·¾¶"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microso
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
C# code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace DAL
{
public class DBHelp
{
......
ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a table b
¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
Èç: ta ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......