我的数据库是ACCESS的,网站后台有个添加管理员的功能,关键是如何在添加之前判断是否存在该用户名?通过那些返回值判断?
添加管理员代码: try
{
dl.ExecuteSQL("insert into ck_Admin(AdminName,AdminPass)values('" + TextBox3.Text.Trim() + "','" + DAL.Md5(TextBox4.Text.Trim()) + "')");
Label1.Text = "添加成功!";
InfoBind();
}如何禁止删除“admin”用户?
添加管理员代码: try
{
dl.ExecuteSQL("insert into ck_Admin(AdminName,AdminPass)values('" + TextBox3.Text.Trim() + "','" + DAL.Md5(TextBox4.Text.Trim()) + "')");
Label1.Text = "添加成功!";
InfoBind();
}如何禁止删除“admin”用户?
//检查重复
object o = dl.ExecuteScalar("select AdminName from ck_Admin where AdminName='"+str+"'");
if (o==null)
{
dl.ExecuteSQL("insert into ck_Admin(AdminName,AdminPass)values('" + TextBox3.Text.Trim() + "','" + DAL.Md5(TextBox4.Text.Trim()) + "')");
Label1.Text = "添加成功!";
InfoBind();}
http://www.cnblogs.com/insus/articles/1407256.html
http://www.cnblogs.com/insus/articles/1654670.html
IF用户名等于“admin”
提示不允许删除else...
if(i!=0){添加用户};
delete ck_Admin where id=@id and AdminName<>'admin'
至于新增是否重复,在写一个方法(相信这个方法你应该有的)
public static UserInfo GetUser(string username)
{
……
}在你新增用户的函数里面加上一个判断
if(新增的用户名=GetUser(新增的用户名).UserName)
{
string msg="用户已存在";
return;
}
else//新增逻辑