帮我看看这个 insert 为什么插入不进去
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Zhuce : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void botton1_Click(object sender, EventArgs e)
{
try
{
string insert = "insert into [Q_user](userid,password,email,gongsi,province,city,phone,mphone,zcdata)";
insert += " values (@userid,@password,@email,@gongsi,@province,@city,@phone,@mphone,@zcdata)";
SqlConnection conn = new SqlConnection("server=.;database=a123;user id=sa;password=sa");
conn.Open();
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.Parameters.Add("@userid", SqlDbType.VarChar).Value = this.username.Text.Trim();
cmd.Parameters.Add("@userid", SqlDbType.VarChar).Value = this.pwdbox.Text.Trim();
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = this.emailbox.Text.Trim();
cmd.Parameters.Add("@gongsi", SqlDbType.VarChar).Value = this.gsname.Text.Trim();
cmd.Parameters.Add("@province", SqlDbType.VarChar).Value = this.province.Text.Trim();
cmd.Parameters.Add("@city", SqlDbType.VarChar).Value = this.city.Text.Trim();
cmd.Parameters.Add("@phone", SqlDbType.VarChar).Value = this.phone.Text.Trim();
cmd.Parameters.Add("@mphone", SqlDbType.VarChar).Value = this.mphoneBox.Text.Trim();
cmd.Parameters.Add("@zcdata", SqlDbType.DateTime).Value = DateTime.Now;
cmd.ExecuteNonQuery();//这个是插入语句吗?
cmd.Clone();
conn.Close();
}
catch
{ }
}
}
[解决办法]
程序有没有出错呢
你的cmd.parameters.Add("@userid")重复了次 但是密码没有赋值
[解决办法]
cmd.Parameters.Add("@userid", SqlDbType.VarChar).Value = this.username.Text.Trim();
cmd.Parameters.Add("@userid", SqlDbType.VarChar).Value = this.pwdbox.Text.Trim();
重复了,还有就是不是varchar类型
改成SqlDbType.Int
[解决办法]
cmd.Parameters.Add("@userid", SqlDbType.VarChar).Value = this.pwdbox.Text.Trim();
改为
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = this.pwdbox.Text.Trim();
[解决办法]
除了上面的问题,还有如下:
如果你连的是SQL Server数据库,那么SqlConnection conn = new SqlConnection("server=.;database=a123;user id=sa;password=sa");
应该为SqlConnection conn = new SqlConnection("server=.\sqlexpress;database=a123;user id=sa;password=sa");