Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Access Insert Óï·¨´íÎ󣡣¡£¡£¡£¡£¡£¡£¡

²ÎÕÕSQLHelperдµÄÒ»¸öOleDdHelperÀà
C# code:

public class OleDbHelper
{
//»ñÈ¡Êý¾Ý¿âÁ´½Ó×Ö·û´®£¬ÆäÊôÓÚ¾²Ì¬±äÁ¿ÇÒÖ»¶Á£¬ÏîÄ¿ÖеÄËùÓÐÎĵµ¶¼¿ÉÒÔÖ±½ÓʹÓ㬵«²»¿ÉÒÔÐ޸ġ£
public static readonly string ConnectionStringLocalTransaction = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

// ¹þÏ£±íÓÃÀ´´æ´¢»º´æµÄ²ÎÊýÐÅÏ¢£¬¹þÏ£±í¿ÉÒÔ´æ´¢ÈÎÒâÀàÐ͵IJÎÊý¡£
private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

public OleDbHelper()
{
//
//TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
//
}

/// <summary>
/// Ö´ÐÐÒ»¸ö²»ÐèÒª·µ»ØÖµµÄSqlCommandÃüÁͨ¹ýÖ¸¶¨×¨ÓõÄÁ¬½Ó×Ö·û´®¡£
/// ʹÓòÎÊýÊý×éÐÎʽÌṩ²ÎÊýÁбí
/// </summary>
/// <remarks>
/// ʹÓÃʾÀý£º
/// int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
/// </remarks>
/// <param name="connectionString">Ò»¸öÓÐЧµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®</param>
/// <param name="cmdType">SqlCommandÃüÁîÀàÐÍ (´æ´¢¹ý³Ì£¬ T-SQLÓï¾ä£¬ µÈµÈ¡£)</param>
/// <param name="cmdText">´æ´¢¹ý³ÌµÄÃû×Ö»òÕß T-SQL Óï¾ä</param>
/// <param name="commandParameters">ÒÔÊý×éÐÎʽÌṩSqlCommandÃüÁîÖÐÓõ


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......

ACCESSÎı¾¿ò³¤¶ÈÊǶàÉÙ? - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿

²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û

ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......

ÈçºÎÐÞ¸ÄACCESSϵͳ±í

ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É

²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£

ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...

лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ