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

ΪɶÎÒ²åÈë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²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ÔõÑùÇå³ýACCESS»º´æ

ÔõÑùÇå³ýACCESS»º´æ
ACCESS°æÓеãÀäÇå
Õâ¸öÄÄλ¸ßÈË»á
СµÜ¼±ÓÃ
²»»á SORRY

»°ËµÂ¥Ö÷ ÎÒÔÚSQLµÄµÚÒ»¸öÎÊÌâ¶¼ÊÇÄã½â¾öµÄ ллÄã ÎÒÓ¡ÏóÉî¿Ì

ÒýÓÃ
²»»á SORRY

»°ËµÂ¥Ö÷ ÎÒÔÚSQLµÄµÚÒ» ......

Access sqlÓï¾äÎÊÌâ

ÔÚAccessÈí¼þÀ¿ÉÒÔÖ±½ÓÉèÖÃÈÕÆÚΪNow(),ºÃÏñÊÇÕâÑù°É¡£
ͨ¹ýsqlÓï¾ä£¬ALTER TABLE [article] ADD [date] datetime
µ«ÊÇÖ±½ÓÔÚºóÃæ¼ÓNow()£¬½á¹û³ö´í£¬Ôõôͨ¹ýsqlÓï¾äÖ±½ÓÉèÖóɵ±Ç°ÈÕÆÚ£¬¶ø²»ÓÃÍùÀïÃæ¼Ó£¿ ......

accessµÄ·ÖÀà»ã×ܲéѯ

ÎÒÓÐÒ»¸ö±í,
´óÖ½ṹʽÕâ¸öÑù×ÓµÄ
id  itname      fenlei1id    fenlei2id  num
1    ÎïÆ·1          1    &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ