怎么把整形值写进数据库？

Question

m_pRecordset->AddNew();
m_pRecordset->PutCollect("FoodID",(_bstr_t)si->FoodID);  //si->FoodID是整形值
m_pRecordset->PutCollect("FoodNamev",(_bstr_t)si->FoodName);
m_pRecordset->PutCollect("Price",(_bstr_t)"si->price");
m_pRecordset->PutCollect("Subordinate",(_bstr_t)si->CanteenName);
m_pRecordset->PutCollect("PriceSpecial",(_bstr_t)si->PriceSpecial);
m_pRecordset->PutCollect("FoodNew",(_bstr_t)si->FoodNew);
m_pRecordset->PutCollect("FoodStatus",(_bstr_t)si->FoodStatus);
m_pRecordset->Update();
就是出错   怎么把整形值写进数据库？

Answer 1

m_pRecordset->PutCollect("FoodID",(_bstr_t)(_variant_t)si->FoodID); //si->FoodID是整形值

Answer 2

http://blog.csdn.net/zyq5945/archive/2010/05/12/5581453.aspx

Answer 3

这样
CString str;
str.Format("%d",FoodID);
m_pRecordset->PutCollect("str",(_bstr_t)si->FoodID);