using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class Scripts_Default : System.Web.UI.Page
{
protected void Button3_Click(object sender, EventArgs e)
{
string Name = TextBox1.Text.Trim();
string Password = TextBox2.Text.Trim();
string Password1 = TextBox3.Text.Trim();
String strCon = "Data Source=127.0.0.1;Integrated Security=SSPI ; Initial Catalog=user";
SqlConnection conn = new SqlConnection(strCon);
conn.Open();
string sql = "insert into [yl] values('" + 3 + "','" + Name + "','"+Password+"')";
SqlCommand cmd = new SqlCommand(sql, conn); int i = cmd.ExecuteNonQuery();
if (i> 0)
{
Response.Write("<script>alert('注册成功');</script>");
}
else
{
Response.Write("<script>alert('注册不成功,请检查输入信息');</script>");
}
conn.Close();
}
}
我这个注册页面为什么 不能使数据库添加数据呢
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class Scripts_Default : System.Web.UI.Page
{
protected void Button3_Click(object sender, EventArgs e)
{
string Name = TextBox1.Text.Trim();
string Password = TextBox2.Text.Trim();
string Password1 = TextBox3.Text.Trim();
String strCon = "Data Source=127.0.0.1;Integrated Security=SSPI ; Initial Catalog=user";
SqlConnection conn = new SqlConnection(strCon);
conn.Open();
string sql = "insert into [yl] values('" + 3 + "','" + Name + "','"+Password+"')";
SqlCommand cmd = new SqlCommand(sql, conn); int i = cmd.ExecuteNonQuery();
if (i> 0)
{
Response.Write("<script>alert('注册成功');</script>");
}
else
{
Response.Write("<script>alert('注册不成功,请检查输入信息');</script>");
}
conn.Close();
}
}
我这个注册页面为什么 不能使数据库添加数据呢
1.确实数据库有没有正确连上。
2.在debug下把sql语句watch出来,然后在数据库工具里执行,看看结果。
测试方法:把sql语句放到新建的查询窗口测试一下就知道了.
另外,注意一下数据类型
Response.Write("<script>alert('注册成功');</script>");
用:
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('成功!')</script>");