Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ð޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe      AppVer: 11.0.8166.0    AppStamp:46437912
ModName: pintlgnt.ime&n ......

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

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



¿ª·¢Ê±ÁôÏµĻº´æ

ACCESS»º´æ ÊÇָʲô£¿

ÊDz»ÊÇÏëѹËõÊý¾Ý¿â£¿

¹ØÓÚ Access ÎļþµÄѹËõºÍÐÞ¸´
Microsoft Access ½«¶Ô Access ÎļþµÄѹËõºÍÐÞ¸´·ÅÔÚÒ»¸ö½ø³ÌÖ ......

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

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

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

¹ØÓÚsqlÀïµÄÓï¾äÓëaccessÀïÓï¾äÎÊÌâ

ÎÒÔÚSQL2000ÖÐÏÂÃæµÄÕâ¾äÊÇûÎÊÌâµÄ,¿Éµ½ÁËaccessÀï¾Í»áÁË´í
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpa ......

ÈçºÎ°ÑÕâ¾ä¸Ä³ÉÔÚaccessÀïÕý³£ÔËÐеÄ?

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ