How to get data from db and store in array list and diplay it using foreach loop

1. SqlConnection con = new SqlConnection("Data Source=XXXXX;Initial Catalog=XXXXX;Persist Security Info=True;User ID=XXXXX;Password=XXXXX");
2. SqlCommand cmd = new SqlCommand();
3. cmd.CommandText = ("Select * from Employee");
4. cmd.Connection = con;
5. try
6. {
7. con.Open();
8. SqlDataReader dr = cmd.ExecuteReader();
9. ArrayList Al = new ArrayList();
10. if (dr.HasRows)
11. {
12. while (dr.Read())
13. {
14. Al.Add(dr.GetInt32(0) + " , " + dr.GetString(1) + "," + dr.GetDateTime(2) + "," + dr.GetString(3));
16. }
17. }
18. dataGridView1.DataSource = Al;
19. }
20. finally
21. {
22. con.Close();
23. }