void CDlg::InitDataGrid1(CDatagrid1& Grd,_RecordsetPtr& rs)
{
CColumns GrdClms;
CString strCap,strRec;
CString s;
long num,numRec;
short i;
float wdth;
strCap.LoadString(IDS_STRING9013);
numRec = 0;
GrdClms.AttachDispatch(Grd.get_Columns());
if(rs->State==adStateOpen){
num = rs->GetadoFields()->GetCount();
numRec = rs->GetRecordCount();
strRec.Format(_T(" %i"),numRec);
strCap +=strRec;
Grd.put_Caption(strCap);
for (i=0;i<num;i++) {
switch(i) {
case 0:
GrdClms.GetItem((COleVariant) i).SetVisible(FALSE);
break;
case 1:
wdth = 370;
GrdClms.GetItem((COleVariant) i).SetWidth(wdth);
break;
case 2:
wdth = 100;
GrdClms.GetItem((COleVariant) i).SetWidth(wdth);
break;
case 3:
wdth = 190;
GrdClms.GetItem((COleVariant) i).SetWidth(wdth);
break;
default:
GrdClms.GetItem((COleVariant) i).SetVisible(FALSE);
break;
}
}
}
else{
strRec.Format(_T(" %i"),numRec);
strCap +=strRec;
Grd.put_Caption(strCap);
}
}
void CDlg::InitDataGrid1(void)
{
CColumns GrdClms;
CString strCap,strRec;
CString s;
long num,numRec;
short i;
strCap.LoadString(IDS_STRING9013);
numRec = 0;
GrdClms.AttachDispatch(m_DataGrid1.get_Columns());
if(ptrRs1->State==adStateOpen){
num = ptrRs1->GetadoFields()->GetCount();
numRec = ptrRs1->GetRecordCount();
strRec.Format(L"%i",numRec);
strCap +=strRec;
m_DataGrid1.put_Caption(strCap);
for (i=0;i<num;i++) {
switch(i) {
case 0:
GrdClms.GetItem((COleVariant) i).SetVisible(FALSE);
break;
case 1:
GrdClms.GetItem((COleVariant) i).SetWidth(600);
break;
default:
GrdClms.GetItem((COleVariant) i).SetVisible(FALSE);
break;
}
}
}
else{
strRec.Format(L"%i",numRec);
strCap +=strRec;
m_DataGrid1.put_Caption(strCap);
}
}
void update::OnClickUpdateDatagrid1()
{
// TODO: 在此处添加消息处理程序代码
// TODO: 在此处添加消息处理程序代码
UpdateData(TRUE);
int ColNum = 2;
CString coVal;
CColumns cols;
CColumn col;
VARIANT v_ColNum, v_Value;
cols = m_datagrid.get_Columns();
v_ColNum.vt = VT_I2;
v_ColNum.iVal = 0;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_xuehao = v_Value.bstrVal;
//读取姓名
v_ColNum.iVal = 1;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_xingming = v_Value.bstrVal;
//读取性别
v_ColNum.iVal = 2;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_xingbie = v_Value.bstrVal;
//读取班级
v_ColNum.iVal = 3;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_banji = v_Value.bstrVal;
//读取专业
v_ColNum.iVal = 4;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_zhuanye = v_Value.bstrVal;
//读取生日
v_ColNum.iVal = 5;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_shengri = v_Value.bstrVal;
//读取住址
v_ColNum.iVal = 6;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_zhuzhi = v_Value.bstrVal;
//独取外号
v_ColNum.iVal = 7;
col = cols.GetItem(v_ColNum);
v_Value = col.GetValue();
m_waihao = v_Value.bstrVal;
UpdateData(FALSE);
}
