Á¬½Ó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 ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
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
{
......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......
date="'"+dtime+","+save[i,0].ToString()+","+save[i,1].ToString()+","+save[i,2].ToString()+","+save[i,3].ToString()+","+save[i,4].ToS ......