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