---
title: "用事物实现登陆"
author: "mywebcode"
date: "2012-11-30T16:22:00Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2013-05-08T10:26:23Z"
id: 1862855
url: "https://mywebcode.iteye.com/blog/1862855"
---

1.在ADO中使用存储过程  
use UserDB1  
select * from T\_Users  
create proc usp\_login  
@uname varchar(50),  
@password varchar(50),  
@result bit output----布尔类型的参数，是用来返回值的，设置存储用户登录是否成功1---true,0------false  
as  
begin  
declare @count int  
set @count=( select count(\*) from T\_Users where [FuserName=@uname](mailto:FuserName=@uname) and [Fpassword=@password](mailto:Fpassword=@password))  
if @count&gt;0  
begin  
set @result=1  
end  
else  
begin  
set @result=0  
end  
end  
declare @r bit  
exec usp\_Login @uname='admin321232','111',@r output  
print @r  
print @@servername

btnClick  
{ string username=txtUserName.Text.Trin();  
string password=txtPassword.Text.Trin();

使用ADO连接数据库  
Connection--SqlConnection--连接字符串  
Command--SqlCommand  
SqlParaneter  
SqlDataReader  
......

string connstr="Data Source=PC-20120907SDQU;Initial Catalog=UserDbl;User ID=sa; Password=admin"  
using(SqlConnection conn=new SqlConnection();)  
{  
conn.Open();  
using(SqlCommand cmd= conn.CreateCommand();)  
{string sql="insert into T\_Users(FuseName,Fpassword) values('王妃','555')"  
cmd.CommandText=sql;  
int r=cmd.ExecuteNonQuery();  
Label1.Text=r.ToString();  
\-------------  
string sp\_name="usp\_Login";  
//执行sql语句和执行存储过程最大的区别！需要设置一个commandType  
cmd.CommandText=CommandType.StoredProcedure;  
cmd.CommandText=sp\_name;  
SqlParameter prm1=new SqlParameter("@uname",username);  
SqlParameter prm2=new SqlParameter("@password",password);  
SqlParameter prm3=new SqlParameter("@result",System.Data.SqlDbType.Bit);

cmd.Parameters.Add(prm1);  
cmd.Parameters.Add(prm2);  
cmd.Parameters.Add(prm3);  
prm3.Direction=ParameterDirection.Output;

//int r=cmd.ExecuteNonQuery();  
//object obj=cmd.ExecuteNonQuery();  
bool b=Converrt.ToBoolean(prm3.value);  
if(b)  
{  
Label2.Text="登录成功";  
}  
else  
{  
Label2.Text="登录失败";  
}  
}  
}

}

create proc usp\_denglu  
@username2 nvarchar(10),  
@password varchar(20),  
@result bit output  
as  
begin

declare @count int  
set @count= (select * from T\_user where @username2=username and @password=password)  
if @count&gt;0  
begin  
print '登陆成功'  
end  
else  
begin  
print '登录失败'

end  
end