_RecordsetPtr  MySet;  
_ConnectionPtr  MyDb;  
void  CTestADODlg::OnButtonTest()    
{  
    MyDb.CreateInstance(__uuidof(Connection));  
    CString  strConnection;  
    strConnection.Format(_T("Provider=Microsoft.Jet.OLEDB.4.0;")  
                       _T("Data  Source=wireless.mdb"));  
    MyDb->Open((LPCTSTR)strConnection,"","",-1);  
    MySet.CreateInstance(__uuidof(Recordset));  
    MySet->Open("SELECT * FROM setdata",MyDb.GetInterfacePtr
                 (),adOpenStatic,adLockOptimistic,adCmdText); 
    m_ctrlDG.SetRefDataSource(MySet);  
    UpdateData(FALSE);  
}