注册 登录
编程论坛 ASP.NET技术论坛

数据库插值问题

wyalwy 发布于 2010-09-09 21:28, 669 次点击
提示: VS2005 并不报错 也就是没有语法错误  
可是数据库中没有插入的数据,设置断点编译表明reVale 的值为0
也就是说 reVale = db.sqlEx(cmdstr); 调用方法出现问题


 protected void btnRegister_Click(object sender, EventArgs e)
    {
        int reVale = CheckName();
        if (reVale == 1)
        {
            Response.Write(db.MessageBox("该用户存在,请重新设置!", "Register.aspx"));
        }
        else
        {
            string UserName = this.txtUserName.Text;
            string PassWord = this.txtPwd.Text;
            string Emial = this.txtEmail.Text;
            string cmdstr = "insert into tb_User(UserName,PassWord,Emial)Values('" + UserName + "','" + PassWord + "','" + Emial + "')";
            try
            {
                reVale = db.sqlEx(cmdstr);
                if (reVale == 1)
                {
                    Response.Write(db.MessageBox("注册成功!", "Register.aspx"));
                    Clear();//清空文本框
                }
                else if (reVale == 0)
                {
                    Response.Write(db.MessageBox("注册失败!", "Register.aspx"));
                }
            }
            catch
            {
                Response.Write(db.MessageBox("注册失败!", "Register.aspx"));
            }
        }
    }


public int sqlEx(string cmdstr)
    {
        SqlConnection con = new SqlConnection(connstring);
        con.Open();
        SqlCommand cmd = new SqlCommand(cmdstr, con);
        try
        {
            cmd.ExecuteNonQuery();//执行这一句出现异常
            return 1;
        }
        catch (Exception e)
        {
            return 0;
        }
        finally
        {
            con.Dispose();
        }

    }
3 回复
#2
红色警戒2010-09-09 23:49
执行插入时肯定出错了,抛出了异常,你在sqlEx(string cmdstr)
函数中也加入弹出e.message看看是什么错误
#3
Issac_abc2010-09-10 11:35
try 里内容 应该 这样写
       try
        {   
            int result = cmd.ExecuteNonQuery();
            return result;
        }
            
#4
wyalwy2010-09-10 18:00
以下是引用红色警戒在2010-9-9 23:49:31的发言:

执行插入时肯定出错了,抛出了异常,你在sqlEx(string cmdstr)
函数中也加入弹出e.message看看是什么错误

   
   非常感谢,你的方法果然有效!很快就查到了问题所在  谢谢! 分就全给你啦!
1