ACCESS Êý¾Ý¿â²éѯµÄÎÊÌâ
ÈçÉÏͼ£¬Õâ¸öÊÇÎÒÔÚACCESSÊý¾Ý¿âÖн¨Á¢µÄÒ»¸ö²éѯ£¬±íÃûΪddcx
ÓÃsql="select * from ddcx order by id desc"
<%=rs("userid")%>¿ÉÒÔÏÔʾ£¬
µ«ÊÇÓÃ<%=rs("chanpin.name")%>ºÍ<%=rs("danhao.name")%>È´ÔõôҲÏÔʾ²»³öÀ´
ÓÐûÓиßÊÖ¸æËßÎÒΪʲôѽ£¿
ÓÑÇéÖ§³Ö
Â¥Éϵģ¬¿ÉÒÔÁË£¬ÇëÎÊÕâ¸öÊÇΪʲôѽ
×ֶδÓ0¿ªÊ¼£¬2¾ÍÊÇchanpin.name£¬ÓÐÖØÃû£¬×îºÃÓÃSELECT ASÈ¡±ðÃû
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......