try....
mn.commandtype=adcmdstoredproc
mn.commandtext="huang"
mn.Parameters.Refreshmn.Parameters("@chkname").Value = "wwwww"
...
mn.commandtype=adcmdstoredproc
mn.commandtext="huang"
mn.Parameters.Refreshmn.Parameters("@chkname").Value = "wwwww"
...
cn.open "dsn=hell0"
set rs=Server.CreateObject("adodb.recordset")
strSQL="存储过程名 '"&字符型参数&"',"&数字型参数&",'"&字符型参数&"'"
''''参数的排列顺序跟存储过程一样
rs.open strSQL,cn,3,1
(@chkname varchar(20),@chkpass varchar(20))
as
set nocount on
declare @flag varchar(50)
if exists(select * from 表的名称 where 姓名=@chkname and 密码=@chkpass)
select @flag='成功'
else
select @flag='失败select flag=@flag
set oncount off
asp中调用存储过程
<!--#include file="adovbs.inc"-->
<%
set cn=server.createobject("adodb.connection")
cn.open "dsn=hell0" '直接连接数据源
set mn=server.createobject("adodb.command")
set mn.activeconnection=cn
mn.commandtype=adcmdstoredproc
mn.commandtext="huang"
mn.commandtype=4
mn.parameters(1)=chkname
mn.parameters(2)=chkpass
set rs=mn.execute()
response.write rs("flag")
如set myfirst=mn.createparameter("new1",advarchar,adparamoutput,30)
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=133244