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

VC+OLEDB+ACCESS£¬´æÊý¾Ýʱ£¬Áгö´í

    VC.net2005+OLEDB+ACCESS£¬ÔÚ³ÌÐòÖж¯Ì¬´´½¨±í¸ñ£¬±í¸ñ×ֶμ°ÆäÊôÐÔÈçÏ£º
   
    CREATE TABLE YuanMuInfo (YuanMuInfoID INT,CaiFaNum NVARCHAR(7),TongZhiNum NVARCHAR(7),CheNum NVARCHAR(7),MuTouType NVARCHAR(4),MuTouNum INT,MuTouNum2 INT,CaiChang REAL,JianChiJing REAL,CaiJi REAL,bManual INT,Photo IMAGE)
    ÔÚ´æÊý¾Ý¿âʱ£¬MuTouNumʵ¼Ê´æµÄÖµÊÇMuTouNum2µÄÖµ£¬¶øMuTouNum2È´±»ÉèÖÃΪ0£¬
    ÈôûÌí¼ÓMuTouNum2×ֶΣ¬ÔòºóÃæµÄCaiChang×ֶεÄÖµ¾Í×Ô¶¯±»ÉèΪ0£¬
    ÊDz»Êǰó¶¨Ê±ÁÐ¶ÔÆë³ö´í£¬»¹ÊÇÆäËûÔ­ÒòÄØ£¿ 
ACCESSÖÐÓÐÄãÁгöµÄÕâЩ×Ö¶ÎÀàÐÍÂ𣿣¿£¿

    Õâ¸öµ¹Ã»Á˽â¹ý£¬Ö»ÊDZí¸ñ¶¯Ì¬´´½¨³É¹¦£¬¶øÇÒ¸÷¸ö×ֶζ¼ÓÐ

ÄÇÄÜ˵˵´´½¨ºó¸÷¸ö×ֶζ¼ÊÇʲôÀàÐ͵Äô£¿ÔÚACCESSÖп´µ½µÄ¡£
ÄãÕâ¸öSQLÓï¾äÊÇ´ÓÆäËüµØ·½°áÀ´µÄô£¿

  ÊÇ´ÓÆäËûµØ·½°á¹ýÀ´µÄ
  CREATE TABLE YuanMuInfo (
    YuanMuInfoID INT,      //intÀàÐÍ
    CaiFaNum NVARCHAR(7),  //Unicode×Ö·û´®£¬ÀàËÆWCHAR[7]
    TongZhiNum NVARCHAR(7), //Unicode×Ö·û´®£¬ÀàËÆWCHAR[7]
    CheNum NVARCHAR(7),    //Unicode×Ö·û´®£¬ÀàËÆWCHAR[7]
    MuTouType NVARCHAR(4),  //Unicode×Ö·û´®£¬ÀàËÆWCHAR[4]
    MuTouNum INT,          //intÀàÐÍ
    MuTouNum2 INT,          //intÀàÐÍ
    CaiChang REAL,&


Ïà¹ØÎÊ´ð£º

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......

´´½¨ACCESSÎļþµ÷ÓÃOLEFUNCTIONʱ²úÉú´íÎó£¬ÔÚÏßÇóÖú

ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
  mdb.OleFunction("Create", ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ