问题描述
我有一个用户名和密码列的表...在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...
推荐答案
这篇关于从asp.net项目返回一个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！