一段设置用户禁用的代码

 1.首先在usertab表中有一个“state”字段，为0则禁用，为1则允许

2.登入页面的验证代码如下：

                 protected void Button1_Click(object sender, EventArgs e)
    {
                if (Select_jinyong(this.yonghuid.Text) == " 0")//调用禁用方法Select_jinyon();
        {
            MessageBox.Show(this, "...此用户已经禁用!");
            return;
        }

    }

          public string Select_jinyong(string code)
    {
        SqlConnection cn = new SqlConnection();
        cn.ConnectionString = new Common().GetConnectionString();//此处调用公共类common返回连接字符串；
        cn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select * from [usertab] where userID='" + code + "'";
        cmd.Connection = cn;
        SqlDataReader re = cmd.ExecuteReader();//数据库读取行的只进流形式

        if (re.HasRows)
        {

            while (re.Read())
            {
                //Response.Write(re["state"]);
                return re["state"].ToString();

            }
        }
        return null;

    }          

3.comm类代码

                    public class Common
{
    private string con = System.Configuration.ConfigurationSettings.AppSettings["con"];
    public Common()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    public string GetConnectionString()
    {
        return con;
    }
}