从asp.net项目返回一个值 [英] return a value from asp.net project

问题描述

我有一个用户名和密码列的表...在sql server中我写了一个给出的程序....



ALTER PROCEDURE [dbo]。 [CHECK_WEBUSERPASSWORD] @WU_NM VARCHAR（15），@ WU_PWD VARCHAR（15），@ OK VARCHAR（1）OUTPUT AS

SET @ OK = N

IF（SELECT COUNT （*）FROM WEBUSER WITH（NOLOCK）WHERE WU_NM = @ WU_NM AND WU_PWD = @ WU_PWD）> 0

SET @ OK = Y



我也写了db运算符类和其他两个类来返回该值....如何在单击登录按钮时返回主窗体中的值...

I have a table with columns username and password... in sql server i wrote a procedure given below....

ALTER PROCEDURE [dbo].[CHECK_WEBUSERPASSWORD] @WU_NM VARCHAR(15),@WU_PWD VARCHAR(15),@OK VARCHAR(1) OUTPUT AS
SET @OK=N
IF (SELECT COUNT(*) FROM WEBUSER WITH (NOLOCK) WHERE WU_NM=@WU_NM AND WU_PWD=@WU_PWD)>0
SET @OK=Y

also i wrote db operator class and other two classes to return that value.... how i can return the value in my main form on clicking login button...

推荐答案

把这行放在最后一行



ALTER PROCEDURE [dbo]。[CHECK_WEBUSERPASSWORD] @WU_NM VARCHAR（15），@ WU_PWD VARCHAR（15），@ OK VARCHAR（1）OUTPUT AS

SET @ OK = N

IF（从WEBUSER中选择COUNT（*）WITH（NOLOCK）WHERE WU_NM = @ WU_NM AND WU_PWD = @ WU_PWD）> 0

SET @ OK = Y

返回@OK

Put this line in the last

ALTER PROCEDURE [dbo].[CHECK_WEBUSERPASSWORD] @WU_NM VARCHAR(15),@WU_PWD VARCHAR(15),@OK VARCHAR(1) OUTPUT AS
SET @OK=N
IF (SELECT COUNT(*) FROM WEBUSER WITH (NOLOCK) WHERE WU_NM=@WU_NM AND WU_PWD=@WU_PWD)>0
SET @OK=Y
return @OK

这篇关于从asp.net项目返回一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！