//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