[ADO学习笔记] Recordset 对象中的updateBatch函数的使用方法

1.设置 pRecord->CursorLocation = adUseClient;

2.open方法中设置lockType 为adLockBatchOptimistic

3.例子说明：

_RecordsetPtr pRecord;
	pRecord.CreateInstance("ADODB.Recordset");

	pRecord->CursorLocation = adUseClient;

	CString strSQL	;
	strSQL.Append("SELECT * fROM emp ");
	
	try
	{
		pRecord->Open(_bstr_t(strSQL),pConnection.GetInterfacePtr(),adOpenStatic,adLockBatchOptimistic,adCmdText);

		CString strValue;
		while(!pRecord->AdoEOF)
		{
			strValue.Format("Test_%d",pRecord->AbsolutePosition);
			pRecord->PutCollect("name",_variant_t(strValue));
			pRecord->MoveNext();
		}

		pRecord->UpdateBatch(adAffectAll);
		pRecord->Close();
	}
	catch(_com_error &e)
	{
		OutputDebugString(e.Description());
	}