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,&
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
mdb.OleFunction("Create", ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......