1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
|
// requete SELECT
CMSFlexGrid* m_FlexGrid = 0;
m_FlexGrid = static_cast<CMSFlexGrid*>(GetDlgItem(IDC_MSFLEXGRID2));
CString result;
CString txt_3;
CString txt_4;
txt_3="Ph";
txt_4="ilo";
m_FlexGrid->Clear();
m_FlexGrid->SetCols(100);
m_FlexGrid->SetRows(100);
m_FlexGrid->SetFormatString("Numéro|Nom|Prenom|Adresse|telephone");
//************* implementation *****************
//CBaseRecord m_pSetBase;
class_db_client m_pSetBase;
//CDBVariant num,nom,prenom,adr,tel;
CString num;
CString nom;
CString prenom;
CString adr;
CString tel;
int i,j;
//int Index=0;
i=1;
j=1;
CString SQLRequete("SELECT num_client, nom_client,prenom_client,adr_client,tel_client FROM table_client");
m_pSetBase.Open(CRecordset::forwardOnly,SQLRequete,CRecordset::readOnly);
while (!m_pSetBase.IsEOF()){
m_pSetBase.GetFieldValue("num_client",num);
m_pSetBase.GetFieldValue("nom_client",nom);
m_pSetBase.GetFieldValue("prenom_client",prenom);
m_pSetBase.GetFieldValue("adr_client",adr);
m_pSetBase.GetFieldValue("tel_client",tel);
m_FlexGrid->SetCol(i);
m_FlexGrid->SetRow(j);
result = nom;
m_FlexGrid->SetText(result);
j=j+1;
m_pSetBase.MoveNext();
i=i+1;
}
m_pSetBase.Close(); |
Partager