ACCESS ÖС¡select top 1 ²éµ½µÄÊý¾ÝΪ2Ìõ£¬Ôõô»ØÊÂ
ÉñÆæ
±È½ÏÆæ¹Ö
Ï൱µÄÉñÆæ£¡
0
ÒýÓÃ
--²éÁËÒ»ÏÂ×ÊÁÏ
jet sql »á·µ»ØÖظ´Öµ£¬Ò²¾ÍÊÇ˵£¬Ò»¸ö±íÖÐÈç¹û ORDER BY µÄ×ֶζ¼ÊÇ 0 £¬Ò»¹²ÓÐ100Ìõ¼Ç¼£¬¼´Ê¹ÄãÓÃSELECT TOP 1 À´·µ»Ø¼Ç¼£¬Ò²Í¬Ñù·µ»Ø100Ìõ¼Ç¼£¬ÒòΪ JET DB ÎÞ´ÓÔÚÕâ100Ìõ¼Ç¼ÀïÃæÅжÏÏȺ ......
private void buttonchangecode_Click(object sender, EventArgs e)
{
string strcon = global::codechange.Properties.Settings.Default.passwordchangeConnectionString;
OleDbConnec ......
ÓеÄ×Ö¶ÎÓо«¶ÈºÍСÊý,Õâ¸öÓÃc#Ôõô¶Á?
ËÄܰïÏÂæ¹þ,ллÁË,ÔÚÏ߸ø·Ö.
ûÈËÖªµÀÂð?
ÔÙ¶¥
²»¶Ô°¡
"˵Ã÷"ÎÒÖªµÀÔõô»ñµÃÁË,ËÄܸæËßÎÒ×ֶδóСÔõô»ñµÃ°¡?
ÕûÊýλºÍСÊýλ
ÎÒÖÕÓÚŪÇå³þÁË,Ìù³öÀ´°É
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=& ......
ÈçºÎ½«accessÊý¾Ý¿âÎļþµ¼Èësqlserver2005
µ¼Èëµ¼³ö¼´¿É
ѧϰ ÎÒÒ²ÊÇÐÂÊÖ
Óõ¼Èëµ¼³ö ×ֶμǼ »á¶ªÊ§Âð
²»»á
ÎÒ½«accessµ¼ÈësqlserverÁË µ«²»ÖªµÀÊý¾Ý¿â·ÅÔÚÄÄ
ÓÃSQL SERVER ÖÐ×Ô´øµÄDTS (Êý¾Ýµ¼Èëµ¼³ö¹¤¾ß) °´²½Öè²Ù×÷¼´¿É,Ö÷ÒªÊÇÑ¡ÔñÒªµ¼ÈëµÄÊý¾ÝÔ´Óëµ¼³öµÄÊý¾ÝÔ´.......×ÔÒÑÊÔÊÔ.
ÊÔÊ ......
ÎÒÊǰÑAccessÊý¾Ý¿â·ÅÔÚ¾ÖÓòÍøÉÏ£¬È»ºóÿ¸öÈË»úÆ÷ÁíÍâÓÐÒ»¸öAccess×öǰ̨£¬Ö±½ÓʹÓþÖÓòÍøÉϵÄÁ¬½Ó±í¡£ÔÀ´µÄËÙ¶È»¹ÐУ¬ÏÖÔÚʹÓÃÕß¶àÁË£¬¼Ç¼Ҳ¶àÒԺ󣬷¢ÏÖÿ¸öÈ˵ķÃÎÊËٶȺÜÂýÁË¡£
ÓÐʲô°ì·¨¿ÉÒÔ½â¾ö£¿°Ñºǫ́µÄAccessÊý¾Ý¿â»»³É±ðµÄ¶È¾Ý¿â£¿»òÕ߯äËû°ì·¨¡£ÒòΪǰ̨»¹ÐèÒªºÜ¶à²Ù×÷£¬ÎÒÖ»ÊìϤAccess£¬ËùÒÔÏ£Íûǰ̨ ......
µÚÒ»´ÎÓÃVB6+ACCESS2003×ö¸öС¶«Î÷£¬µ«ÒÔADO·½Ê½Á¬½ÓµÄʱºò×ÜÌáʾ ʵʱ´íÎó¡®3704¡¯ ¶ÔÏ󹨱Õʱ ²»ÔÊÐí²Ù×÷
ÎÒ´òÁËSP6µÄ²¹¶¡»¹ÊDz»ÐÐ Õâ¸öÎÊÌâ±ïÁ½ÌìÁË»¹Ã»½â¾öÁË£¬Ï£Íû´ó´ó¸ø¸ö½â¾ö·½·¨ ×îºÃ´ø´úÂë СµÜ°ÝлÁË
//ÕâÊÇpublic moduleÀïÃæµÄ¶«Î÷
Option Explicit
Public dbConn As New ADODB.Connectio ......