SQL中定义的存储过程参数VARCHAR,在VC中用什么数据类型的参数匹配?
解决方案 »
- VC++自定义控件的使用问题
- 求助关于WIndows下数据实时存储与现实
- 如何让MessageBox里头的信息能拷贝呢?
- 感叹! 爱情是两个人的问题,结婚是两个家庭的问题!
- 关于time.GetCurrentTime();的使用,求救。
- vb怎样取得从VC的DLL里传来的字符串
- VS2K2中我修改了图表资源,为什么程序运行的时候还是原来那个老图标那?
- 菜问题:对话框的最大最小化按钮如何弄出来。
- 一个有关指针的问题
- 在COM中,这是为什么?fatal error:WINDOWS.H already included。MFC apps must not #include <windows.h>
- 单个进程实例的问题
- 如何实现其他程序的窗口化?
pParamMember.CreateInstance("ADODB.Parameter");
pParamMember->Name = "UseName";//参数名
pParamMember->Type = char*;//参数类型
pParamMember->Size = 20;
pParamMember->Direction = adParamInput;//表明是输入参数
pParamMember->Value = _variant_t(m_strUser);//参数值错误:error C2062: type 'char' unexpected //输入参数Member
_ParameterPtr pParamMember;
pParamMember.CreateInstance("ADODB.Parameter");
pParamMember->Name = "UseName";//参数名
pParamMember->Type = CString;//参数类型
pParamMember->Size = 20;
pParamMember->Direction = adParamInput;//表明是输入参数
pParamMember->Value = _variant_t(m_strUser);//参数值
错误: error C2275: 'CString' : illegal use of this type as an expression
发出来大家看看!
其实这类型在ADO已经枚举了!
enum DataTypeEnum
{
adEmpty = 0,
adTinyInt = 16,
adSmallInt = 2,
adInteger = 3,
adBigInt = 20,
adUnsignedTinyInt = 17,
adUnsignedSmallInt = 18,
adUnsignedInt = 19,
adUnsignedBigInt = 21,
adSingle = 4,
adDouble = 5,
adCurrency = 6,
adDecimal = 14,
adNumeric = 131,
adBoolean = 11,
adError = 10,
adUserDefined = 132,
adVariant = 12,
adIDispatch = 9,
adIUnknown = 13,
adGUID = 72,
adDate = 7,
adDBDate = 133,
adDBTime = 134,
adDBTimeStamp = 135,
adBSTR = 8,
adChar = 129,
adVarChar = 200,
adLongVarChar = 201,
adWChar = 130,
adVarWChar = 202,
adLongVarWChar = 203,
adBinary = 128,
adVarBinary = 204,
adLongVarBinary = 205,
adChapter = 136,
adFileTime = 64,
adPropVariant = 138,
adVarNumeric = 139,
adArray = 8192
};