alteruserdlg.cpp

一个用C

// AlteruserDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TS3.h"
#include "AlteruserDlg.h"
#include "Userdata.h"
//#include <afxdb.h>
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CAlteruserDlg dialog



CAlteruserDlg::CAlteruserDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAlteruserDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAlteruserDlg)
	m_name = _T("");
	m_pwd = _T("");
	//}}AFX_DATA_INIT
}


void CAlteruserDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAlteruserDlg)
	DDX_Text(pDX, IDC_NAME_EDIT, m_name);
	DDX_Text(pDX, IDC_PWD_EDIT, m_pwd);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAlteruserDlg, CDialog)
	//{{AFX_MSG_MAP(CAlteruserDlg)
	ON_BN_CLICKED(IDC_ALTERUSER_BUTTON, OnAlteruserButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAlteruserDlg message handlers

void CAlteruserDlg::OnAlteruserButton() 
{
	// TODO: Add your control notification handler code here
CDatabase db;
		if(!db.OpenEx("DSN=ts"))
	{
		MessageBox("数据源打开失败");
		return;
	}
    UpdateData(true);
	Userdata t(&db);
	CString str="select * from user where 用户名<>NULL";    
	if(!t.Open(CRecordset::dynaset,str))
	{
		MessageBox("表打开失败");
}
	t.Edit();
	t.m_column1=m_name;
	t.m_column2=m_pwd;
	t.Update();
	t.Close();
	db.Close();
	MessageBox("修改成功!");
}

void CAlteruserDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	CDialog::OnOK();
}