VC6中开发数据库显示数据的DataGrid，其数据源怎么设置？

Question

数据源是一个LPUNKNOWN，怎样设置呢？

Answer 1

与ADO绑定:
m_pConnection.CreateInstance("ADODB.Connection");
m_pConnection->Open("Provider=SQLOLEDB;Server=billgates;DATABASE=WordDoc;UID=sa;PWD=sa","","",adModeUnknown);

m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->CursorLocation=adUseClient; //注意
m_pRecordset->Open("select * from ColorDef",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
m_datagrid1.SetRefDataSource(NULL);
m_datagrid1.SetRefDataSource((LPUNKNOWN)m_pRecordset);
m_datagrid1.Refresh();

Answer 2

m_pRecordset->CursorLocation=adUseClient; //这句一定要加上