谁给个.net2005+access的例子

Question

别告诉我自己上网上找  有了是 。。   找到就不上这上发了或给我贴些代码在web.config里的连接字符串还有就是从open数据库到读取完代码详细点  谢谢例子发[email protected]里  3Q

Answer 1

OleDbConnection con=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=access路径");//路径可用server.mapPath来变为物理路径
OledbDataAdapter da=new OledbDataAdapter("select * from 表",cn);
DataSet ds=new DataSet();
da.Fill(ds);

Answer 2

<appSettings>
<add key="SQLConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/admin/backpages/DBDB/DataBase.mdb"/>
<!--设置system目录的相对路径,请相对于web.config文件所在的目录(3.1.8版修改的全局设置)-->
<add key="systemfolder" value="system_dntb/"/>
<!--设置皮肤目录的相对路径,请相对于system目录(3.1.8版修改的全局设置)-->
<add key="skin" value="skin/default/"/>
</appSettings>

Answer 3

ado.net 数据库操作 dbhelper
连接字符串成
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>  
public static OleDbDataReader ExecuteReader(string strSQL)   
  {   
  OleDbConnection connection = new OleDbConnection(connectionString);   
  OleDbCommand cmd = new OleDbCommand(strSQL, connection);   
  try   
  {   
  connection.Open();   
  OleDbDataReader myReader = cmd.ExecuteReader();   
  return myReader;   
  }   
  catch (System.Data.OleDb.OleDbException e)   
  {   
  throw new Exception(e.Message);   
  }   
    
  }   

Answer 4

using System;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Configuration;
namespace COM.LXJ.Database
{
    /// <summary>
    /// conn 的摘要说明。
    /// </summary>
    public class ConnDbForAcccess
    {
        /// <summary>
        /// 连接数据库字符串
        /// </summary>
        private string connectionString;        /// <summary>
        /// 存储数据库连接（保护类，只有由他派生的类才能访问）
        /// </summary>
        protected OleDbConnection Connection;        /// <summary>
        /// 构造函数：数据库的默认连接
        /// </summary>
        public ConnDbForAcccess()
        {
            string connStr;
            connStr = System.Configuration.ConfigurationSettings.AppSettings["SQLConnString"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationSettings.AppSettings["dbPath"]) + ";";
            //connStr =ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
            //connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString(); //从web.config配置中读取
            connectionString = connStr;
            //connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + connStr;
            // connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
            //
            Connection = new OleDbConnection(connectionString);
        }        /// <summary>
        /// 构造函数：带有参数的数据库连接
        /// </summary>
        /// <param name="newConnectionString"></param>
        public ConnDbForAcccess(string newConnectionString)
        {
            //connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + newConnectionString;
            connectionString = newConnectionString;
            Connection = new OleDbConnection(connectionString);
        }        /// <summary>
        /// 获得连接字符串
        /// </summary>
        public string ConnectionString
        {
            get
            {
                return connectionString;
            }
        }
        /// <summary>
        /// 执行SQL语句没有返回结果，如：执行删除、更新、插入等操作
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>操作成功标志</returns>
        public bool ExeSQL(string strSQL)
        {
            bool resultState = false;
            Connection.Open();
            OleDbTransaction myTrans = Connection.BeginTransaction();
            OleDbCommand command = new OleDbCommand(strSQL, Connection, myTrans);            try
            {
                command.ExecuteNonQuery();
                myTrans.Commit();
                resultState = true;
            }
            catch
            {
                myTrans.Rollback();
                resultState = false;
            }
            finally
            {
                Connection.Close();
            }
            return resultState;
        }        /// <summary>
        /// 执行SQL语句返回结果到DataReader中
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>dataReader</returns>
        public OleDbDataReader ReturnDataReader(string strSQL)
        {
            Connection.Open();
            OleDbCommand command = new OleDbCommand(strSQL, Connection);
            OleDbDataReader dataReader = command.ExecuteReader();
            Connection.Close();            return dataReader;
        }        /// <summary>
        /// 执行SQL语句返回结果到DataSet中
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>DataSet</returns>
        public DataSet ReturnDataSet(string strSQL)
        {
            Connection.Open();
            DataSet dataSet = new DataSet();
            OleDbDataAdapter OleDbDA = new OleDbDataAdapter(strSQL, Connection);
            OleDbDA.Fill(dataSet, "objDataSet");
            Connection.Close();            return dataSet;
        }        /// <summary>
        /// 执行一查询语句，同时返回查询结果数目
        /// </summary>
        /// <param name="strSQL"></param>
        /// <returns>sqlResultCount</returns>
        public int ReturnSqlResultCount(string strSQL)
        {
            int sqlResultCount = 0;            try
            {
                Connection.Open();
                OleDbCommand command = new OleDbCommand(strSQL, Connection);
                OleDbDataReader dataReader = command.ExecuteReader();                while (dataReader.Read())
                {
                    sqlResultCount++;
                }
                dataReader.Close();
            }
            catch
            {
                sqlResultCount = 0;
            }
            finally
            {
                Connection.Close();
            }
            return sqlResultCount;
        }
        //处理替换sql中的特殊字符
        public string ReplaceChar(string strChar) 
        {
            return this.ReplaceString(strChar,"");
        }
        public string ReplaceString(String strChar, String strReplace)
        {
            string newChar = "";
            if (strChar == null)
            {
                newChar = strReplace;
            }
            else if (strChar == "")
            {
                newChar = strReplace;
            }
            else
            {
                newChar = strChar.Replace("'", "&#39;").Replace("\r\n", "");
            }
            return newChar;
        }
        public string ReplaceChar(string strChar, Boolean bol)
        {
            String newChars = "";
            if (bol == true)
            {
                newChars = this.ReplaceString(strChar,"必填");
            }
            else
            {
                 newChars = this.ReplaceChar(strChar);
            }
            return newChars;
        }
    }//
}//

Answer 5

很简单添加个.DLL文件把ADO.NET的里面的如SQLCOMMAND的SQL改为OleDb