C / C++ / MFC

KeyValueMap::iterator it = m_EditkeyValueMap.begin();

    for (; it != m_EditkeyValueMap.end(); it++)
    {

        CString key0 = (*it).first;
        CString value0 = (*it).second;

        if (value0=="") value0 = "_";

        key0.TrimLeft();
        key0.TrimRight();
        key0.Replace(' ', '_');

        char* key = new char[key0.GetLength()+1];

        char* value = new char[value0.GetLength()+1];

        strcpy(key,key0);

        strcpy(value, value0);

        m_pRecordset->Fields->Item[key]->Value = value;  ///the main operation

        delete[] key;

        delete[] value;
    }

        m_pRecordset->Update();