下面是向数据库中插入值的一段代码。运行时没出错,为什么数据库表中没有插入时的数据啊?这段代码错在哪里了啊?
SqlCommand sqlcomm1 = new SqlCommand("insert into Worker values"+"(@WorkerID,@WorkerName,@WorkerLogin,@WorkerPassword,@Birthday,@WorkerEmail,@BranchnumID,@WorkerCompensation,@Wposition,@Wphone)");
sqlcomm1.Parameters.AddWithValue("@WorkerID",textBox5.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerName",textBox1.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerLogin" , textBox2.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerPassword",textBox3.Text);
sqlcomm1.Parameters.AddWithValue("@Birthday" , textBox9.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerEmail" , textBox5.Text);
sqlcomm1.Parameters.AddWithValue("@Wposition" , textBox7.Text);
sqlcomm1.Parameters.AddWithValue("@BranchnumID" ,comboBox3.Text);
sqlcomm1.Parameters.AddWithValue("@Wphone" ,textBox8.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerCompensation" , textBox11.Text);
sqlcomm1.ExecuteNonQuery();
textBox5.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox11.Text = "";
SqlCommand sqlcomm1 = new SqlCommand("insert into Worker values"+"(@WorkerID,@WorkerName,@WorkerLogin,@WorkerPassword,@Birthday,@WorkerEmail,@BranchnumID,@WorkerCompensation,@Wposition,@Wphone)");
sqlcomm1.Parameters.AddWithValue("@WorkerID",textBox5.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerName",textBox1.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerLogin" , textBox2.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerPassword",textBox3.Text);
sqlcomm1.Parameters.AddWithValue("@Birthday" , textBox9.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerEmail" , textBox5.Text);
sqlcomm1.Parameters.AddWithValue("@Wposition" , textBox7.Text);
sqlcomm1.Parameters.AddWithValue("@BranchnumID" ,comboBox3.Text);
sqlcomm1.Parameters.AddWithValue("@Wphone" ,textBox8.Text);
sqlcomm1.Parameters.AddWithValue("@WorkerCompensation" , textBox11.Text);
sqlcomm1.ExecuteNonQuery();
textBox5.Text = "";
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox9.Text = "";
textBox5.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox11.Text = "";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货