我有2页登录和注册。我正在检查用户名是否可用或not.and,我已经为it.but编写了代码,我无法阻止在注册按钮上在数据库中插入相同的用户名。我怎么能这么做?
这是我注册page的代码。我在注册页面上选了一个linkbutton -
protected void LinkButton1_Click1(object sender, EventArgs e)
{
conn.Open();
cmd = new SqlCommand("select * from login where username='" + txtname.Text + "'", conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
Label1.Text = "Username already exists";
}
else
{
Label1.Text = "Username available";
}
}发布于 2014-01-16 12:01:46
您应该使用内置于MembershipProvider中的asp.net类。
不过,如果您想坚持您的代码,那么在查询中使用IF(EXISTS)
IF(EXISTS(SELECT * FROM UserMaster WHERE LOWER(UserName) = LOWER('test')))
BEGIN
SELECT 'TRUE'
END
ELSE
BEGIN
SELECT 'FALSE'
END然后使用cmd.ExecuteScalar函数检查返回的值是true还是false
C#代码:(更新)
conn.Open();
cmd = new SqlCommand(@" IF(EXISTS(SELECT * FROM UserMaster WHERE LOWER(UserName) = LOWER(@username)))
BEGIN
SELECT 'TRUE'
END
ELSE
BEGIN
SELECT 'FALSE'
END", conn);
cmd.Parameters.AddWithValue("@username", "test");
bool exists = Convert.ToBoolean(cmd.ExecuteScalar());
if (exists)
{
Label1.Text = "Username already exists";
}
else
{
Label1.Text = "Username available";
}https://stackoverflow.com/questions/21160956
复制相似问题