Reporting Hierarchical Recursive Data using MS Reporting Services

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Microsoft.Reporting.WinForms;

namespace RecursiveData
{
    public partial class frmReportViewer : Form
    {
        public frmReportViewer()
        {
            InitializeComponent();
        }

    private void Form1_Load(object sender, EventArgs e)
    {
        //declare connection string
        string cnString = @"Data Source=(local);Initial Catalog=northwind;" +
                           "User Id=northwind;Password=northwind";

        //use following if you use standard security
        //string cnString = @"Data Source=(local);Initial Catalog=northwind;
        //                    Integrated Security=SSPI";

        //declare Connection, command and other related objects
        SqlConnection conReport = new SqlConnection(cnString);
        SqlCommand cmdReport = new SqlCommand();
        SqlDataReader drReport;
        DataSet dsReport = new dsEmployee();

        try
        {
            //open connection
            conReport.Open();

            //prepare connection object to get the data through reader and populate into dataset
            cmdReport.CommandType = CommandType.Text;
            cmdReport.Connection = conReport;
            cmdReport.CommandText = "Select FirstName + ' ' + Lastname AS EmployeeName, EmployeeID, ReportsTo From Employees";

            //read data from command object
            drReport = cmdReport.ExecuteReader();

            //new cool thing with ADO.NET... load data directly from reader to dataset
            dsReport.Tables[0].Load(drReport);

            //close reader and connection
            drReport.Close();
            conReport.Close();

            //provide local report information to viewer
            reportViewer.LocalReport.ReportEmbeddedResource = "RecursiveData.rptRecursiveData.rdlc";

            //prepare report data source
            ReportDataSource rds = new ReportDataSource();
            rds.Name = "dsEmployee_dtEmployee";
            rds.Value = dsReport.Tables[0];
            reportViewer.LocalReport.DataSources.Add(rds);

            //load report viewer
            reportViewer.RefreshReport();
        }
        catch (Exception ex)
        {
            //display generic error message back to user
            MessageBox.Show(ex.Message);
        }
        finally
        {
            //check if connection is still open then attempt to close it
            if (conReport.State == ConnectionState.Open)
            {
                conReport.Close();
            }
        }
    }
    }
}