Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

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

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

¹ØÓÚaccessÊÇ·ñÓÐͳ¼Æ¹¦ÄÜ

  ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a    table b
  ¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
  Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
 

  Èç:  ta ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ