Vc++2005+sql2000数据库编程第三篇.docVIP

Vc++2005+sql2000数据库编程第三篇： 将五个cedit中的数据添加到数据库中 1.添加button按钮，改caption为添加记录 2.双击添加记录按钮 添加代码，就能运行成功了。那些不用的代码，我都注释了，这些代码都是所谓的书上的可用代码，留着以后研究 对了五个CEdit的ID，从左到右为IDC_EDIT1，IDC_EDIT2 IDC_EDIT3， IDC_EDIT,4， IDC_EDIT5 void CE4Dlg::OnBnClickedBtnAdd() { CoInitialize(NULL);//com组件初始化 _ConnectionPtr pConn(__uuidof(Connection)); _RecordsetPtr pRst(__uuidof(Recordset)); pConn-ConnectionString=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=student;Data Source=DJ-E2F554D95B00; pConn-Open(,,,-1); pRst=pConn-Execute(select * from student,NULL,adCmdText); UpdateData(); CString ch_sno,ch_sname,ch_ssex,ch_sage,ch_scollege; //得到cedit中的数据 GetDlgItem(IDC_EDIT1)- GetWindowText(ch_sno); GetDlgItem(IDC_EDIT2)- GetWindowText(ch_sname); GetDlgItem(IDC_EDIT3)- GetWindowText(ch_ssex); GetDlgItem(IDC_EDIT4)- GetWindowText(ch_sage); GetDlgItem(IDC_EDIT5)- GetWindowText(ch_scollege); //除去字符串两边的空格 ch_sno.Trim(); ch_sname.Trim(); ch_ssex.Trim(); ch_sage.Trim(); ch_scollege.Trim(); /* m_sno.SendMessage(WM_GETTEXT,10,(LPARAM)ch_sno); //m_nCurrentSel当前记录号 m_sname.SendMessage(WM_GETTEXT,10,(LPARAM)ch_sname); //因为m_sno等是控件变量，所以使用方法sendmessage m_ssex.SendMessage(WM_GETTEXT,10,(LPARAM)ch_ssex); m_sage.SendMessage(WM_GETTEXT,10,(LPARAM)ch_sage); m_scollege.SendMessage(WM_GETTEXT,10,(LPARAM)ch_scollege); */ if(ch_sno.GetLength()0ch_sname.GetLength()0ch_ssex.GetLength()0ch_sage.GetLength()0ch_scollege.GetLength()0) { //pRst-AddNew(); // m_nCurrentSel=m_List.InsertItem(0xffff,_T()); //SaveData(); // m_List.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED); // m_List.SetHotItem(m_nCurrentSel); // m_List.SetFocus(); int sno_flag=1; CString data_sno; while(!pRst-rsEOF) { //((CListBox*)GetDlgItem(IDC_LIST1))-AddString((_bstr_t)pRst-GetCollect(standvalue));//CListBox列表框的用法 data_sno=(LPCTSTR)(_bstr_t)(pRst-GetCollect(sno)); data_sno.Trim();//去出字符串 if(ch_sno==data_sno) { sno_fl