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ÃüÁîÖÐÓõ
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
delphi 2007 + access 2007 +odbc +TADODataset,TADOConnection,TADOCommand
//ɾ³ýÊý¾Ý
procedure TCDSSelectTools.DeleteMachine(byMachineID: string);
tmpCmd := TADOCommand.Create(ni ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É
²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£
ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...
лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......