ΪɶÎÒ²åÈë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Ð޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe AppVer: 11.0.8166.0 AppStamp:46437912
ModName: pintlgnt.ime&n ......
ÔõÑùÇå³ýACCESS»º´æ
¿ª·¢Ê±ÁôÏµĻº´æ
ACCESS»º´æ ÊÇָʲô£¿
ÊDz»ÊÇÏëѹËõÊý¾Ý¿â£¿
¹ØÓÚ Access ÎļþµÄѹËõºÍÐÞ¸´
Microsoft Access ½«¶Ô Access ÎļþµÄѹËõºÍÐÞ¸´·ÅÔÚÒ»¸ö½ø³ÌÖ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
ÎÒÔÚSQL2000ÖÐÏÂÃæµÄÕâ¾äÊÇûÎÊÌâµÄ,¿Éµ½ÁËaccessÀï¾Í»áÁË´í
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpa ......
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpath like '%0,3%' and Child=0 group by classname order ......