方法一
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
方法二:
1
public static AdoHelper helper = AdoHelper.CreateHelper("sqlDA");
2
public static string cs = WebConfigurationManager.AppSettings["SqlServerConnectionString"];
3
4
protected void Page_Load(object sender, EventArgs e)
5
{
6
IDataParameter[] parameters = helper.GetSpParameterSet(cs, "GetUName");
7
parameters[0].Value = 6;
8
parameters[1].Direction = ParameterDirection.Output;
9
IDataReader reader = helper.ExecuteReader(cs, "GetUName", parameters);
10
string data = (string)parameters[1].Value;
11
Response.Write(data);
12
13![](/Images/OutliningIndicators/InBlock.gif)
14
}
15![](/Images/OutliningIndicators/None.gif)
16
存储过程
17
CREATE PROCEDURE GetUName
18
-- Add the parameters for the stored procedure here
19
(
20
@userid int,
21
@uname varchar(50) OutPut
22
)
23
AS
24![](/Images/OutliningIndicators/None.gif)
25
-- SET NOCOUNT ON added to prevent extra result sets from
26
-- interfering with SELECT statements.
27
SET NOCOUNT ON;
28![](/Images/OutliningIndicators/None.gif)
29
-- Insert statements for procedure here
30
SELECT @uname = UName from UserInfo where UserID = @userid
31![](/Images/OutliningIndicators/None.gif)
32
GO
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/None.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
方法三:一个判断登陆
1
public static int VerifyPassword(string strUsername, string strPassword)
2
{
3
// IDataParameter[] parameters = helper.GetSpParameterSet(cs, "VerifyPassword");
4
IDataParameter[] parameters = new IDataParameter[3];
5
parameters[0] = helper.GetParameter("@username", strUsername);
6
parameters[1] = helper.GetParameter("@password", strPassword);
7
parameters[2] = helper.GetParameter("ReturnValue",DbType.Int16, 4, ParameterDirection.ReturnValue);
8![](/Images/OutliningIndicators/InBlock.gif)
9
helper.ExecuteNonQuery(cs, "VerifyPassword", parameters);
10
return (int)parameters[2].Value;
11
}
12
存储过程
13
PROCEDURE [dbo].[VerifyPassword]
14
(
15
@username Varchar( 20 ),
16
@password Varchar( 20 )
17
--@reason int OutPut
18
)
19
AS
20
DECLARE @foundUser Varchar( 20 )
21
SELECT @foundUser = ul_username
22
FROM UserList
23
WHERE ul_username = @username
24
AND ul_password = @password
25
IF @foundUser IS NOT NULL
26
--set @reason =0
27
return 0
28
ELSE
29
IF Exists( SELECT ul_username
30
FROM UserList WHERE ul_username = @username )
31
--set @reason =2
32
return 2
33
ELSE
34
--set @reason = 1
35
return 1
36![](/Images/OutliningIndicators/None.gif)
37![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/None.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
33
![](/Images/OutliningIndicators/None.gif)
34
![](/Images/OutliningIndicators/None.gif)
35
![](/Images/OutliningIndicators/None.gif)
36
![](/Images/OutliningIndicators/None.gif)
37
![](/Images/OutliningIndicators/None.gif)