CData data;
CString server="MySchool";
data.OnInitADOConn(server);
_bstr_t sql="SELECT * from Student";
_RecordsetPtr recordSet=data.GetRecordSet(sql,server);
_variant_t var;
string str;
while (!recordSet->adoEOF)
{
int admin;
var=recordSet->GetCollect("StudentId");
admin=var.intVal;
var=recordSet->GetCollect("LoginId");
str=string(_bstr_t(var.bstrVal));
cout<<admin<<'\t'<<str<<(int)str.length()<<endl;
recordSet->MoveNext();
}
data.ExitConnect();
