accessÔõôÅжÏÌí¼ÓÖØ¸´£¿
ÎÒÔÚ×ö¸öÍøÒ³µÄÊý¾ÝÌí¼Ó··µ«ÊÇÔõôÅжÏaccessÊý¾Ý¿âÌí¼ÓÖØ¸´ÄØ£¿
±ÈÈçÎÒÔÚÍøÒ³ÖÐÌí¼ÓÁËÒ»¸ö±êÌâ½ÐasdµÄÎÄÕ£¬ÎÒºóÃæÔÚÌí¼ÓasdµÄʱºò¾Í»áÌáʾÒѾÓÐÕâ¸öÃû×ÖÁË
ÎÒÊÇÐÂÊÖ·Ï£Íû´ó¼Ò˵Ïêϸµã··Ð»Ð»¸÷λ~
È¥Êý¾Ý¿â²éѯ ÓÐûÓÐÄãÒª²åÈëµÄ±êÌâ
ÎÒÏëÒªÔÚÍøÒ³ÀïÃæÌí¼ÓµÄʱºò»áÌáʾÓÐÏàͬµÄÃû×Ö··ºÃÏñif£¬else¾Í¿ÉÒÔÅжÏÁË··µ«ÊDz»ÖªµÀÔõôд·····Âé·³´ó¼ÒÁË··
like the upstairs
if you want query on database,then:
select count(*) form tableName where fieldName="asd"
if you judge out:
for(EntityClass aa in EntityCollection){
if(aa.fieldName=="asd"){
return true;
}
}
if else µÄÌõ¼þÒ²ÊÇҪȥÊý¾Ý¿âÆ¥ÅäµÄ°¡¡£¡£¡£¡£
yes
take your content to database with a function,match it with ¡°select count(*) form tableName where fieldName="asd" ¡±
if count(*)>0 then haved the same name
else none.
ÎÒµÄÊý¾Ý¿âÊÇ×öºÃÁ˵ķ·Êý¾Ý¿âÒ²ÒѾÌí¼Ó½øÍøÒ³ÁË····Ò²¿ÉÒÔÔÚÍøÒ³½øÐÐÌí¼ÓÎÄÕ··µ«ÊǾÍÊÇÈç¹ûÎÄÕ±êÌâÒ»ÑùËü²»»áÌáʾ£¬ÕÕÑù»áÌí¼ÓÉÏÈ¥··ÏÖÔÚ¾ÍÊÇÕâ¸öÎÊÌâ···
ÎÒÊÇÐÂÊÖ··¿ÉÄÜÓÐЩµØ·½ÓÐЩÂé·³····Ð»Ð»¸÷λ¹þ··
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......