我使用的数据库是sqlserver,其中的表为STUDENTS,它有两个字段StuYear和ComYear是datetime类型,开发环境是vc++,有一个对话框类CStuDLG,其中的两个DateTimeCtrl控件分别对应两个ctime类型的变量m_StuYear和m_ComYear,这也与表中的属性对应。
我写了一条sql插入语句:
CStuDLG myStuDlg;
cstring mySql;mySql="insert into STUDENTS values('"+myStuDlg.m_StuID+"',"+myStuDlg.m_StuYear+","+myStuDlg.m_ComYear+")";
m_database.ExecuteSQL(mySql);其中m_StuID是cstring类型,m_StuYear和m_ComYear是ctime类型
这样会报错error C2679: binary '+' : no operator defined which takes a right-hand operand of type 'class CTime' (or there is no acceptable conversion)
我的insert语句应该怎么写啊?
我写了一条sql插入语句:
CStuDLG myStuDlg;
cstring mySql;mySql="insert into STUDENTS values('"+myStuDlg.m_StuID+"',"+myStuDlg.m_StuYear+","+myStuDlg.m_ComYear+")";
m_database.ExecuteSQL(mySql);其中m_StuID是cstring类型,m_StuYear和m_ComYear是ctime类型
这样会报错error C2679: binary '+' : no operator defined which takes a right-hand operand of type 'class CTime' (or there is no acceptable conversion)
我的insert语句应该怎么写啊?
CString sStuYear,sComYear;sStuYear=m_StuYear.Format("%Y-%m-%d");
sComYear=m_ComYear.Format("%Y-%m-%d");
mySql="insert into STUDENTS values('"+sStuYear+"','"+sComYear+"');
m_database.ExecuteSQL(mySql);