ĿǰÎÒÒѾѧ»á½«Í¼Æ¬ÒÔ¶þ½øÖÆÊýµÄÐÎʽ´æÈëaccessÊý¾Ý¿âÖУ¬µ«ÊÇÎÒÏÖÔÚÒª×öÒ»¸ö²éѯ£¬ÏëÒªÅжÏÊý¾Ý¿âAÖС°±í1¡°ÖеÄphoto×Ö¶ÎÊÇ·ñÒѾ´æÔÚͼƬÐÅÏ¢£¬ÇëÎÊÓ¦¸ÃÔõôÑù×ö£¿
СµÜÔÚÏߵȣ¬¿ÉÇë¸ßÊÖ°ïæ£¬Ð»Ð»¡£
if not isnull(rs!photo) then
msgbox "ÒÑ´æÔÚͼƬÐÅÏ¢"
end if
sele ......
C# code:
**////*************************************//
/// <summary>
/// 26¸öÈÕÎÄÆ¬¼ÙÃû±àÂë
/// </summary>
/// <param>ÁºÔ¶È«</param>
/// <param>2006.8.10</param>
///*************************************//
using System;
using System.Text;
namespace JAP ......
¡¡¡¡VSO5×öÁËÒ»¸öÔöɾ¸ÄµÄ¶«Î÷£¬¹«Ë¾OracleÔËÐеÄûÓÐÎÊÌâ,»Ø¼ÒÓÃACCESSÔËÐо͵ò»µ½½á¹û¡£
¼àÊÓÁËÏÂSQLÓï¾ä£¬Ïò´óϺÇë½ÌÏ£¡
Ò».SQLÓï¾ä²åÈë²âÊÔ
£±¡£Oracle,ACCESS½¨ÁËÒ»¸öͬÑùµÄ±í
£².¡¡¶¼ÓÃÓï¾äinsert into ISSUE_STATUS (ISSUENO,ITHANDLE,ISSUE_STATUS,ITREMARK) values('ddd111','' ......
ÈçÌ⣬ÔõÑùÉè¼ÆÀàËÆ Access ÖеÄÁбíÊÓͼ¿Ø¼þ£¬¿ÉÒÔ½øÐб༣¬È»ºóÎȶ¨£¬¿É±à¼µÄÁÐ±í¿Ø¼þµÄÖÆ×÷ÎÒÓÐ×ÊÁÏ£¬Óà CEdit ¿Ø¼þ×÷Ϊ¸¨Öú£¬µ«ÊÇЧ¹û²»ºÃ£¬ËùÒÔÏëÎÊÒ»ÏÂÄÄÀïÓÐÕâ·½ÃæµÄ×ÊÁϵģ¬ÏÂÃæÊÇЧ¹ûµÄ½ØÍ¼¡£
×Ô¶¨Òå¿Ø¼þ¡£
ÒýÓÃ
×Ô¶¨Òå¿Ø¼þ¡£
°ÝÍУ¬ËµµÃÕâô¼òµ¥£¬ÈçºÎʵÏÖ°¡£¡
ÈçºÎʵÏÖÒ»¾ä»°Á½¾ ......
ÎÒÏë°ÑACCESS Öеıí1 AÁÐÊý¾Ý ºÍ ±í2 µÄCÁÐÊý¾Ý ºÍ²¢µ½ ±í3 ÔõôÓÃSQL½â¾ö ¾ßÌåÈçÏ£º
±í1
AÁÐ BÁÐ
1 ´ó
2 ÖÐ
3 С
±í2
CÁÐ DÁÐ
A a
B b
C c
SQL½á¹û£º
±í3
AÁÐ&nbs ......
ÎÒÓÃASPд access ²éѯÓï¾äʱ,Ö´ÐÐʱ²»±¨´í,ÕÒ²»²»³ö¼Ç¼,µ«Êý¾Ý¿âÖÐÓмǼ
ÏÂÃæÊÇÓï¾ä:sql="( urln.pois='"&no&"') and ( id in ( "&sql3&" )) and ( "&sql&" ) "
sql3="select id,url1,pageName,zml,idzml,upD ......