SqlConnection conn = new SqlConnection("server=.\\sqlexpress;integrated security=true;database=MobileSale");
string orderid = this.textBoxOrderId.Text;
string manid = this.textBoxManId.Text;
string mobileid = this.textBoxMobileId.Text;
string cusname = this.textBoxCusName.Text;
string sex=null;
if (this.radioButtonFemale.Checked == true)
sex = "女";
else
sex = "男";
int price = Convert.ToInt32(this.textBoxPrice.Text);
int num = Convert.ToInt32(this.textBoxSaleNum.Text);
int sum = price * num;
string datetime=Convert.ToString(System.DateTime.Now);
string sqlStr=("insert into Orderr(orderId,manId,mobileId,cusName,cusSex,salePrice,saleNum,saleSum,saleTime)values('orderid','manid','mobileid','cusname','sex','price','num','sum','datetime')");
conn.Open();
SqlCommand cmd = new SqlCommand(sqlStr, conn);
cmd.ExecuteNonQuery();
conn.Close();
我这不是把price类型转换了吗,怎么它报错题目那样的
------解决思路----------------------
sql都是错的,不想用参数化,也用占位啊
string sql=string.Format("insert into Orderr(orderId,manId,mobileId,cusName,cusSex,salePrice,saleNum,saleSum,saleTime)values('{0}','{1}','{2}','{3}','{4}',{5},{6},{7},'{8}')",orderid,manid,mobileid,cusname,sex,price,num,sum,datetime)