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

Access×Ö·û´®´¦Àíº¯Êý

 1.Asc     
˵Ã÷:·µ»Ø×ÖĸµÄAcsiiÖµ
¾ÙÀý:select Asc("A")·µ»Ø65
2.Chr     
˵Ã÷:½«asciiֵת»»µ½×Ö·û
¾ÙÀý:select chr(65)·µ»Ø"A"
3.Format
˵Ã÷:¸ñʽ»¯×Ö·û´®
¾ÙÀý:Select Format(now(),"yyyy-mm-dd")·µ»ØÀàËÆÓÚ"2008-04-03"
     Select Format(3/9,"0.00")·µ»Ø0.33
4.InStr   
˵Ã÷:²éѯ×Ó´®ÔÚ×Ö·û´®ÖеĵÚÒ»¸ö³öÏÖµÄλÖÃ,ûÓзµ»Ø0
¾ÙÀý:select Instr("abc","a") ·µ»Ø1
5.LCase    
˵Ã÷:·µ»Ø×Ö·û´®µÄСдÐÎʽ
¾ÙÀý:select LCase("ABC") ·µ»Ø"abc"
6.Left    
˵Ã÷:×ó½ØÈ¡×Ö·û´®
¾ÙÀý:select Left("ABC",1) ·µ»Ø"A"
7.Len   
˵Ã÷:·µ»Ø×Ö·û´®³¤¶È
¾ÙÀý:select Len("ABCÄãºÃ")·µ»Ø5
8.LTrim   
˵Ã÷:×ó½ØÈ¡¿Õ¸ñ
¾ÙÀý:select LTrim(" 111") ·µ»Ø"111"
9.Mid
˵Ã÷:È¡µÃ×Ó×Ö·û´®
¾ÙÀý:select mid("abcd",1,2) ·µ»Ø"ab"
10.Right   
˵Ã÷:ÓÒ½ØÈ¡×Ö·û´®
¾ÙÀý:select Right("ABC",1) ·µ»Ø"C"
11.RTrim   
˵Ã÷:ÓÒ½ØÈ¡¿Õ¸ñ
¾ÙÀý:select Right("ABC ") ·µ»Ø"ABC"
12.Space
˵Ã÷:²úÉú¿Õ¸ñ
¾ÙÀý:select Space(5) ·µ»Ø5¸ö¿Õ¸ñ
13.StrComp
˵Ã÷:±È½ÏÁ½¸ö×Ö·û´®ÊÇ·ñÄÚÈÝÒ»ÖÂ(²»Çø·Ö´óСд)
¾ÙÀý:select StrComp("abc","ABC")·µ»Ø0
     select StrComp("abc","123")·µ»Ø-1
14.Trim    
˵Ã÷:½ØÈ¡×Ö·û´®Á½Í·µÄ¿Õ¸ñ
¾ÙÀý:select Trim(" ABC ") ·µ»Ø"ABC"
15.UCase   
˵Ã÷:½«×Ö·û´®×ª´óд
¾ÙÀý:select UCase("abc") ·µ»Ø"ABC"   


Ïà¹ØÎĵµ£º

C#¶ÁÈ¡access±í£¬²¢°ÑÊý¾ÝÏÔʾÔÚgridcontrolÖÐ

 //¶ÁÈ¡±ê×¼Áбí
        private void setModelList()
        {
            OleDbConnection Connection = null;
         &n ......

Access Code + Fingerprint Door Lock

Double action
fingerprint
and access code security door lock for your home,
office or small business. Get modern biometric security at your entry point with
this standard door handle style double action doorlock.
This is the most secure and convenient method in assuring only authorized peo ......

·¢Ò»¸öǰһ¶Îʱ¼äдµÄС¹¤¾ßVC+Access(¸½Ô´´úÂë)


´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ­¡£
ÏÂÔØµØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......

JSPÁ¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥´úÂë

Á¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥JSP´úÂ룺
  <%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
String url="jdbc:odbc:Driver={MicroSoft Access Drive ......

VC/MFCÖеÄACCESSÊý¾Ý¿â·ÃÎÊʵÏÖ(·½·¨2)

½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ