¶ÁÈ¡Êý¾Ý¿âAccessÖÐOLE×ֶεÄÒ»Ìõ¼Ç¼£¨wordÎļþ£©Ê±£¬»áÉú³ÉÒ»¸öwordÎļþ¡£Òª¶ÁÈ¡ÏÂÒ»Ìõ¼Ç¼£¬±ØÐëÏÈÓÃÏÂÃæµÄ´úÂ룺
Kill App.Path & "\ÌâÄ¿.doc"
ɾ³ýwordÎļþ£¬·ñÔò¶Áȡʧ°Ü£¬ÕâÑùºÜ²»·½±ã£¬ÓÐûÓн⾠......
ÈçºÎ½«oracleÖÐblob µ¼Èëµ½accessÖУ¿
accessÖÐûÓÐblob×ֶΣ¬¸ÃÓÃʲôÀàÐÍ£¿
ÎÒoracleÖеÄblob×Ö¶ÎÊÇͼƬ
ÎÒÏÖÔÚÊÇÓÃpowerbuilerÓà selectblob È¡³ö£¬ÔÙupdateblobµ½accessÖУ¬¶¼Ã»Óгö´í¡£µ«ÊÇ´ÓaccessÖÐÈ¡³öÀ´µÄÎÞ·¨ÏÔʾͼƬ£¿{{ ......
AccessÖÐÓиö±íΪA£¬SQLÖÐÒ²ÓÐÒ»¸ö±íΪA¡£ÏÖÔÚÒªÔÚAccessÖиüÐÂSQLÖеıíA
update A as C,A in [ODBC][ODBC;Driver=SQL Server;Server=XX;Uid=XX;Pwd=XX;database=XX]
set
A.CustomerName=C.CustomerName,
A.MobilePhone=C.MobilePhone
where C.ID=A.ID
ÕâÑùÊDz»Ðеġ£µ«ÈçºÎÄÜÈôÎʵÏÖ£¬Ð ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ON UPDATE CASCADE)
·¢ÉúÔ¼Êø´íÎó
µ«ÊÇ
CREATE TABLE Product(model integer,
maker varchar(2 ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
textbox ¿Ø¼þ±¾ÉíÓ¦¸ÃûÓÐÏÞÖÆ£¬¹À¼Æ ......
´úÂëÈçÏ£º
OleDbDataAdapter da = new OleDbDataAdapter("Select * from Grade", objConnection);
DataSet ds = new DataSet();
DataTable myDataTable = ds.Tables["Grade"];
da.Fill(ds,"Grade");
foreach (DataRow myDataRow in myDataTable.Rows)
{ ......