BYTE bUid[20], bPwd[20];
char test[20];
VARIANT rst;
VariantInit(&rst);
CString csSql = _T("SELECT * FROM UserTb;");
if(wicDB.ExecuteSQL(csSql))
{
wicDB.MoveFirst();
rst = wicDB.GetCollect(_T("uid"));
WideCharToMultiByte (CP_OEMCP, NULL, rst.bstrVal, -1, test, sizeof(test), NULL, FALSE);
memcpy(bUid, test, sizeof(bUid));
csSql.Format(_T("%s"),bUid);
//MessageBox(NULL, csSql, _T("OpenRecordset"), MB_OK);
}