populate a series from a sql query C#
===

I'm using working in a C# winforms .NET4 application

My goal is to populate a chart control from a specific SQL query. 


> "SELECT height from person"

simple query but im not sure the best way to get this the query result into the chart control.

Heres what i have so far:

    private void button1_Click(object sender, EventArgs e)
            {         
                SqlConnection mainconnection = new SqlConnection("Data Source=commandhq;Initial Catalog=projecttest;Integrated Security=True");
                mainconnection.Open();
                string query = "SELECT height from persons";
                SqlCommand querycommand = new SqlCommand(query, mainconnection);
                SqlDataReader querycommandreader = querycommand.ExecuteReader();
    
    
                Series thesqlresultsplease = new Series();
    
                //Populate series with results from the sql query
                
                chart1.Series[0].XValueMember = thesqlresultsplease.XValueMember; //will this work?
    
            }


My issues are:

How do i get the results from the sqldatareader into the series.
If you know of a much better way of going about this please let me know. Im about to start a project so this would be very helpful.

Thanks in advance