ÎÞ·¨¸ü¸Ä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³ÌÐò´¦ÓڹرÕ״̬
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢
Ö´ÐÐǰ
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......