variant_tvUsername,vID,vname;//变量声明_RecordsetPtrm_pRecordset;//记录集CStringstrid;_ConnectionPtrconnection;m_pRecordset.CreateInstance(__uuidof(Recordset));//创建实例m_pRecordset->Open("SELECT*FROMusers",connection.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);//执行SQL语句,得到记录集,connection必须已和数据库