ΪɶÎÒ²åÈë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 + "# )";
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
access¿ÉÒÔÖÆ×÷ÄÇÖÖÏÂÀ²Ëµ¥Â𣿾ÍÏñFile£¬È»ºóÏÂÃæÓÐOpen£¬Save,Save asµÈÑ¡Ïî¡£µ«ÊÇ£¬Ó¦¸Ã½«Êó±ê·ÅÉÏÈ¥¾ÍÖ±½Ó¿ÉÒÔ´ò¿ª°É£¬²»ÊÇcombo box¡£Õâ¸öÓÃʲôÀ´×ö£¿
×Ô¶¨Ò幤¾ßÀ¸
´°ÌåÉè¼ÆÄ£Ê½
²Ëµ¥--ÊÓͼ--¹¤¾ ......
ÎÒÓÐÒ»¸ö±í,
´óÖ½ṹʽÕâ¸öÑù×ÓµÄ
id itname fenlei1id fenlei2id num
1 ÎïÆ·1 1 &n ......
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 ......