ÓÃASPÔõôдÒÔÏ´úÂë
µ±½áÊøÊ±¼ä´óÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδÍê³É
µ±½áÊøÊ±¼äСÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδ´ïµ½ÈÎÎñ
ûÓÐʱ¼äÔòÏÔʾÕýÔÚ½øÐÐÖÐ
asp´úÂëÓ¦¸ÃÔõôд
Èç:¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä Íê³Éʱ¼ä ״̬
2009-10-10 2009-10-20 2009-10-15 Íê³É
2009-10-10 2009-10-20 2009-10-21 delay
2009-10-10 2009-10-20 ûÓÐʱ¼ä ÕýÔÚ½øÐÐÖÐ
1.Ñ»·ÅжÏßÂ
2.ÓÃÒ»¾äsqlÒ²ÄÜд³öÀ´
SQL code:
select startTime,endTime,finishTime,case when finishTime>endTime then 'delay' when endTime<finishTime then 'Íê³É' when finishTime is null then 'ÕýÔÚ½øÐÐÖÐ' end as status from table
ÎÒ¾õµÃÁÖÕÑдµÃ±È½ÏºÃ±È½Ï·ûºÏÌâÒâ
ţţ »»Ò»ÖÖ½â¾ö·½·¨ Ò²²»´í
1LµÄºÜºÃ°¡
Ïà¹ØÎÊ´ð£º
ÕâÀïÊÇGridView°ó¶¨µÄÒ»¸öÄ£°å, ÎÒÏëͨ¹ýÕâÀïµÄ "²é¿´ÏêÇé", Ìø×ªµ½Ò»¸ö°üº¬DetailsView
µÄÒ³Ãæ. È»ºó¾Í»áÏÔʾÏàÓ¦µÄÐÅÏ¢.
°üº¬DetailsViewµÄÒ³Ãæ¸ù¾ÝIDÖµ°ó¶¨Êý¾Ý
°üº¬GridViewµÄÒ³ÃæµÄµÚÒ»ÁÐÊ ......
ÎÒÓÃASP×öÁËÒ»¸öÂÛÌ³Ò³Ãæ£¬ÒªÍ³¼ÆÔĶÁÊý¡£Ã¿´ò¿ªÒ³ÃæÒ»´Î¾ÍUPDATEÔĶÁÊýÄǸö×ֶΣ¬ÕâÑùÖ»ÒªÒ³ÃæË¢ÐÂÒ»´Î¾Í»áUPDATEÒ»´Î£¬ÇëÎÊÒªÔõô·ÀֹˢÐÂÒ³ÃæÀ´Ôö¼ÓÔĶÁÊý£¿
Çå³ý»º´æ ÅжÏÉÏÒ³À´Ô´µØÖ· Õâ¸öÖ»ÊÇÏë·¨ ÎÒûÓÐʵ¼ù ......
ÎÒ×öÁËÒ»¸öASPÍøÕ¾£¨µÚÒ»´Î×ö£©£º
ÔÚÎÒµçÄÔÉÏ£¬ÎÒÏÂÁ˸öMySQLµÄODBC£¬
Á¬½ÓÓï¾ä£º
ConnStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=123456;"
......
<asp:button>ĬÈÏ»áÌá½»Ò³Ãæ£¬ÈçºÎ½« <asp:button>²»Ìá½»Ò³Ãæ£¬¶øÖ´ÐÐÆäËûµÄº¯Êý£¬¼´aspÖÐµÄ <input type="button">
ÈçºÎ½« <asp:button>ÖØÖÃÒ³ÃæµÄ±íµ¥Öµ£¬¼´aspÖÐµÄ <in ......
conn.asp
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.MapPath("Connt ......