C#操作数据库存储过程 用户登录验证

//C#操作数据库存储过程 用户登录验证

protected void btnLogin_Click(object sender, EventArgs e)

{

sqlconn.Open();

SqlCommand sqlcom = new SqlCommand("proMemberInfo", sqlconn);

sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add("@MemberName", SqlDbType.VarChar, 20).Value = txtMName.Text.Trim();

sqlcom.Parameters.Add("@MemberPwd", SqlDbType.VarChar, 20).Value = txtMPwd.Text.Trim();

SqlDataReader read = sqlcom.ExecuteReader();

if (read.Read())

{

Panel1.Visible = true;

Panel2.Visible = false;

MName.Text = txtMName.Text;

Session["MName"] = txtMName.Text.Trim();

}

else

{

Response.Write("<script>alert('您输入的用户名或密码错误，请重新输入！');location='javascript:history.go(-1)';</script>");

}

}

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[proMemberInfo]

(@MemberName varchar(20),@MemberPwd varchar(20))

as

select * from tb_Member where MemberName=@MemberName and MemberPwd=@MemberPwd