增删改查

[真好]

web.config
<configuration>
<connectionStrings>
<add name="Forum" connectionString ="Persist Security Info=False;Integrated Security=true;database=Forum-1.0;server=."/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
</configuration>



Dbhelper.cs
public class Dbhelper
{
string connstring = "";
public Dbhelper()
{
connstring = WebConfigurationManager.ConnectionStrings["Forum"].ConnectionString;
//
//TODO: 在此处添加构造函数逻辑
//
}
public int insert(string sql,params SqlParameter[]sqlparameters)
{

using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
foreach (SqlParameter pa in sqlparameters)
{
cmd.Parameters.Add(pa);

}
int x = cmd.ExecuteNonQuery();

return x;
}
}
}



register.aspx.cs
public partial class register : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void btn_register_Click(object sender, EventArgs e)
{
Dbhelper db = new Dbhelper();
string sql = "insert into Users values(@txt_username,@txt_password)";
SqlParameter pa_username = new SqlParameter("@txt_username", txt_username.Text);
SqlParameter pa_password = new SqlParameter("@txt_password", txt_password.Text);
int x=db.insert(sql, pa_username, pa_password);
TextBox2.Text = x.ToString() + "行受影响！";
}
}
单击后，未显示“1 行受影响！”查看数据库，未插入数据，

[坚-持]

调试下检查sql语句

[dalmeeme]

设断点在return x;上，调试看看各变量对象的值，以及它们是否都执行了。

[yuji821]

调试下，应该很简单的，相信自己

[CalvinR]

你插入数据有问题啊

[真好]

现在调好了，多谢了！

[阿非]

你可以把SQL 单独放在数据库中运行调试的

也可以借助 sql profiler