C# accessÇóÖú - .NET¼¼Êõ / C#
²Ù×÷Êý¾Ý¿âʱ£¬ÁÐÊDZäÁ¿£¬ÈçÏÂ
OleDbCommand myCmd = new OleDbCommand();
myCmd.CommandText = "insert into users(" + item + ") values('" + direction + "')";
item ºÍ direction ¶¼ÊǶ¨ÒåµÄstring,µ«ÊÇÓöµ½Ò»¸öÎÊÌâ,insert²»ÄÜÓÃwhere,¸ÄÓÃupdata,µ«²»ÖªÁÐÊDZäÁ¿µÄʱºòupdataÓï¾äÔõôд
C# code:
myCmd.CommandText = "UPDATE users SET " + item + "='" + direction + "' WHERE ...";
Â¥ÉÏÕý½â
Â¥Éϵġ£ÎªÊ²Ã´´óд×Öĸ¶¼ÊÇ´øÈ¦µÄ£¿
ÍüÁË˵£¬ÎÒÓÐÒ»ÁÐÊÇNAME£¬È»ºówhereµÄÌõ¼þÊÇNAME=username;
usernameÒ²ÊÇ×Ô¶¨ÒåµÄ±äÁ¿string
Ìáʾexception
"ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ"
ÓÖÊÇÒ»¸öÌõ¼þ²»ËµÇå³þµÄÐÂÊÖµÄÌáÎÊ¡£
ÒÔºó¸Ä¸ÄÕ⻵벡¡£
update ±íÃû set ÁÐÃû='Öµ1' where ÁÐÃû='Öµ'
ǰºóÁÐÃû¿ÉÒÔÏàͬҲ¿ÉÒÔ²»Ïàͬ
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
´ó¼ÒºÃ£¬ÕâÊÇÒ»¸öÖ÷ÒªÃæÏòc/c++/mfcµÄȺ£¬×î½ü½øÐÐÁËÒ»´Î´óÇåÀí£¬»¶Ó¸÷λ¸ßÊÖ¼ÓÈ룬ºÃѧ°®ÎʵÄÐÂÊÖ£¬Ò²¿ÉÒÔÉêÇëµÄ£¬ÉêÇë¸ñʽ Ö°Òµ£¨c/c++/mfc ÈÎѡһ»òÕ߶ࣩ ¹¤×÷ÄêÏÞ£¨Ñ§ÉúÖ±½Óд´ó¼¸£©¾ÍÐÐÁË£¬ÈëȺµÄÒªÇó¾ÍÊÇÒª» ......
´ó¼ÒºÃ£º
ÎÒÏëʵÏÖ¼ì²âµ½²åÈëSD¿¨ºó×Ô¶¯½«SD¿¨¸ñʽ»¯µÄ¹¦ÄÜ£¬²»ÖªC/C++ÖÐÓÐûÓиñʽ»¯UÅ̵ĺ¯Êý£¿
ÁíÍ⣬ÎÒ²»ÏëʹÓÃSHFormatDrive£¬ÒòΪÕâ¸öº¯Êý»áµ¯³öÊÇ·ñÒª¸ñʽ»¯µÄÌáʾ¿ò£¬ÎÒÐèÒªµÄÊÇϵͳ×Ô¶¯¸ñʽ»¯£¬¶ø²Ù×÷Õß² ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......