19 m_historyList.InsertColumn(10,_T("用时"),LVCFMT_CENTER,gridWidth);
20 m_historyList.SetExtendedStyle(LVS_EX_FLATSB
21 |LVS_EX_FULLROWSELECT
22 |LVS_SHOWSELALWAYS
23 |LVS_EX_GRIDLINES);
24 ADOConn m_AdoConn;
25 m_AdoConn.OnInitADOConn();
26 CString sql;
27 sql.Format(_T("select* from grade"));
28 _RecordsetPtr m_pRecordset;
29 m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)sql);
30 while(m_AdoConn.m_pRecordset->adoEOF==0)
31 {
32 m_historyList.InsertItem(0,_T(""));
33 m_historyList.SetItemText(0,1,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("date"));
35 m_historyList.SetItemText(0,3,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("speed"));
36 m_historyList.SetItemText(0,4,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("back"));
37 m_historyList.SetItemText(0,5,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("hitkey"));
38 m_historyList.SetItemText(0,6,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("keylong"));
39 m_historyList.SetItemText(0,7,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("wronwor"));
40 m_historyList.SetItemText(0,8,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("wordscount"));
41 m_historyList.SetItemText(0,9,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("keycount"));
42 m_historyList.SetItemText(0,10,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("time"));
43 m_historyList.SetItemText(0,0,(TCHAR*)(_bstr_t)m_pRecordset->GetCollect("id"));
44 m_pRecordset->MoveNext();
45 }
46 m_historyList.SetItemState(0,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);
47 m_AdoConn.ExitConnect();
48 }
作者：owenyang