求高手帮忙给下面的方法写上详细注释，最好是每一行写一个，30分辛苦费双手奉上
using System.Data.OleDb;
using System.Collections;

using System.Data.SqlClient;
using System.Data.Sql;

/// <summary>
/// Summary description for OleDbHelper
/// </summary>
public class OleDbHelper
{


public static string strConnection
{
get
{
if(!Common.IsEnglish)
{
return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(Common.ChinesedbPath);

}
else
return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(Common.EnglishdbPath);
}
}



private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

#region ExecuteNonQuery

public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{

OleDbCommand cmd = new OleDbCommand();

using (OleDbConnection conn = new OleDbConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val;
try
{
val = cmd.ExecuteNonQuery();
}
finally
{
cmd.Parameters.Clear();
conn.Close();
}
return val;
}
}


public static int ExecuteNonQuery(CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{
OleDbCommand cmd = new OleDbCommand();

using (OleDbConnection conn = new OleDbConnection(strConnection))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
int val;
try
{
val = cmd.ExecuteNonQuery();
}
finally
{
cmd.Parameters.Clear();
conn.Close();
}
return val;
}
}


public static int ExecuteNonQuery(string cmdText, params OleDbParameter[] commandParameters)
{

OleDbCommand cmd = new OleDbCommand();

using (OleDbConnection conn = new OleDbConnection(strConnection))
{
PrepareCommand(cmd, conn, null, CommandType.StoredProcedure, cmdText, commandParameters);
int val;
try
{
val = cmd.ExecuteNonQuery();
}
finally
{
cmd.Parameters.Clear();
conn.Close();
}
return val;
}
}

public static int ExecuteNonQuery(OleDbConnection connection, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{

OleDbCommand cmd = new OleDbCommand();

PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
int val;
try
{
val = cmd.ExecuteNonQuery();
}
finally
{

cmd.Parameters.Clear();
connection.Close();
}
return val;
}
#endregion

#region ExecuteReader
public static OleDbDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbDataReader rdr;
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
finally
{
cmd.Parameters.Clear();
}
return rdr;
}


public static OleDbDataReader ExecuteReader(CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(strConnection);
OleDbDataReader rdr;
try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
finally
{
cmd.Parameters.Clear();
}
return rdr;
}


public static OleDbDataReader ExecuteReader(string cmdText, params OleDbParameter[] commandParameters)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(strConnection);
OleDbDataReader rdr;
try
{
PrepareCommand(cmd, conn, null, CommandType.StoredProcedure, cmdText, commandParameters);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
finally
{
cmd.Parameters.Clear();
//conn.Close();
}
return rdr;
}
#endregion

[解决办法]

C# code

using System.Data.OleDb;using System.Collections;using System.Data.SqlClient;using System.Data.Sql;public class OleDbHelper{    /// <summary>    /// 得到数据库连接字符串    /// </summary>    public static string strConnection    {        get        {            if (!Common.IsEnglish)//判断Common.IsEnglish得到不同的字符串            {                return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(Common.ChinesedbPath);            }            else                return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(Common.EnglishdbPath);        }    }    //定义一个哈希表    private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());    //执行一个SQL命令    public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        using (OleDbConnection conn = new OleDbConnection(connectionString))        {            PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);            int val;            try            {                val = cmd.ExecuteNonQuery();            }            finally            {                cmd.Parameters.Clear();                conn.Close();            }            return val;        }    }    //这个方法和上面的方法差不多，上面的connectionString是参数，这个方法的connectionString是公共变量    public static int ExecuteNonQuery(CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        using (OleDbConnection conn = new OleDbConnection(strConnection))        {            PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);            int val;            try            {                val = cmd.ExecuteNonQuery();            }            finally            {                cmd.Parameters.Clear();                conn.Close();            }            return val;        }    }    public static int ExecuteNonQuery(string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        using (OleDbConnection conn = new OleDbConnection(strConnection))        {            PrepareCommand(cmd, conn, null, CommandType.StoredProcedure, cmdText, commandParameters);            int val;            try            {                val = cmd.ExecuteNonQuery();            }            finally            {                cmd.Parameters.Clear();                conn.Close();            }            return val;        }    }    public static int ExecuteNonQuery(OleDbConnection connection, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);        int val;        try        {            val = cmd.ExecuteNonQuery();        }        finally        {            cmd.Parameters.Clear();            connection.Close();        }        return val;    }    public static OleDbDataReader ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        OleDbConnection conn = new OleDbConnection(connectionString);        OleDbDataReader rdr;        try        {            PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);            rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);        }        finally        {            cmd.Parameters.Clear();        }        return rdr;    }    public static OleDbDataReader ExecuteReader(CommandType cmdType, string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        OleDbConnection conn = new OleDbConnection(strConnection);        OleDbDataReader rdr;        try        {            PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);            rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);        }        finally        {            cmd.Parameters.Clear();        }        return rdr;    }    public static OleDbDataReader ExecuteReader(string cmdText, params OleDbParameter[] commandParameters)    {        OleDbCommand cmd = new OleDbCommand();        OleDbConnection conn = new OleDbConnection(strConnection);        OleDbDataReader rdr;        try        {            PrepareCommand(cmd, conn, null, CommandType.StoredProcedure, cmdText, commandParameters);            rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);        }        finally        {            cmd.Parameters.Clear();        }        return rdr;    }}