Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

ADOÎÞ·¨Á¬½ÓaccessÊý¾Ý¿âÎÊÌâ

ÎÒдÁËÒ»¸ömfc³ÌÐò£¬ÊÇsdiµÄ¡£ÊÓͼÊÇCformviewµÄÅÉÉúÀà¡£
ÎÒÏëʵÏÖÈÎÒâÁ¬½ÓÊý¾Ý¿âµÄ¹¦ÄÜ¡£ËùÒÔÔÚÊÓͼÉÏÌí¼ÓÁËÒ»¸ö°´Å¥¡£µã»÷°´Å¥£¬´ò¿ª¶Ô»°¿òÑ¡ÔñÊý¾Ý¿â½øÐÐÁ¬½Ó¡£´úÂëÈçÏÂËùʾ:

ÎÒÏÈÔÚstdafx.hÎļþÖмÓÁË ......

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

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

  Èç:  ta ......

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

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

µ±Êý¾Ý¿â×Ö¶ÎÎ ......

winform ACCESS δָ¶¨µÄ´íÎó 100·Ö

winformÓ¦ÓóÌÐò
Á¬½Ó×Ö·û´®
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbpath
dbpathΪ¾ø¶Ô·¾¶ Õâ¸ö·¾¶ÊÇûÓÐÈκÎÎÊÌâµÄ
ÔÚÖ´Ðе½connection.open()ʱ ±¨System.Data.OleDb.OleDbException:&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ