void CEmpManDlg::Refresh_Data()
{
UpdateData(TRUE);
CString cSource;
CString strEmpId;
strEmpId.Format("%d",m_empid);
cSource="select empid as 员工编号,empname as 员工姓名,sex as 性别,nationality,birth,"
"political_party,culture_level,family_place,id_card as 工作证号,office_phone,"
"mobile,hiredate,depname as 部门名称,title as 职务,gongzhong,state,"
"leftdate from employees where empid=m_empid";//+strEmpId;

m_adodc.SetRecordSource(cSource);
m_adodc.Refresh();

_variant_t vIndex;
vIndex=long(0);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
vIndex=long(1);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
vIndex=long(2);
}

CString cSource;
cSource.Format("select empid as 员工编号,empname as 员工姓名,sex as 性别,nationality,birth,"
"political_party,culture_level,family_place,id_card as 工作证号,office_phone,"
"mobile,hiredate,depname as 部门名称,title as 职务,gongzhong,state,"
"leftdate from employees where empid=%d",m_empid);