c#²Ù×÷access*תÔØ

 
 
public static class AccessHelper
{
//Êý¾Ý¿âÁ¬½Ó×Ö·û´®
//WebForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//WinForm
//public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
//public static readonly string conn_str = System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString;
public static readonly string conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + System.Configuration.ConfigurationManager.ConnectionStrings["WZDFGL"].ConnectionString + ";Persist Security Info=True";
// ÓÃÓÚ»º´æ²ÎÊýµÄHASH±í
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());
/// <summary>
/// ¸ø¶¨Á¬½ÓµÄÊý¾Ý¿âÓüÙÉè²ÎÊýÖ´ÐÐÒ»¸ösqlÃüÁ²»·µ»ØÊý¾Ý¼¯£©
/// </summary>
/// <param name="connectionString">Ò»¸öÓÐЧµÄÁ¬½Ó×Ö·û´®</param>
/// <param name="commandText">´æ´¢¹ý³ÌÃû³Æ»òÕßsqlÃüÁîÓï¾ä</param>
/// <param name="commandParameters">Ö´ÐÐÃüÁîËùÓòÎÊýµÄ¼¯ºÏ</param>
/// <returns>Ö´ÐÐÃüÁîËùÓ°ÏìµÄÐÐÊý</returns>
public static int ExecuteNonQuery(string connectionString, string cmdText, params OleDbParameter[] commandParameters)
{
OleDbCommand cmd = new OleDbCommand();
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdText, commandParameters);
int val = cmd.ExecuteNonQuery();