Asp ȫѡ ¶àÑ¡ÔñÏî JSÒýÓÃ
<script language="JavaScript">
function CheckAll(form) {
var x=form.elements;
for (var i=0;i<x.length;i++)
{
var e = x[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
</script>
--Ò³ÃæcheckboxÄÚ²¿
<input type='checkbox' value='"&rs("ID")&"' name=id>
//ȫѡ°´Å¥checkbox
<input type='checkbox' name=chkall onclick='CheckAll(this.form)'>
<input type="submit" name="action" value="ɾ³ý" onClick="{if(confirm('¸Ã²Ù×÷²»¿É»Ö¸´£¡\n\nȷʵɾ³ýÑ¡¶¨µÄÁôÑÔ£¿')){this.document.book.submit();return true;}return false;}">
Ïà¹ØÎĵµ£º
¡¡¡¡×î½üÓкܶàµÄÅóÓÑÎʵ½µ÷Óô洢¹ý³ÌµÄÎÊÌ⣬ÕâÀï¼òµ¥½éÉܼ¸ÖÖASPµ÷Óôø²ÎÊý´æ´¢¹ý³ÌµÄ·½·¨¡£
¡¡¡¡1. ÕâÒ²ÊÇ×î¼òµ¥µÄ·½·¨,Á½¸öÊäÈë²ÎÊý£¬ÎÞ·µ»ØÖµ£º
¡¡¡¡set connection = server.createobject("adodb.connection")
¡¡¡¡connection.open someDSN
¡¡¡¡Connection.Execute "procname varvalue1, varvalue2"
¡¡¡¡'½«Ëù ......
¡¡¡¡1. Ö»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡¼ÙÉèÓÐÒÔÏ´洢¹ý³Ì(±¾ÎĵÄÄ¿µÄ²»ÔÚÓÚ½²ÊöT-SQLÓï·¨£¬ËùÒÔ´æ´¢¹ý³ÌÖ»¸ø³ö´úÂ룬²»×÷˵Ã÷)£º
/*SP1*/
CREATE PROCEDURE dbo.getUserList
as
set nocount on
begin
select * from dbo.[userinfo]
end
go
¡¡¡¡ÒÔÉÏ´æ´¢¹ý³ÌÈ¡µÃuserinfo±íÖеÄËùÓмǼ£¬·µ»ØÒ»¸ö¼Ç¼¼¯¡£Í¨¹ ......
ÎÊÌ⣺
aspÈçºÎµ÷Óô洢¹ý³ÌʵÏÖ·ÖÒ³£¡
´æ´¢¹ý³ÌÈçÏ£º
CREATE PROCEDURE GetRecordfromPage
@tblName varchar(255), -- ±íÃû
@fldName varchar(255), &nb ......
Top-CMSÖ÷ÒªÌØµã£º
1.ϵͳ²ÉÓÃASP+COM¼¼Êõ¿ª·¢£¬Ò»·½Ãæ×î´ó³Ì¶È±£ÕÏϵͳ°²È«ÐÔ£¬ÁíÒ»·½Ã漫´óµÄÌá¸ßϵͳÔËÐÐЧÂÊ¡£
2.ϵͳÍêÈ«»ùÓÚB/Sģʽ¹¹½¨£¬Ö»ÒªÔÚ·þÎñÆ÷Éϰ²×°Á˱¾ÏµÍ³£¬¿Í»§»ú²»ÐèÒª°²×°ÆäËûÈí¼þ£¬Ö±½ÓʹÓÃIE±ã¿Éä¯ÀÀ¡£
3.ϵͳ±¾Éí¼¯³ÉÖîÈ繫¸æ¡¢×¨Ìâ¡¢ÔÚÏßµ÷²é¡¢Óû ......
<%
set conn= server.createobject("ADODB.connection")
conn.open "driver={sybase driver 10};"
"srvr=SYBASE;"
"UID=sa;"
"pwd=sybase;"
sql="select no from tab_st ......