在线等，急，，初学者

Question

如果你界面输入的类型没错那把你方法体提供出来看看
OverAll.ReadTable.Opera_cmd()

Answer 1

public static int Opera_cmd(string sqlstr)
        {
            int back;
            SqlCommand MyComm = new SqlCommand(sqlstr, MyConn);
            MyConn.Open();
            back = MyComm.ExecuteNonQuery();
            MyConn.Close();
            return back;
        }

Answer 2

 MyComm.ExecuteNonQuery(); 这个的返回值是object  强制转换成Int

Answer 3

不好意思
刚才看错了if (OverAll.ReadTable.Opera_cmd(sqlstr)==-1) //MyComm.ExecuteNonQuery()没有返回-1的值吧
                    { 
                        Response.Write(" <script>"); 
                        Response.Write("alert('添加成功!');"); 
                        Response.Write(" </script>"); 
                    } 把你程序发给我
最好哈

Answer 4

protected void Page_Load(object sender, EventArgs e)
    {    }
    protected void CharCheck()
    {
        string username = this.username.Text;
        string errormag = "";
        if (username == "")
        {
            errormag += "用户名不能为空";        }
        string strTemp = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_";
        string[] aa = username.Split();
        for (int i = 0; i < username.Length; i++)
        {
            string a = username.Substring(i, 1).ToString();
            //Response.Write("a="+a+"<br>");
            int j = strTemp.IndexOf(a);
            //Response.Write(j.ToString()+",");
            if (j == -1)
            {
                errormag += " 4.用户名可使用字母、数字，下划线";
            }
        }
        if (errormag != "")
        {
            Response.Write("<Script>");
            Response.Write("alert('" + errormag + "');");
            Response.Write("</Script");
        }
        else
        {
            string strsql = "select * from user1 where username='" + this.username.Text + "'";
           
            Dt = OverAll.ReadTable.Opera_Select(strsql);
            if (Dt.Rows.Count > 0)
            {
                Response.Write("<Script>");
                Response.Write("alert('用户已经存在请用他名!');");
                Response.Write("</Script>");            }
            else if (this.password.Text !=this.pwdtext.Text)
            {
                Response.Write("<Script>");
                Response.Write("alert('两次密码不一样!');");
                Response.Write("</Script>");
            }            else
            {
                string sqlstr = "insert inot user1(username,password) values('" + this.username.Text + "','" + this.password.Text + "')";
                try
                {
                    if (OverAll.ReadTable.Opera_cmd(sqlstr)!=-1)
                    {
                        Response.Write("<script>");
                        Response.Write("alert('添加成功!');");
                        Response.Write("</script>");
                    }                    string sqlstr1 = "Select * from User1 where username='" + this.username.Text + "' and password='" + this.password.Text + "'";
                    
                    Dt = OverAll.ReadTable.Opera_Select(sqlstr);
                    if (Dt.Rows.Count != 0)
                    {
                        Session["ID"] = Dt.Rows[0]["ID"].ToString();
                        Session["username"] = Dt.Rows[0]["UserName"].ToString();
                        Response.Redirect("default.aspx");
                    }
                    else
                    {
                        Response.Write("<Script>");
                        Response.Write("alert('用户或密码错误。');");
                        Response.Write("</Script>");
                    }                }
                catch
                {
                    Response.Write("<Script>");
                    Response.Write("alert('出现异常!');");
                    Response.Write("</Script>");
                }              }        }
    }
    protected void btnRegister_Click(object sender, System.EventArgs e)
    {
        this.CharCheck();    }
    protected void a_Click(object sender, System.EventArgs e)
    {
        this.username.Text = "";
        this.password.Text = "";
        this.realname.Text = "";
        this.tel.Text = "";
        this.yzbm.Text = "";    }
}

Answer 5

把try  去掉
看程序在那行代码停下

Answer 6

string sqlstr = "insert inot user1(username,password) values('" + this.username.Text + "','" + this.password.Text + "')"; 

Answer 7

不会是into写错了吧！新手就多调试，DEBUG一下

Answer 8

首先 OverAll.ReadTable.Opera_cmd(sqlstr) > 0 的话就表示插入进去了你这逻辑....... 刚注册了马上就进行登录???

Answer 9

还有 看看是不是单引号啊 逗号啊 应该用英文符号加个断点,获取到sql语句 直接去查询分析器里面试试 就知道哪有错了