Read Array from SQL to C# convert ArrayList into Array and display in Chart

See more:

C#

SQL

Hi,

Basically I have read in an entire column from my database and stored it as an ArrayList 'al'. To prove this works i've got it displayed in a list box wich is good.

However my main aim is to convert the ArrayList into a Int Array so that I can display that information on the chart I also have on the form.

I currently get the error "At least one element in the source array could not be cast down to the destination array type."

Below is my code:

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Server=MASTER;DataBase=iTylerHood;Integrated Security=SSPI");    
            SqlCommand cmd = new SqlCommand("CustomerByCountry",con);
            cmd.CommandType = CommandType.StoredProcedure;
            con.Open();
        
            ArrayList al = new ArrayList();
            SqlDataReader dr = cmd.ExecuteReader();
        
            while(dr.Read()) 
            {
                    object[] values = new object[dr.FieldCount];
                    dr.GetValues(values);
                    al.Add(values);
            }        
            dr.Close();
            con.Close();
        
            foreach(object[] row in al) {
            foreach(object column in row) 
            {
              listBox1.Items.Add(column.ToString());
            }
            }

            //------ Convert to Int Array

            int[] ia = (int[])al.ToArray(typeof(int));
            int sum = 0;

            for (int i = 0; i < ia.Length; i++)
            sum += ia[i];


            //------- Display on Chart

            string[] seriesArray = { "Fish", "Sharks" };
                            
            this.chart1.Palette = ChartColorPalette.SeaGreen;
                          
            this.chart1.Titles.Add("Pets");
                            
            for (int i = 0; i < seriesArray.Length; i++)
            {
                Series series = this.chart1.Series.Add(seriesArray[i]);

                series.Points.Add(ia[i]);
            }

        }

I think the problem may lie with the conversion of the Array list to an Int Array. The information from the database is integers of 6000, 7000 and 8000.
Any help would be most appreciated.