Convert.ToInt32(txtTotalPersons.Text)类型转换问题:
我的代码如下:
SqlCommand insertCMD=new SqlCommand("INSERT INTO dormrooms VALUES(@roomNum,@roomSex,@totalPersons,@initialAmmeters,@initialWatermeters,@roomWares)",roomConn);
insertCMD.Parameters.Add(new SqlParameter("@roomNum",SqlDbType.Char,10));
insertCMD.Parameters["@roomNum"].Value=txtRoomNum.Text;
insertCMD.Parameters.Add(new SqlParameter("@roomSex",SqlDbType.Char,10));
insertCMD.Parameters["@roomSex"].Value=ddlSex.SelectedItem.Text;
insertCMD.Parameters.Add(new SqlParameter("@totalPersons",SqlDbType.Int,4));
insertCMD.Parameters["@totalPersons"].Value=Convert.ToInt32(txtTotalPersons.Text);
insertCMD.Parameters.Add(new SqlParameter("@initialAmmeters",SqlDbType.Int,4));
insertCMD.Parameters["@initialAmmeters"].Value=Convert.ToInt32(txtAmmeters.Text);
insertCMD.Parameters.Add(new SqlParameter("@initialWatermeters",SqlDbType.Int,4));
insertCMD.Parameters["@initialWatermeters"].Value=Convert.ToInt32(txtWatermeters.Text);
insertCMD.Parameters.Add(new SqlParameter("@roomWares",SqlDbType.Text,16));
insertCMD.Parameters["@roomWares"].Value=txtRoomWares.Text;
insertCMD.Connection.Open();
insertCMD.ExecuteNonQuery();
我认为没有问题了,类型已经转化了,可是有如下错误:
操作数类型冲突: int 与 text 不兼容操作数类型冲突: text 与 int 不兼容
请指教!