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());
            }
        }