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

accessºê²Ù×÷

´ò¿ª    OpenDataAccessPage:ÔÚÒ³ÊÓͼ»òÉè¼ÆÊÓͼÖдò¿ªÊý¾Ý·ÃÎÊÒ³
OpenForm:ÔÚ´°ÌåÊÓͼ¡¢´°ÌåÉè¼ÆÊÓͼ¡¢´òÓ¡Ô¤ÀÀ»òÊý¾Ý±íÊÓͼÖдò¿ª´°Ìå
OpenModule:ÔÚÖ¸¶¨¹ý³ÌµÄÉè¼ÆÊÓͼÖдò¿ªÖ¸¶¨µÄÄ£¿é
OpenQuery:´ò¿ªÑ¡Ôñ²éѯ»ò½»²æ±í²éѯ
OpenReport:ÔÚÉè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÊÓͼÖдò¿ª±¨±í»òÁ¢¼´´òÓ¡¸Ã±¨±í
OpenTable:ÔÚÊý¾Ý±íÊÓͼ¡¢Éè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÖдò¿ª±í
²éÕÒ¡¢É¸Ñ¡¼Ç¼ ApplyFilter£º¶Ô±í¡¢´°Ìå»ò±¨±íÓ¦ÓÃɸѡ¡¢²éѯ»òSQLµÄWHERE×Ӿ䣬ÒÔ±ãÏÞÖÆ»òÅÅÐò±íµÄ¼Ç¼£¬ÒÔ¼°´°Ìå»ò±¨±íµÄ»ù´¡±í£¬»ò»ù´¡²éѯÖеļǼ
FindNext£º²éÕÒ·ûºÏ×î½üFindRecord²Ù×÷»ò“²éÕÒ”¶Ô»°¿òÖÐÖ¸¶¨Ìõ¼þµÄÏÂÒ»Ìõ¼Ç¼
FindRecord£ºÔڻµÄÊý¾Ý±í¡¢²éѯÊý¾Ý±í¡¢´°ÌåÊý¾Ý±í»ò´°ÌåÖУ¬²éÕÒ·ûºÏÌõ¼þµÄ¼Ç¼
GoToRecord£ºÔÚ´ò¿ªµÄ±í¡¢´°Ìå»ò²éѯ½á¹û¼¯ÖÐÖ¸¶¨µ±Ç°¼Ç¼
ShowAllRecords£ºÉ¾³ý»î¶¯±í¡¢²éѯ½á¹û¼¯»ò´°ÌåÖÐÒÑÓ¦ÓùýµÄɸѡ
½¹µã GoToControl£º½«½¹µãÒƶ¯µ½´ò¿ªµÄ´°Ìå¡¢´°ÌåÊý¾Ý±í¡¢±íÊý¾Ý±í»ò²éѯÊý¾Ý±íÖеÄ×ֶλò¿Ø¼þÉÏ
GoToPage£ºÔڻ´°ÌåÖУ¬½«½¹µãÒƵ½Ö¸¶¨Ò³µÄµÚÒ»¸ö¿Ø¼þÉÏ
SelectObject£ºÑ¡¶¨Êý¾Ý¿â¶ÔÏó
ÉèÖÃÖµ SendKeys£º½«¼ü·¢Ë͵½¼üÅÌ»º³åÇø
SetValue£ºÎª´°Ìå¡¢´°ÌåÊý¾Ý±í»ò±¨±íÉϵĿؼþ¡¢×Ö¶ÎÉèÖÃÊôÐÔÖµ
¸üРRepaintObjet£ºÍê³ÉÖ¸¶¨µÄÊý¾Ý¿â¶ÔÏóËù¹ÒÆðµÄÆÁÄ»¸üУ¬»ò¶Ô»î¶¯Êý¾Ý¿â¶ÔÏó½øÐÐÆÁÄ»¸üС£ÕâÖÖ¸üаüÀ¨¿Ø¼þµÄÖØÐÂÉè¼ÆºÍÖØлæÖÆ
Requery£ºÍ¨¹ýÖØвéѯ¿Ø¼þµÄÊý¾ÝÔ´£¬À´¸üл¶ÔÏó¿Ø¼þÖеÄÊý¾Ý¡£Èç¹û²»Ö¸¶¨¿Ø¼þ£¬½«¶Ô¶ÔÏó±¾ÉíµÄÊý¾ÝÔ´ÖØвéѯ¡£¸Ã²Ù×÷È·±£»î¶¯¶ÔÏó¼°Æä°üº¬µÄ¿Ø¼þÏÔʾ×îÐÂÊý¾Ý
´òÓ¡ PrintOut£º´òÓ¡»î¶¯µÄÊý¾Ý±í¡¢´°Ìå¡¢±¨±í¡¢Ä£¿éÊý¾Ý·ÃÎÊÒ³ºÍÄ£¿é£¬Ð§¹ûÓëÎļþ²Ëµ¥ÖеĴòÓ¡ÃüÁîÏàËÆ£¬µ«ÊDz»ÏÔʾ´òÓ¡¶Ô»°¿ò
¿ØÖÆ CancelEvent£ºÈ¡ÏûÒýÆð¸ÃºêÖ´ÐеÄʼþ
RunApp£ºÆô¶¯ÁíÒ»¸öWindows»òMS-DOSÓ¦ÓóÌÐò
RunCode£ºµ÷ÓÃVisual Basic Function¹ý³Ì
RunCommand£ºÖ´ÐÐAccess²Ëµ¥À¸¡¢¹¤¾ßÀ¸»ò¿ì½Ý²Ëµ¥ÖеÄÄÚÖÃÃüÁî
RunMacro£ºÖ´ÐÐÒ»¸öºê
RunSQL£ºÖ´ÐÐÖ¸¶¨µÄSQLÓï¾äÒÔÍê³É²Ù×÷²éѯ£¬Ò²¿ÉÒÔÍê³ÉÊý¾Ý¶¨Òå²éѯ
StopAllMacros£ºÖÕÖ¹µ±Ç°ËùÓкêµÄÔËÐÐ
StopMacro£ºÖÕÖ¹µ±Ç°ÕýÔÚÔËÐеĺê
´°¿Ú Maximize£º·Å´ó»î¶¯´°¿Ú£¬Ê¹Æä³äÂúAccessÖ÷´°¿Ú¡£¸Ã²Ù×÷²»ÄÜÓ¦ÓÃÓÚVisual Basic±à¼­Æ÷ÖеĴúÂë´°¿Ú
Minimize£º½«»î¶¯´°¿ÚËõСΪAccessÖ÷´°¿Úµ×²¿µÄС±êÌâÀ¸¡£¸Ã²Ù×÷²»ÄÜÓ¦ÓÃÓÚVis


Ïà¹ØÎĵµ£º

¼Ü¹¹B/SËÄ DALFactory Êý¾Ý·ÃÎʲã Data Access Layer

2008-04-10 09:45 //*******FactoryManage.cs using System;
using System.Reflection;
using System.Configuration;
using CoalTraffic.IDAL; namespace CoalTraffic.DALFactory
{
    /// <summary>
    /// ³éÏ󹤳§Ä£Ê½´´½¨DAL¡£
   ......

Data Access Application Block

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Common;
us ......

ACCESSÖлñÈ¡ËùÓÐ×é¼þ´úÂë

 Private Sub cmdListProperties_Click()
    ListControlProps Me
End Sub
Public Sub ListControlProps(ByRef frm As Form)
    Dim ctl As Control
    Dim prp As Property
    On Error GoTo props_err
    For Each ctl In ......

AccessÖÐ"ÊÇ/·ñ"Êý¾ÝÀàÐÍÊÇÔõÑù´¦ÀíµÄ

¼ÙÉèNews±íÖÐÓÐÒ»¸öÊôÐÔPassed£¬Êý¾ÝÀàÐÍÊÇ“ÊÇ/·ñ“
1,¶Á²Ù×÷£ºstring str="select * from News where Passed=True";(access)¶Á“ÊÇ“²Ù×÷¡£
string str="select * from News where Passed=False";(access)¶Á“·ñ“²Ù×÷¡£
2,д²Ù×÷£º
string str="Delete from News wher ......

ºÜÍ·ÌÛµÄACCESS²éѯÎÊÌ⣡

ÔÚACCESS(2007)Êý¾Ý¿âÖУ¬ÓÐÕâÑùÒ»¸öÄ£ºý²éѯ£¬ 
select postId,postName,postType,left(postTime,10) as postTimes from PostInfo where postUser like '*ÖÜ·¼*'
ÔÚÊý¾Ý¿â²éѯºó½á¹ûÏÔʾÕýÈ·£¬¿ÉÊÇ·ÅÔÚÏîÄ¿µÄ´úÂëÖУ¬¾ÓÈ»²»ÏÔʾ²éѯµÄ½á¹û¿©¡£¼ì²éÁË°ëÌ춼ûÓз¢ÏÖ´íÎóÔÚÄÄÀ×îºó²ÅÖªµÀ£¬ÓеÄACCESS¾ÓÈ»²»ÈÏʶͨŠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ