ÈçºÎÒ»´ÎÐÔÌæ»»AccessÊý¾Ý¿â±íÖÐÒ»ÐÐÖ¸¶¨¼¸ÁеÄÊý¾Ý
¿ÉÒÔдSQLÓï¾ä¡£»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
°ÑÄãÖ¸¶¨¼¸ÁеÄÊý¾Ý×÷ΪÅжÏÌõ¼þ£¬Ñ»·¸üÐÂ
update table set where
дSQLÓï¾ä¡£¡£¡£
update table set where¾ÍÊÇÕâ¸öÓï¾ä
ÒýÓÃ
update table set where¾ÍÊÇÕâ¸öÓï¾ä
¿´ÏÂÊé¾Í»áÁË
update ±íÃû set ×Ö¶Î=±äÁ¿ wher ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð»£¡
ÎÒÒ²ÏëÖªµÀ´ð°¸£¬°ïÄ㶥!!!!!!!!!!!!!!!!!!!!!!
......
ÎÒÓÃVCдµÄÒ»¸öСӦÓóÌÐò£¬Ê¹ÓÃaccess2003£¬Ïë°ÑËü´ò³ÉÒ»¸ö°²×°°ü£¬Ôõô°Ñaccess´ò½øÈ¥ÄØ£¿Ö»ÓÃÁË»ù±¾µÄÔöɾ²é¸ÄµÄÊý¾Ý¿â²Ù×÷£¬°²×°°üÒª¾¡¿ÉÄܵÄС£¬ÍøÉϲéÁËÏÂûÕÒµ½ºÏÊʵķ½·¨£¬»¹Çë¸÷λָµãһϣ¡¶àлÁË£¡
½¨ÒéÓÃVS.NetÖÆ×÷Ò»¸ö°²×°³ÌÐò¡£VCµÄÓ¦ÓóÌÐò·ÅÖõ½BINĿ¼£¬
Access2003µÄMDBÎļþ·ÅÖõ½DbĿ¼Ï¡£ÔÚ°²×° ......
AccessÖд´½¨ÊÔͼÓï¾ä£º
SELECT TableA.F1, TableA.F2, TableA.F3+TableB.F3 AS F3, TableA.F4 & TableB.F4 AS F4
from TableA INNER JOIN TableB ON (TableA.F2 = TableB.F2) AND (TableA.F1 = TableB.F1);
Õâ¸öÓï¾ä¿ÉÒÔ´´½¨£¬Ä¿Ç°ÎÒÏëÈçºÎʹ´´½¨µÄÊÓͼ×Ö¶ÎF4(Ò²¾ÍÊÇTableAÖкÍTableBÖÐF4×Ö¶ÎÏàÁ¬½á¹ ......
ÎÒÓÃVCдÁ˸öÔÚʵÑéÊý¾ÝÖÐÑ°ÕÒÐèÒªµÄÊýÖµ£¬Ã¿¸öʵÑéÎļþÖÐÓÐ2034¸öÊý¾Ý£¬ÆäÖв¨³¤ºÍÇ¿¶ÈÖµÒ»Ò»¶ÔÓ¦¡£Ö÷Òª´úÂëÈçÏ£º
void CFindPeakDlg::OnBegin()
{
// TODO: Add your control notification handler code here
CFileDialog openPre(true,"*.ROH",NULL,OFN_HIDEREAD ......
ÎÒÓÃVCдÁ˸öÔÚʵÑéÊý¾ÝÖÐÑ°ÕÒÐèÒªµÄÊýÖµ£¬Ã¿¸öʵÑéÎļþÖÐÓÐ2034¸öÊý¾Ý£¬ÆäÖв¨³¤ºÍÇ¿¶ÈÖµÒ»Ò»¶ÔÓ¦¡£Ö÷Òª´úÂëÈçÏ£º
void CFindPeakDlg::OnBegin()
{
// TODO: Add your control notification handler code here
CFileDialog openPre(true,"*.ROH",NULL,OFN_HIDERE ......