¼¸ÄêǰдµÄÒ»¸ö access ·ÃÎÊÀà dbutils
using System;
using System.Data;
using System.Xml;
using System.Data.OleDb ;
using System.Collections;
namespace ePhoto.AccessDAL
{
/// <summary>
/// DBUtil ²Ù×÷AccessÊý¾Ý¿â
/// </summary>
public class DBUtil
{
private Hashtable parmCache = Hashtable.Synchronized(new Hashtable()); //»º´æÓû§²ÎÊý
private static string path = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
System.Web.HttpContext.Current.Server.MapPath("")+"\\"+System.Configuration.ConfigurationSettings.AppSettings["AccessDataBase"] ; //Access Êý¾Ý¿âÎļþµØÖ·
/// <summary>
/// Ö´Ðе¥Ïò²Ù×÷£¬·µ»ØÊý¾Ý¿âÊÜÓ°ÏìµÄÐÐÊýʹÓÃĬÈÏÁ¬½Ó£¬ Ö´ÐÐSQLÓï¾ä£¬½ö½ö·µ»ØÊý¾Ý¿âÊÜÓ°ÏìÐÐÊý¡£
/// ËùÐè²ÎÊý£ºÃüÁîÎı¾£¬²ÎÊýÁÐ±í¡£
/// </summary>
/// <param name="cmdText">ÃüÁîÎı¾</param>
/// <param name="cmdParms">²ÎÊýÁбí</param>
/// <returns></returns>
public static int ExecuteNonQuery(string cmdText ,params OleDbParameter[] cmdParams)
{
OleDbCommand cmd = new OleDbCommand();
using(OleDbConnection conn = new OleDbConnection(path))
{
PrepareCommand(cmd,conn,null,CommandType.Text,cmdText,cmdParams);
int val = cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Dispose();
return val ;
}
}
/// <summary>
/// Ö´ÐÐÒ»¸ösql²éѯÓï¾ä£¬·µ»ØDataReader¶ÔÏó¡£Ê¹ÓÃĬÈÏÁ¬½Ó¡£
/// ËùÐè²ÎÊý£ºÃüÁîÎı¾£¬²ÎÊýÁÐ±í¡£
/// </summary>
/// <param name="cmdText"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public static OleDbDataReader ExecuteReader(string cmdText,params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(path);
try
{
PrepareCommand(cmd,conn,null,CommandType.Text,cmdText,cmdParms);
OleDbDataReader read = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return read ;
}
Ïà¹ØÎĵµ£º
Ê×ÏÈ´ò¿ªSQL Server Management Studio£¬½¨Á¢Ò»¸öÊý¾Ý¿â£¬½¨Á¢ºÃÊý¾Ý¿âºóÑ¡ÔñÄãµÄÊý¾Ý¿âÃû£¬ÓÒ¼ü--ÈÎÎñ--µ¼ÈëÊý¾Ý¿â
´ò¿ªSQLµ¼ÈëºÍµ¼³öÏòµ¼--ÏÂÒ»²½--Êý¾ÝÔ´Ñ¡Ôñ£¨Microsoft Access£©--Ñ¡ÔñÄãµÄACCESSÊý¾Ý¿âÈ»ºóÏÂÒ»²½
¡¡
¹Ø¼üµÄÒ»²½ÔÚ“Ñ¡ÔñÔ´±íºÍÔ´ÊÓͼ”ÕâÀѡÔñ±í--±à¼Ó³Éä--Ñ¡ ......
ADO(ActiveX Data
Object)ÊÇMicrosoftÊý¾Ý¿âÓ¦ÓóÌÐò¿ª·¢µÄнӿڣ¬Êǽ¨Á¢ÔÚOLE DBÖ®Éϵĸ߲ãÊý¾Ý¿â·ÃÎʼ¼Êõ£¬¼´Ê¹Äã¶ÔOLE
DB£¬COM²»Á˽âÒ²ÄÜÇáËɶԸ¶ADO,ÒòΪËü·Ç³£¼òµ¥Ò×Óã¬ÉõÖÁ±ÈÄãÒÔÍùËù½Ó´¥µÄODBC API¡¢DAO¡¢RDO¶¼ÒªÈÝÒ×ʹÓ㬲¢²»Ê§Áé»îÐÔ¡£
¡¡¡¡ADO(ActiveX Data Object)ÊÇMicrosoftÊý¾Ý¿âÓ¦ÓÃ
³ÌÐò
......
1¡¢Ìí¼ÓADODC1µ½´°Ìå
2¡¢×¼±¸ºÃÒ»¸öACCESSн¨µÄ¿ÕÊý¾Ý¿â66.mdb
Private Sub Form_Load()
With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Documents and Settings\Administrator\" & _
"My Docume ......
¼ò½é£º¡¾IT¶¯Á¦Ô´Ô´´ÎÄÕ¡¿ÈçÓû×ªÔØ£¬Çë×¢Ã÷Ô´´×÷Õߣ¬¼°ÎÄÕ³ö´¦£¨IT¶¯Á¦Ô´£©¡£Î¥Õߣ¬IT¶¯Á¦Ô´½«±£Áô×·¾¿Æä·¨ÂÉÔðÈεÄȨÀû£¡
À´Ô´£ºIT¶¯Á¦Ô´(ItZero.COM)([url]http://www.itzero.com/)[/url]
×÷ÕߣºÑ©Ñæ
ÔÎÄ£º»ªÎª£ºAccess¡¢HybridºÍTrunkÈýÖÖģʽµÄÀí½â([url]http://tech.itzero.com/2006/1105/3520.html)[/url]
Ô ......