在SQL Server中如何实现记录的插入

[yangzhiwei27]

请问各位大虾，为什么执行insert into语句后Recordset指针就不能关闭了

_RecordsetPtr m_pRsc;
HRESULT hr = m_pRsc.CreateInstance (__uuidof(Recordset));
ASSERT(SUCCEEDED(hr));

_bstr_t bt = (_bstr_t)"insert into terminal values ('1','2','3')";

HRESULT hr = m_pRsc->Open(bt, m_pConnect.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
ASSERT(SUCCEEDED(hr));

m_pRsc->Close(); //错误类型不祥

[stonexl]

在OPEN中不能执行INSERT语句吧？
HRESULT hr = m_pRsc->Open("select * from terminal", m_pConnect.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
ASSERT(SUCCEEDED(hr));
CString bt = )"insert into terminal values ('1','2','3')";
m_pRsc->Execute(bt);

[yangzhiwei27]

执行是可以的，就是不能m_pRsc->Close