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
| public int LigneExist()
{
int i = 0;
string RqSQL;
string[] listeChamps;
listeChamps = new string[6];
listeChamps[1] = "Pers_FirstName";
listeChamps[2] = "Pers_LastName";
listeChamps[3] = "Comp_Name";
listeChamps[4] = "Pers_PhoneNumber";
listeChamps[5] = "Comp_CompanyId";
RqSQL = "select Pe.Pers_FirstName, Pe.Pers_LastName, Co.Comp_Name, Pe.Pers_PhoneNumber, Co.Comp_CompanyId ";
RqSQL += "FROM Person Pe, Company Co ";
RqSQL += "Where Pe.Pers_CompanyId = Co.Comp_CompanyId";
m_Que.SQL = RqSQL;
m_Que.SelectSql();
while (!m_Que.eof)
{
Console.WriteLine("Nom : {0}, Prenom : {1}, Id : Société : {2}, Numero de telephone {3}, : Id Societe {4}",
m_Que["Pers_FirstName"].ToString(),
m_Que["Pers_LastName"].ToString(),
m_Que["Comp_Name"].ToString(),
m_Que["Pers_PhoneNumber"].ToString(),
m_Que["Comp_CompanyId"].ToString());
i++;
m_Que.Next();
}
Console.WriteLine(i);
Console.ReadKey();
return i;
} |
Partager