怎么样向带参数的ado.command传入NULL值
adoCom.CommandText = "Insert Into Ms_MaterialUserRole(cUser_Id,iRole,cCardNo,iMinJe,iMaxJe) Values(?,?,?,?,?)"
adoCom.Parameters.Append adoCom.CreateParameter("@cUser_Id", adVarChar, adParamInput, 12, m_cUserId)
adoCom.Parameters.Append adoCom.CreateParameter("@iRole", adInteger, adParamInput, 4, 2)
adoCom.Parameters.Append adoCom.CreateParameter("@cCardNo", adVarChar, adParamInput, 50, Trim(txtCardNo.Text))
adoCom.Parameters.Append adoCom.CreateParameter("@iMinJe", adCurrency, 8, Null)
adoCom.Parameters.Append adoCom.CreateParameter("@iMaxJe", adCurrency, 8, Null)
adoCom.Execute iNewRow
执行时出现错误:
实时错误:'94'
无效使用null
我想向@iMinJe和@iMaxJe传入NULL值,该怎么做?
[解决办法]
adoCom.Parameters.Append adoCom.CreateParameter("@iMinJe", adCurrency, 8)
adoCom.Parameters.Append adoCom.CreateParameter("@iMaxJe", adCurrency, 8)
不传值,貌似就是null
