ΪɶÎÒ²åÈëaccessÊý¾Ý¿âÓÐÎÊÌâ
string connectionString = ConfigurationManager.AppSettings["ConnectionString"];
string sql = "insert into times(time) values('" + DateTime.Now + "' )";
OleDbConnection con = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
±¨´í string sql = "insert into times(time) values('" + DateTime.Now + "' )";
ÓдíÎ󣬵«ÊÇÎÒÔÚACCESSÊý¾Ý¿âÀïÃæ¾ÍûÎÊÌâ
string sql = "insert into times(time) values('" + DateTime.Now + "' )";
³ÌÐòÀïÃæµÄ¸ñʽÓëÊý¾Ý¿âÀïµÄ¸ñʽÊDz»ÏàͬµÄ,ҪתÏÂ,
string sql = "insert into times([time]) values(#" + DateTime.Now + "# )";
ÊÔÊÔ
values('" + DateTime.Now + "' )";
string sql = "insert into times([time]) values(#" + DateTime.Now + "# )";
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÔõÑùÇå³ýACCESS»º´æ
ACCESS°æÓеãÀäÇå
Õâ¸öÄÄλ¸ßÈË»á
СµÜ¼±ÓÃ
²»»á SORRY
»°ËµÂ¥Ö÷ ÎÒÔÚSQLµÄµÚÒ»¸öÎÊÌâ¶¼ÊÇÄã½â¾öµÄ ллÄã ÎÒÓ¡ÏóÉî¿Ì
ÒýÓÃ
²»»á SORRY
»°ËµÂ¥Ö÷ ÎÒÔÚSQLµÄµÚÒ» ......
ÔÚAccessÈí¼þÀ¿ÉÒÔÖ±½ÓÉèÖÃÈÕÆÚΪNow(),ºÃÏñÊÇÕâÑù°É¡£
ͨ¹ýsqlÓï¾ä£¬ALTER TABLE [article] ADD [date] datetime
µ«ÊÇÖ±½ÓÔÚºóÃæ¼ÓNow()£¬½á¹û³ö´í£¬Ôõôͨ¹ýsqlÓï¾äÖ±½ÓÉèÖóɵ±Ç°ÈÕÆÚ£¬¶ø²»ÓÃÍùÀïÃæ¼Ó£¿ ......
ÎÒÓÐÒ»¸ö±í,
´óÖ½ṹʽÕâ¸öÑù×ÓµÄ
id itname fenlei1id fenlei2id num
1 ÎïÆ·1 1 &n ......