各位大神啊,小弟做课 程设计时吧时间控件里的时间放到数据库中
ADO m_Ado;
m_Ado.OnInitADOConn();
CString sql = "select * from Table_员工信息";
m_Ado.m_pRecordset = m_Ado.OpenRecordset(sql);
try
{
m_Ado.m_pRecordset->AddNew(); //添加新行
m_Ado.m_pRecordset->PutCollect("员工ID",(_bstr_t)m_EmpID);
m_Ado.m_pRecordset->PutCollect("员工部门ID",(_bstr_t)m_EmpapartID);
m_Ado.m_pRecordset->PutCollect("实发工资",(_bstr_t)m_Realsalary);
m_Ado.m_pRecordset->PutCollect("扣税款额",(_bstr_t)m_Tax);
m_Ado.m_pRecordset->PutCollect("统计时间",(_bstr_t)m_Time);
在最后一行出错,提示 : error C2440: 'type cast' : cannot convert from 'class CTime' to 'class _bstr_t'
搞不懂啊,纠结了几个小时,谁告诉我怎么解决啊,感激不进,
在线==============================================================
ADO m_Ado;
m_Ado.OnInitADOConn();
CString sql = "select * from Table_员工信息";
m_Ado.m_pRecordset = m_Ado.OpenRecordset(sql);
try
{
m_Ado.m_pRecordset->AddNew(); //添加新行
m_Ado.m_pRecordset->PutCollect("员工ID",(_bstr_t)m_EmpID);
m_Ado.m_pRecordset->PutCollect("员工部门ID",(_bstr_t)m_EmpapartID);
m_Ado.m_pRecordset->PutCollect("实发工资",(_bstr_t)m_Realsalary);
m_Ado.m_pRecordset->PutCollect("扣税款额",(_bstr_t)m_Tax);
m_Ado.m_pRecordset->PutCollect("统计时间",(_bstr_t)m_Time);
在最后一行出错,提示 : error C2440: 'type cast' : cannot convert from 'class CTime' to 'class _bstr_t'
搞不懂啊,纠结了几个小时,谁告诉我怎么解决啊,感激不进,
在线==============================================================
不知道_bstr_t是什么,如果是字符或是整型的话,可以用CTime::GetDay之类的函数将CTime中的时间转成数据库认识的类型。
急啊
CString str = m_Time.Format("%Y-%m_5d %H:%M:%S")
然后再插入