Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

accessÖÐreplaceÎÊÌâ

ÎÒÓÐÒ»¸öUnits±í,½á¹¹Îª:
  ID              UnistsName
  UN1            ºÚÁú½­¶«·½Ñ§Ôº
  UN2            ÖйúÒÆ¶¯Í¨Ðż¯ÍźÚÁú½­ÓÐÏÞ¹«Ë¾
  UN3            Áìµ¼¸É²¿ÃñÖ÷²âÆÀ(¼ò)
ÎÒдÁËÒ»¸ö²éѯÓï¾ä:select  ID,UnitsName  from Units  order by (replace(Ltrim(Rtrim(ID)),'UN','')+0)
Õâ¸öÓï¾äÊǰ´"UN"ºóÃæµÄÊý×Ö´óСÅÅÐò.
ÎÊÌâÊÇÕâ¸öÓï¾äÎÒÔÚaccessÖеIJéѯÖÐÔËÐÐûÓÐÎÊÌâ,µ«ÊÇÔÚ OleDbDataAdapter ÖÐÒ»Ö±ÐоÍ˵:
"±í´ïʽÖÐ 'replace' º¯Êý䶨Òå".ÕâÊÇΪʲô?

ÕâÊÇÖ´ÐÐÕâ¸ö²éѯÓï¾äµÄ·½·¨:
        public static DataSet Query(string SQLString)
        {
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connecti


Ïà¹ØÎÊ´ð£º

ÄÄÀïÓÐÃâ·ÑµÄÖ§³ÖACCESSµÄJSPÍøÕ¾¿Õ¼ä

    ´ó¶àÊýµÄÃâ·ÑJSPÍøÕ¾¿Õ¼ä¶¼Ö»Ö§³ÖMYSQL£¬Ô­ÏÈ×öºÃµÄÍøÕ¾ÊÇACCESS£¬Ö»ºÃ¿¼ÂÇ»»³ÉMYSQLÁË£¬µ«ÊÇÕûÕûŪÁËÒ»Ìì¶¼×°²»ÉÏMYSQL£¬Í·¶¼ÔÎÁË¡£
JSPÍøÕ¾¿Õ¼äÖ§³ÖACCESSºÃÏñÊÇûÓн¨¹ýµÄ£¬JspÒ»°ãÖ§³ÖMysql£¬Ora ......

vbÓëaccessÊý¾Ý¸üеÄÎÊÌâ

Ò»¸ö³ÌÐò£¬Á½¸ö´°¿Ú£¬Ò»¸öÓÃÀ´¸ü¸Äaccess±íÊý¾Ý£¨Form1£©,ÁíÒ»¸ö´°¿ÚÓиöcombo1ÓÃÀ´ÏÔʾÊý¾Ý(Form2)¡£form2ÓÐÒ»¸ö°´Å¥(command1)ÓÃÀ´´ò¿ªform1¡£ÏÖÔÚÎÒÏÈ´ò¿ªform2£¬combo1¶ÁÈ¡³öÊý¾Ý£¬µã»÷command1´ò¿ªform1,¸ü¸ÄÊý ......

VB access²»Í¬±íÁªºÏ²éѯ

СµÜÎÒÔÚдһ¸öÆû³µÐÞÀí³ÌÐòµÄʱºòÓö¼ûÁËÒ»¸öÎÊÌ⣬ÎҵĴ洢ģʽÊÇÕâÑùµÄ£¬³µÁ¾ÐÅÏ¢´æ·ÅÔÚÒ»ÕűíÄÚ£¬³µÁ¾Î¬Ð޼ǼÊÇÿ¸ö³µ´æ·ÅÒ»ÕűíÈçÏÂËùʾ£º£¨±í1 µÄ±íÃûÊÇ¡°Î¬ÐÞÕËÄ¿¡±£¬±í2µÄ±íÃûÊÇ ³µÅƶÔÓ¦µÄIDºÅ£©
  ......

ODBC Microsoft accessµÇ¼ʧ°Ü

н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
      ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
  ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......

ACCESSÊý¾Ý¿â¹ØÁª²éѯÎÊÌ⣿

³õÓÃACCESSÊý¾Ý¿â£¬ÒªÊµÏÖÒ»¸ö¹ØÁª²éѯ£¬sqlÓï¾äÈçÏ£ºselect pid,product_Type.name as tid,name,img_url,context,remark from Product join product_Type on product.type_id = product_Type.type_id order by pid ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ