Display SqlDataReader Info in windows form.

See more:

C#

SQL

ADO.NET

So i'm doing the example from http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx[^] on stored procedures. Which is all well and good in console but I'm trying to apply it to a windows form. Below is what I have on a button click:

private void btnQ4_Click(object sender, EventArgs e)
        {
            SqlConnection conn = null;
            SqlDataReader rdr = null;
                        
            try
            {
                ArrayList list = new ArrayList();
                // create and open a connection object
                conn = new SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI");
                conn.Open();

                // 1. create a command object identifying
                // the stored procedure
                SqlCommand cmd = new SqlCommand("Ten Most Expensive Products", conn);

                // 2. set the command object so it knows
                // to execute a stored procedure
                cmd.CommandType = CommandType.StoredProcedure;

                // execute the command
                rdr = cmd.ExecuteReader();

                // iterate through results, printing each to console
                while (rdr.Read())
                {
                    dataGridView1.ColumnCount = 1;
                    dataGridView1.Columns[0].Name = "Top10";
                    dataGridView1.Columns[1].Name = "Units";
                    dataGridView1.Rows.Add(rdr["TenMostExpensiveProducts"].ToString() + "" + rdr["UnitPrice"].ToString());
                }
            }            
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
                if (rdr != null)
                {
                    rdr.Close();
                }
            }
            
        }

The while statement in bold is the part I'm having a problem with. I have no idea what object I should have the data read into. In the example it goes straight to console however should I be putting it into a datagridveiw? And if so how do I go about doing that? I've tried getting it into a richtextbox however a string will only hold one lines worth of data not a list. Any help will be much appreciated thanks.