I want to use SQlDatareader object to plot Y Axis on my chart. The column has int values in it. I am generating the chart through code behind. Any help would be appreciated as I am real close to my target but stuck here only. Below is my code. I am actually unable to convert the Type dr to array.

```
SqlCommand cmd = new SqlCommand("select items from student_info", conn);

    SqlDataReader dr = cmd.ExecuteReader();

    while (dr.Read())
    {

        int[] yValues = { //Here I want the dr };
        string[] xValues = { "Coke", "Pepsi","Coffee"};

        Chart chart = new Chart();

        Series series = new Series("Default");
        series.ChartType = SeriesChartType.Column;

        chart.Series.Add(series);

        ChartArea chartArea = new ChartArea();
        Axis yAxis = new Axis(chartArea, AxisName.Y);
        Axis xAxis = new Axis(chartArea, AxisName.X);

        chart.Series["Default"].Points.DataBindXY(xValues, yValues);
        chart.ChartAreas.Add(chartArea);

        chart.Width = new Unit(500, System.Web.UI.WebControls.UnitType.Pixel);
        chart.Height = new Unit(200, System.Web.UI.WebControls.UnitType.Pixel);
        string filename = "C:\\check\\Chart.png";
        chart.SaveImage(filename, ChartImageFormat.Png);

        Panel1.Controls.Add(chart);
    }

```