A question on ADO and Microsoft DataGrid Control

Hail all,

I'm using ADO DC together Microsoft DataGrid Control in my existing C++/MFC application. At the moment I urgently need to create tree-like view in this grid (something like in Microsoft Access when viewing related tables - when you could open/collapse child recordsets by clicking on [+] in rows of parent recordset).

Do anyone have an idea ho to implement it using Microsoft DataGrid Control ???

Below is the code illustrating how I bind grid to ADO recordset (m_pGrid is an object of wrapper-class CDataGrid):

Code:

C_Recordset& rc=m_ctlADODC.GetRecordset(); m_pGrid.SetRefDataSource(NULL); m_pGrid.SetRefDataSource(rc); m_pGrid.SetAllowAddNew(FALSE);// allow empty '*'-field at top m_pGrid.SetAllowUpdate(FALSE);// disallow editing current records m_pGrid.SetAllowDelete(FALSE);// disallow deleting by pressing Del m_pGrid.SetAllowArrows(TRUE); // allow arrows keys m_pGrid.Refresh(); m_pGrid.UpdateData();

And the following is the way i use to open ADO data source (m_ctlADODC encapsulates Microsoft ADODC Control,
an object of wrapper-class CAdodc):

Code:

CHAR szTemp[256]; ::sprintf(szTemp,"SELECT * FROM [%s] ORDER BY [%s]",table_db_dao,field_id); m_ctlADODC.SetConnectionString(NULL); m_ctlADODC.SetMaxRecords(ADODC_MAX_RECORDS); m_ctlADODC.SetCacheSize(ADODC_CACHE_SIZE); m_ctlADODC.SetRecordSource(NULL); lstrcat(szConnectionString,GetDocument()->GetPathName()); lstrcat(szConnectionString,_T(";")); m_ctlADODC.SetConnectionString(szConnectionString); m_ctlADODC.SetRecordSource(_T(szTemp)); m_ctlADODC.SetCursorType(adOpenDynamic); // don't use adLockBatchOptimistic since Grid refresh works badly with it m_ctlADODC.SetLockType(adLockOptimistic); m_ctlADODC.SetCommandType(adCmdTable); // use adCmdTable for table command type m_ctlADODC.SetCommandType(adCmdText); m_ctlADODC.SetBackColor(ADODC_COLOR); m_ctlADODC.SetCaption(_T("Navigation")); // if here an error with code DISP_E_EXCEPTION=0x80020009 occurs, check // the Connection String for invalid value m_ctlADODC.Refresh();

What should I do to use tree view and multiple data sources?

Thanks a lot in advance.....