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); }