if (this.txtname.Text != "Tsoft")
{
SqlConnection con = DB.createDB();
con.Open();
SqlTransaction st = con.BeginTransaction();
SqlCommand cmd = con.CreateCommand();
cmd.Transaction = st;
try
{ cmd.CommandText = "insert into t_Admin(UserName,UserPwd,Ename,Email)values('" + this.txtname.Text + "','" + this.txtpwd.Text + "','" + this.txtEname.Text + "','" + this.txtEmail.Text + "')";
cmd.ExecuteNonQuery();
st.Commit();//提交事务
/* Response.Redirect("~/tishixinxi/success.aspx");*/
Response.Write("<script>alert('提交成功!');location='javascript:history.go(-1)'</script>");
}
catch (Exception error)
{
Response.Redirect("~/tishixinxi/fail.aspx");
st.Rollback();
}
con.Close();
}
else
{
Response.Write("<script>alert('很遗憾,请输入其他用户名!');location='javascript:history.go(-1)'</script>");
}
}
是不是这里有问题啊:cmd.CommandText = "insert into t_Admin(UserName,UserPwd,Ename,Email)values('" + this.txtname.Text + "','" + this.txtpwd.Text + "','" + this.txtEname.Text + "','" + this.txtEmail.Text + "')";
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
打个断点,跟踪一下代码不就很快能知道为什么没有入库嘛
string strSQL = "insert into t_Admin(UserName,UserPwd,Ename,Email) values('" + this.txtname.Text + "','" + this.txtpwd.Text + "','" + this.txtEname.Text + "','" + this.txtEmail.Text + "')";
Response.Write(strSQL); //将这个SQL语句输出,然后拿到查询分析器中执行一下看能否成功
cmd.CommandText = strSQL;