主题:求助!用C#和SQL做一个密码验证。急!!!
huyga123
[专家分:0] 发布于 2010-05-24 16:38:00
用C#和SQL做一个密码验证程序,但确认按键钮的事件怎么写呀。小第新手不要笑我,下面是我的代码,请高手指点:
private void button2_Click(object sender, EventArgs e)
{
string str1,str2,str3;
string source = "source=localhost;uid=sa;database=databaseName";
str1 = this.textBoxName.Text;
str2 = this.textBoxPass.Text;
str3 = "select 密码 from 操作员 where ID号 = '" + str1 + "'";
if (str3 == str1)
MessageBox.Show("成功");
}
回复列表 (共3个回复)
沙发
ltm1209 [专家分:0] 发布于 2010-06-02 15:09:00
请问,你是登陆验证还是修改密码验证?
板凳
52aya [专家分:30] 发布于 2010-06-02 20:50:00
str1和str3都是字符串,他们是不相等的哦。
3 楼
ltm1209 [专家分:0] 发布于 2010-06-05 00:46:00
protected void Button1_Click(object sender, EventArgs e)
{
string userName = txtUserName.Text.Trim();
string password = txtPwassword.Text.Trim();
string yes0rno = UserManage.Login(userName, password);
Response.Write(yes0rno);
}
public static string Login(String name, string psd)
{
User user = UserService.SelectUserByLoginId(name);
if (user == null)
{
return "登陆失败";
}
else
{
if (user.LoginPwd == psd)
{
return "登陆成功";
}
else
{
return "用户名密码错误";
}
}
}
public static User SelectUserByLoginId(String loginId)
{
User user = null;
string sql = "SELECT * FROM USERS WHERE LOGINID=@name";
SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@name", loginId) };
using (SqlConnection con = new SqlConnection(DBHelp.connectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddRange(parm);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
user = new User();
user.Id = (int)dr["id"];
user.LoginId = (string)dr["LoginId"];
user.LoginPwd = (string)dr["LoginPwd"];
user.Name = (string)dr["Name"];
user.Address = (string)dr["Address"];
user.Phone = (string)dr["Phone"];
user.Mail = (string)dr["Mail"];
}
}
我来回复