.netÁ¬½ÓACCESSÊý¾Ý¿âµÄÖúÊÖÀà

 using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
namespace DAL
{
public class OleDbHelper
{
public static OleDbCommand cmd = null;
public static OleDbConnection conn = null;
public static string connstr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source="+ConfigurationManager.AppSettings["DbPath"];
public OleDbHelper()
{ }
#region ½¨Á¢Êý¾Ý¿âÁ¬½Ó¶ÔÏó
/// <summary>
/// ½¨Á¢Êý¾Ý¿âÁ¬½Ó
/// </summary>
/// <returns>·µ»ØÒ»¸öÊý¾Ý¿âµÄÁ¬½ÓOleDbConnection¶ÔÏó</returns>
public static OleDbConnection init()
{
try
{
conn = new OleDbConnection(connstr);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
}
catch (Exception e)
{
throw new Exception(e.Message.ToString());
}
return conn;
}
#endregion
#region ÉèÖÃOleDbCommand¶ÔÏó
/// <summary>
/// ÉèÖÃOleDbCommand¶ÔÏó
/// </summary>
/// <param name="cmd">OleDbCommand¶ÔÏó </param>
/// <param name="cmdText">ÃüÁîÎı¾</param>
/// <param name="cmdType">ÃüÁîÀàÐÍ</param>
/// <param name="cmdParms">²ÎÊý¼¯ºÏ</param>
private static void SetCommand(OleDbCommand cmd, string cmdText, CommandType cmdType, OleDbParameter[] cmdParms)
{
cmd.Connection = conn;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
if (cmdParms != null)
{
cmd.Parameters.AddRange(cmdParms);
}
}
#endregion
#regio