insert成功,返回值为1,但是数据库表中没有
开发工具vs11+sql sever 2010rc0链接:
public partial class regist : Form
{
string ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\data.mdf;Integrated Security=True";
public regist()按钮事件:
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
int i;
string cmd = "insert into users (userid,password,username,usersex,userage,usercall) values(";
cmd += "N'" + this.textBox1.Text + "',";
cmd += "N'" + this.textBox2.Text + "',";
cmd += "N'" + this.textBox4.Text + "',";
cmd += "N'" + this.comboBox1.Text + "',";
cmd += "" + Convert.ToInt32(this.textBox5.Text) + ",";
cmd += "" + Convert.ToInt32(this.textBox6.Text) + ")";
SqlCommand mycmd = new SqlCommand(cmd, conn);
i=mycmd.ExecuteNonQuery();
conn.Close();
if(i>0)
MessageBox.Show(i.ToString());
}
}
开发工具vs11+sql sever 2010rc0链接:
public partial class regist : Form
{
string ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\data.mdf;Integrated Security=True";
public regist()按钮事件:
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
int i;
string cmd = "insert into users (userid,password,username,usersex,userage,usercall) values(";
cmd += "N'" + this.textBox1.Text + "',";
cmd += "N'" + this.textBox2.Text + "',";
cmd += "N'" + this.textBox4.Text + "',";
cmd += "N'" + this.comboBox1.Text + "',";
cmd += "" + Convert.ToInt32(this.textBox5.Text) + ",";
cmd += "" + Convert.ToInt32(this.textBox6.Text) + ")";
SqlCommand mycmd = new SqlCommand(cmd, conn);
i=mycmd.ExecuteNonQuery();
conn.Close();
if(i>0)
MessageBox.Show(i.ToString());
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货