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

дÈëACCESSÊý¾Ý¿âµÄÎÊÌâ


date="'"+dtime+","+save[i,0].ToString()+","+save[i,1].ToString()+","+save[i,2].ToString()+","+save[i,3].ToString()+","+save[i,4].ToString()+","+save[i,5].ToString()+","+save[i,6].ToString()+"'";
             
ocmd.CommandText = "insert into hao(ÈÕÆÚ,NO1,NO2,NO3,NO4,NO5,NO6,NO7) values("+date+")";
ocmd.ExecuteNonQuery();


ÔÚÉÏÃæµÄ´úÂëÖУ¬valuesµÄÖµÈç¹ûÓÃÒ»¸ö×Ö·û´®±äÁ¿´úÌæ£¬Ëü¾Í²»ÐС£µ«ÎÒÓÖÐèÒªÕâÑù£¬Çë¸ßÊÖ¸ø¸ö°ì·¨£¡
ûÊÔ¹ý¡­¡­°ï¶¥£¡

ÕâÑùдdate¾ÍÓ¦¸Ã¿ÉÒÔÁË£º
date="'"+dtime+"','"+save[i,0].ToString()+"','"+save[i,1].ToString()+"','"+save[i,2].ToString()+"','"+save[i,3].ToString()+"','"+save[i,4].ToString()+"','"+save[i,5].ToString()+"','"+save[i,6].ToString()+"'";

Ö÷Òª»¹ÊÇÆ´½Ó×Ö·û´®µÄÎÊÌâ
ÒòΪÓеÄÐèÒªµ¥ÒýºÅ£¬ÓеIJ»ÐèÒª¡£ÕâÀïºÜÈÝÒ׳ö´í¡£
ÎÒ¸öÈË»¹ÊÇϰ¹ßÓÃÈçÏ·½Ê½
string model="'{0}',{1},{2},{3},{4},{5},{6},{7}";
ÔÚʹÓõÄʱºò
string.Format(model,save[i,0],save[i,1],save[i,2],save[i,3],save[i,4],save[i,5],save[i,6],save[i,7]);
ÕâÑù¸üÇåÎú¡£



date="'"+dtime+","+save[i,0].ToString()+","+save[


Ïà¹ØÎÊ´ð£º

ACCESSÊý¾Ý¿â²ð·ÖµÄÎÊÌâ

ÎÒ×öÁËÒ»¸öѧÉú»ñ½±ÐÅÏ¢µÄ±í£¬ÀïÃæ×Ö¶ÎÓкܶ࣬È磺ѧºÅ£¬ÐÕÃû£¬°à¼¶£¬ÁªÏµ·½Ê½£¬Äê¼¶£¬ÐÔ±ð£¬100Ã×£¬200Ã×£¬CET4£¬¼ÆËã»úµÈ¼¶,±¨¹ØÔ±£¬±¨¼ìÔ±£¬µÈµÈºÜ¶à£¬Ôõô²ð·Ö³É¼¸¸ö±í£¬ÈçºÎ×éÖ¯±í¼ä¹ØÏµ?
´ÓÄãµÄ˵Ã÷ÉÏ¿´²»³ö ......

ADO.NET²Ù×÷AccessµÄÎÊÌâ

C# code:

public override int Update(Table model, DbTransaction dbtran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Tabl ......

¼±¼±£¡£¡¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌâ

Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿


¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡

vbÓïÑÔ´úÂëÈ ......

ÇëÎÊAccessÖÐÈçºÎʹÓÃÎÞ·ûºÅÕûÊý

´ó¼ÒºÃ£¬ÎÒÔÚÊý¾Ý±íÖж¨ÒåÒ»¸öÐèÒª½øÐÐÅÅÐòµÄÕûÊý×ֶΣ¬µ«ÊǸù¾ÝÓ¦ÓÃÐèÇ󣬸Ã×ֶεÄȡֵ·¶Î§ºÜ´ó£¬¼¸ºõÓÃÂúÁËÕû¸ö32볤¶È¡£
ÔÚAccess±íÖкÃÏñÖ»ÓС°³¤ÕûÐÍ¡±Êʺϳ¤¶ÈµÄÐèÒª¡£¿ÉÊÇÓÉÓÚ³¤ÕûÐÍÊÇ´ø·ûºÅÊýµÄ£¬Òò´ËÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ