Advertisement
Guest User

Help

a guest
May 30th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. int i = 0;
  2. int j = 0;
  3. int nbrClient;
  4. string[] nom = new string[1000];
  5. string[] mail = new string[1000];
  6. string nbr;
  7. MySqlConnection conn = new MySqlConnection("server=localhost;database=absys;uid=root;pwd=admin");
  8. conn.Open();
  9. string query = "SELECT Nom FROM clients";
  10. string query1 = "SELECT Email FROM clients";
  11. string query2 = "SELECT COUNT(*) FROM clients";
  12. MySqlDataReader reader2 = new MySqlCommand(query2, conn).ExecuteReader();
  13. reader2.Read();
  14. nbr = reader2[0].ToString();
  15. reader2.Close();
  16.  
  17. nbrClient = Convert.ToInt32(nbr);
  18. label5.Text = nbrClient.ToString();
  19. MySqlDataReader reader = new MySqlCommand(query, conn).ExecuteReader();
  20. reader.Read();
  21. for(i = 0; i < nbrClient; i++)
  22. {
  23. nom[i] = reader[i].ToString();
  24. }
  25. reader.Close();
  26.  
  27. MySqlDataReader reader1 = new MySqlCommand(query1, conn).ExecuteReader();
  28. reader1.Read();
  29. for(j = 0; j < nbrClient; ++j)
  30. {
  31. mail[j] = reader1[j].ToString();
  32. }
  33. reader1.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement