用户注册（检测用户名是否存在）

 private bool UserValild()
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sjk"]);
        con.Open();
        //查询用户输入的用户名是否存在
        string sql = "select * from admin where name='" + this.TextBox1.Text + "'";
        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataReader reader = cmd.ExecuteReader();
        //返回值检查
        if (reader.Read())
        {
            return false;
        }
        else
        {
            return true;
        }
        reader.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)//用户输入信息是否符合要求
        {
            if (UserValild())//数据库中是否已经存在该用户,若不存在，则新增一个用户
            {
                SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sjk"]);
                con.Open();
                //插入新用户
                string sql = "insert into admin (name,Password) values ('" + this.TextBox1.Text + "','" + this.TextBox2.Text + "')";
                SqlCommand cmd = new SqlCommand(sql,con);
                try
                {
                    cmd.ExecuteNonQuery();
                }
                catch
                {

                }
                finally
                {
                    cmd.Dispose();
                    con.Close();

                }
                Response.Redirect("cg.aspx");

            }
            else
            {
                Response.Redirect("bcg.aspx");
            }

        }
    }