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

delphi ͨ¹ýA±íÅúÁ¿¸ü¸ÄB±íµÄÄÚÈÝ

ͨ¹ýExcelµ¼ÈëÄÚÈݵ½±íA£¬²¢ÏÔʾÔÚdbgridÖУ¬µã»÷ÅúÁ¿Ð޸İ´Å¥£¬Í¨¹ýµ¼Èë±íAµÄÄÚÈÝÐ޸ıíB¡£ÏÖÔÚÓÐÒ»¸öÎÊÌ⣬µ¼ÈëµÄÕâÒ»ÅúÄÚÈÝ£¬Èç¹ûÔÚ±íBÖв»´æÔÚ£¬Ôò²åÈ룬Èç¹ûÔÚ±íBÖдæÔÚ£¬Ôò¸üУ¬ÈçºÎʵÏÖ£¿

ÒýÓÃ
--1¡¢²åÈ룺
insert into B
select ×Ö¶Î1,×Ö¶Î2,¡£¡£¡£¡£¡£¡£ from A
where not exists(select 1 from B where A.×Ö¶Î1=B.×Ö¶Î1 and A.×Ö¶Î2=B.×Ö¶Î2¡£¡£¡£¡£¡£¡£)

--2¡¢¸üУº
update B
set B.×Ö¶Î1 = A.×Ö¶Î1, B.×Ö¶Î2 = A.×Ö¶Î2,¡£¡£¡£¡£¡£¡£
from A
where A.×Ö¶Î1 = B.×Ö¶Î1 and A.×Ö¶Î2 = B.×Ö¶Î2¡£¡£¡£¡£¡£¡£


Èç¹ûÕâÅúÃûµ¥ÖУ¬Í¬Ê±´æÔÚ²åÈëºÍ¸üвÙ×÷ÄØ£¿ÊDz»ÊÇÒªÌí¼ÓÅжÏÌõ¼þ£¿Ò»¸öbutton°´Å¥¿ÉÒÔͬʱʵÏÖ²åÈë¸üÐÂÁ½ÖÖ»ìºÏÃûµ¥µÄ²Ù×÷Âð£¿

1¡¢ÎÒдµÄÊÇ SQL Óï¾ä£¬Äã¿ÉÒÔд³É´æ´¢¹ý³Ì

2¡¢Äãµã»÷ Button1£¬Óà AdoQuery1 »òÕß ADOStoredProc1 Ö´ÐÐÕâ¸ö´æ´¢¹ý³Ì£¬Ó¦¸Ã¾ÍÊǶԵģ¬ÄãÔÚǰ̨

²»ÓÃдÌõ¼þ£¬ÎÒÔÚ SQL Óï¾äÖУ¬ÒѾ­´¦ÀíÁË


Ïà¹ØÎÊ´ð£º

DELPHIÕâÖÖÇé¿öÔõô°ì£¿ - Delphi / Windows SDK/API

¾ÍÊÇÒ»¸ö·þÎñ¶ËºÍÒ»¸ö¿Í»§¶Ë£¬Àï±ßÓÐһЩ¹²Óõ¥Ôª £¬ÎÒÔÚ ¹¤³ÌµÄSEARCH PATHÀïÉèÖõÄ·¾¶£¬
Àï±ßÓиö½á¹¹Ì壬ÎÒÔÚ·þÎñ¶Ë´ò¿ª£¬¼ÓÁ˳ÉÔ±£¬µ«ÊÇÎÒÔÚ¿Í»§¶ËÆäËûµ¥Ôª·ÃÎʲ»µ½ÎÒмӵģ¬ÎÒÔÚ¿Í»§¶Ë´ò¿ªÄǸöµ¥Ôª£¬È·Êµ¼ÓÁ ......

xml´´½¨ºóÈçºÎÏú»Ù? - Delphi / ÍøÂçͨÐÅ/·Ö²¼Ê½¿ª·¢

xml := CreateOleObject('Microsoft.XMLHTTP');
  xml.Open('GET','http://www.google.com', False);
  xml.Send;
  xml.responseText;
ʹÓÃxml.responseText¿ÉÒÔ»ñÈ¡ÍøÒ³Ô´Âë,µ«ÊÇÔÙ´Î ......

Í·ÌÛ£¡Delphiµ÷ÓÃC#µÄÓ¦ÓóÌÐòÎÞЧ

ÈçÌ⣡
  ÔÚDelphiÀïÃæµ÷ÓÃÎÒC#дµÄÒ»¸ö¿ÉÖ´ÐгÌÐò£¬È»ºóÔËÐÐDelphiµÄÓ¦ÓóÌÐòµÄʱºò£¬ÓкܴóµÄ¸ÅÂʵ÷Óò»ÉÏC#дµÄÓ¦ÓóÌÐò¡£
  ´úÂë¿Ï¶¨Ã»ÓÐÎÊÌâ¡£ÓÐʱºòÄܵ÷ÓÃÉÏ£¬ÓÐʱºòµãÁËûÓз´Ó¦£¬¼´²»Äܵ ......

ÀûÓÃArcGISºÍDelphi¿ª·¢µÄÎÊÌâ

ºÜ¼òµ¥µÄÎÊÌ⣬ÈçºÎÔÚ×é¼þmapcontrolÖÐÏÔʾAutoCAD»æÖƵĵØÍ¼ÐÅÏ¢£¿ÇëÏêϸָ½Ì


ʲôÇé¿ö£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿

mapcontrolÊÇʲô¶«Î÷ѽ
ÏÔʾAutoCAD»æÖƵĵØÍ¼ÐÅÏ¢,´ÓÍøÉÏÕҿؼþ°É,
»òÕßÄúÓнâÊÍ ......

delphiʹÓÃÆÁÄ»¼üÅÌ,³ÌÐòΪºÎÓж˿ÚÌý±¨´í?

¸÷λ´óÀÐ:
СµÜ±àдÁËһЩ³¬ÊÐǰ̨ÊÕÒø³ÌÐò(Óô¥ÃþÆÁ),µ«ÔÚ³ÌÐò½øÈëǰ,ÐèÒª²Ù×÷SQLÊý¾ÝÊýµÇ¼¿ò,ÎÒÏëÓÃXPµÄÆÁÄ»¼üÅÌÊäÈë,µ«ÊÇÖ»ÒªÆÁÄ»¼üÅÌ´ò¿ª,³ÌÐò×ÜÊDZ¨¶Ë¿Ú´«Êä³ö´íÐÅÏ¢(´ËÐÅÏ¢ÊÇÎҵijÌÐòÖÐÉèÖõÄ,ÊÇÏò¹Ë¿ÍÏÔÊ¾Æ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ