Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 + "# )";


Ïà¹ØÎÊ´ð£º

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

accessÖÆ×÷ÏÂÀ­²Ëµ¥

access¿ÉÒÔÖÆ×÷ÄÇÖÖÏÂÀ­²Ëµ¥Â𣿾ÍÏñFile£¬È»ºóÏÂÃæÓÐOpen£¬Save,Save asµÈÑ¡Ïî¡£µ«ÊÇ£¬Ó¦¸Ã½«Êó±ê·ÅÉÏÈ¥¾ÍÖ±½Ó¿ÉÒÔ´ò¿ª°É£¬²»ÊÇcombo box¡£Õâ¸öÓÃʲôÀ´×ö£¿
×Ô¶¨Ò幤¾ßÀ¸

´°ÌåÉè¼ÆÄ£Ê½
²Ëµ¥--ÊÓͼ--¹¤¾ ......

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

ÎÒÓÐÒ»¸ö±í,
´óÖ½ṹʽÕâ¸öÑù×ÓµÄ
id  itname      fenlei1id    fenlei2id  num
1    ÎïÆ·1          1    &n ......

ÈçºÎ°ÑÕâ¾ä¸Ä³ÉÔÚ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ºÅ