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

ÎÞ·¨¸ü¸ÄACCESSÊý¾Ý¿â

±¾ÈË×öÁËÒ»¸ö¸ü¸ÄÃÜÂëµÄBUTTON£¬ÔÚ´°ÌåÉÏÃæ»¹ÓÐÒ»¸öTEXTBOX¿Ø¼þ£¬ºǫ́Êý¾Ý¿âÓõÄÊÇACCESS£¬ÏÖÔÚÎÊÌâÈçÏ£ºµã»÷¸ü¸ÄÃÜÂëµÄBUTTONºó£¬TEXTBOXÏÔʾ¸ü¸ÄºóµÄÃÜÂëBBB,£¨Ô­ÃÜÂëÊÇAAA£©£¬µ«ÊÇÎҹصô´°ÌåºóÔÙÖØÐÂÖ´ÐУ¬Ö±½Óµã»÷ÏÔʾÃÜÂëµÄBUTTON£¬TEXTBOX»¹ÊÇÏÔʾδ¸ü¸ÄµÄÃÜÂëAAA£»ºÃÏñ¾ÍÊdzÌÐòÖ´Ðж¼Ã»ÓÐÎÊÌ⣬µ«ÊǾÍÊDz»Äܽ«ACCESSÊý¾Ý¿âÖÐÃÜÂë±íÖеÄÃÜÂ룡 ÓÃACCESS³ÌÐò´ò¿ª¸ÃÊý¾Ý¿âÃÜÂ뻹ÊÇÔ­ÃÜÂë
string updatestr = "update login set ÃÜÂë='BBB' where µÇ¼Ãû='aaaaa'";
            OleDbCommand strcommand = new OleDbCommand(updatestr, connection);
            strcommand.Connection.Open();
            strcommand.ExecuteNonQuery();

update [login]

ÊÔÊÔ

update [login] set ÃÜÂë='BBB' where µÇ¼Ãû='aaaaa'
ÔÙÖØÐ²éѯÏÔʾ

È·¶¨ÔËÐгÌÐòʱ ACCESS´¦ÓڹرÕ״̬£¿

²âÊÔ¹ýÁË update [login] set ÃÜÂë='BBB' where µÇ¼Ãû='aaaaa'  ²»ÐУ¡ access³ÌÐò´¦ÓڹرÕ״̬


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

¸ßÈ˽ø £¡£¡access Êý¾Ý¿âÎÊÌâ~~

±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢

Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ