|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25 |
void
CSjtestDlg::OnBnClickedButtonAdd(){ // TODO: 在此添加控件通知处理程序代码 this->ShowWindow(SW_HIDE); DigAdd dig ; dig.DoModal() ; this->ShowWindow(SW_SHOW); m_Grid.DeleteAllItems() ; ADOConn m_Adoconn ; m_Adoconn.OnInitADOConn() ; CString sql ; sql.Format(_T("select * from employees order by 员工编号 desc")) ; m_Adoconn.m_pRecordset = m_Adoconn.GetRecordSet((_bstr_t)sql) ; while(! m_Adoconn.m_pRecordset->adoEOF) { m_Grid.InsertItem(0,_T("")); m_Grid.SetItemText(0,0,(_bstr_t)m_Adoconn.m_pRecordset->GetCollect(_T("员工编号"))); m_Grid.SetItemText(0,1,(_bstr_t)m_Adoconn.m_pRecordset->GetCollect(_T("员工姓名"))); m_Grid.SetItemText(0,2,(_bstr_t)m_Adoconn.m_pRecordset->GetCollect(_T("所属部门"))); m_Grid.SetItemText(0,3,(_bstr_t)m_Adoconn.m_pRecordset->GetCollect(_T("基本工资"))); //将记录集指针移动到下一条记录 m_Adoconn.m_pRecordset->MoveNext(); } m_Adoconn.ExitConnect() ;} |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36 |
void
CSjtestDlg::OnBnClickedButtonDelete(){ // TODO: 在此添加控件通知处理程序代码 int
indx = m_Grid.GetSelectionMark() ;//选中序号 CString str = m_Grid.GetItemText(indx,1) ; if(indx < 0) return
; CString info ; for(int
i = 0 ; i < 4 ; i++){ info += m_Grid.GetItemText(indx,i) ; info += _T("\n") ; } if(AfxMessageBox(info,MB_OKCANCEL,MB_ICONQUESTION) != IDOK) return
; ADOConn m_adoconn ; m_adoconn.OnInitADOConn() ; CString sql ; sql.Format(_T("Delete from employees where 员工姓名 = ‘%s‘ "),str) ; m_adoconn.ExecuteSQL((_bstr_t)sql) ; m_Grid.DeleteAllItems() ; sql.Format(_T("select * from employees order by 员工编号 desc")) ; m_adoconn.m_pRecordset = m_adoconn.GetRecordSet((_bstr_t)sql) ; while(! m_adoconn.m_pRecordset->adoEOF) { m_Grid.InsertItem(0,_T("")); m_Grid.SetItemText(0,0,(_bstr_t)m_adoconn.m_pRecordset->GetCollect(_T("员工编号"))); m_Grid.SetItemText(0,1,(_bstr_t)m_adoconn.m_pRecordset->GetCollect(_T("员工姓名"))); m_Grid.SetItemText(0,2,(_bstr_t)m_adoconn.m_pRecordset->GetCollect(_T("所属部门"))); m_Grid.SetItemText(0,3,(_bstr_t)m_adoconn.m_pRecordset->GetCollect(_T("基本工资"))); //将记录集指针移动到下一条记录 m_adoconn.m_pRecordset->MoveNext(); } m_adoconn.ExitConnect() ;} |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 |
void
DigAdd::OnBnClickedOk(){ // TODO: 在此添加控件通知处理程序代码 UpdateData() ; CString sql ,x; ADOConn m_Adocon ; m_Adocon.OnInitADOConn() ; sql.Format(_T("select * from employees order by 员工编号 desc")) ; m_Adocon.m_pRecordset = m_Adocon.GetRecordSet((_bstr_t)sql) ; int
Size = 0 ; while(! m_Adocon.m_pRecordset->adoEOF){ Size++ ; m_Adocon.m_pRecordset->MoveNext() ; } x.Format(_T("%d"),Size) ; sql.Format(_T(" insert into employees (员工编号 ,员工姓名 , 所属部门 , 基本工资) \ values(‘%d‘
, ‘%s‘, ‘%s‘, ‘%s‘) "),1 + Size , this->m_name , this->m_bumen , this->m_money); m_Adocon.ExecuteSQL((_bstr_t)sql) ; MessageBox(x) ; m_Adocon.ExitConnect() ; CDialog::OnOK();} |
原文：http://www.cnblogs.com/liyangtianmen/p/3560268.html