asp.netÁ´½ÓAccessÊý¾Ý¿â×Ö·û´®ÕýÈ··½·¨
ÔÚweb configÖÐ ×÷ÈçÏÂÅäÖãº
<connectionStrings>
<add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó×Ö·û´®£º
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient; //Ìí¼ÓÒýÓÃ
using System.Text;
using System.IO;
using System.Collections;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// string ConStr = "Server=(./SQLEXPRESS);DataBase=|Datadrictory|db_17.mdf;Uid=;Pwd=";
string cmdtxt = "SELECT * from tb_13";
OleDbConnection Con = new OleDbConnection(System.Configuration .ConfigurationManager.ConnectionStrings ["ydycon"].ToString() );
//OleDbConnection Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ydy.mdb"));
// SqlConnection Con = new SqlConnection(ConStr);
Con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(cmdtxt, Con);
// SqlDataAdapter da = new SqlDataAdapter(cmdtxt, Co
Ïà¹ØÎĵµ£º
set safety off
local oo,lcStr,lcMdbFile,i,x,lnFields,lcTableName,lnFieldtype,lcCurdir
lcCurdir = sys(5) + curdir()
lcNowdir = getdir()
cd (lcNowdir)
&nb ......
ýÌå½ÓÈë¿ØÖÆ²ãµÄËõд
ʲôÊÇmac!!!
Èç¹ûÄãÊÇͨ¹ýÐ£Ô°Íø»òÐ¡Çø½ÓÈëInternet£¬ÄÇôһ¶¨Ìý˵¹ýMACµØÖ·¡£Ê²Ã´ÊÇMACµØÖ·£¬MACµØÖ·ÔÚÕâÖÖ¾ÖÓòÍø»·¾³Öо¿¾¹Æðµ½Ê²Ã´×÷Óã¿ÏÂÃæ¾ÍÀ´½éÉÜÒ»ÏÂMACµØÖ·µÄ֪ʶ£¬MACµØÖ·ºÍIPµØÖ·µÄÇø±ðÒÔ¼°MACµØÖ·ÔÚʵ¼ÊÓ¦ÓÃÖÐËùÉæ¼°µ½µÄ°²È«ÎÊÌâ¡£
¡¡¡¡Ò»¡¢»ù´¡ÖªÊ¶
¡¡¡¡Èç½ñµÄÍøÂçÊÇ·Ö²ãÀ´Êµ ......
¼´Ê¹ÎÒ½«Êý¾Ý¿â·ÅÔÚÏîÄ¿ÄÚ½¨µÄÎļþ¼ÐdbÏ£¬¿ÉÊǽøÐд洢²Ù×÷µÄʱºò£¬Êý¾Ý±íûÓÐÈκα仯¡£ºóÀ´·¢ÏÖ´¢´æ¸Ä±ä·¢ÉúÔÚbin\\debug\\dbĿ¼ÏµÄÊý¾Ý¿âÖУ¬Õâ¸öÊý¾Ý¿âÊÇÔÚ³ÌÐòÔËÐÐʱ×Ô¶¯¸´ÖƹýÈ¥µÄ£¬¿ÉÊÇΪʲô´æ´¢±ä»¯Ã»Óз´Ó¦µ½ÍâÃæÏîÄ¿ÄÚµÄÊý¾Ý¿âdbÏÂÄØ£¿ÎÒÏëÁ¬½Ó×Ö·û´®ÖÐdatasourceÖеÄdatadirectory´æÔÚһЩÐþ»ú£¬ÓÚÊÇÎÒÕÒµ½Ò ......
¹ÊÕÏÏÖÏó:
Windows 2008 64λϵͳ,aspÍøÒ³·ÃÎÊaccessÊý¾Ý¿â±¨ÈçÏ´íÎó.
Ïà¹Ø´úÂë
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
connstr="provider=microsoft.jet.oledb.4.0;data source="&server.mappath("db/db.mdb")
conn.open connstr
sql="select * fr ......