Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- int i = 0;
- int j = 0;
- int nbrClient;
- string[] nom = new string[1000];
- string[] mail = new string[1000];
- string nbr;
- MySqlConnection conn = new MySqlConnection("server=localhost;database=absys;uid=root;pwd=admin");
- conn.Open();
- string query = "SELECT Nom FROM clients";
- string query1 = "SELECT Email FROM clients";
- string query2 = "SELECT COUNT(*) FROM clients";
- MySqlDataReader reader2 = new MySqlCommand(query2, conn).ExecuteReader();
- reader2.Read();
- nbr = reader2[0].ToString();
- reader2.Close();
- nbrClient = Convert.ToInt32(nbr);
- label5.Text = nbrClient.ToString();
- MySqlDataReader reader = new MySqlCommand(query, conn).ExecuteReader();
- reader.Read();
- for(i = 0; i < nbrClient; i++)
- {
- nom[i] = reader[i].ToString();
- }
- reader.Close();
- MySqlDataReader reader1 = new MySqlCommand(query1, conn).ExecuteReader();
- reader1.Read();
- for(j = 0; j < nbrClient; ++j)
- {
- mail[j] = reader1[j].ToString();
- }
- reader1.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement