C#

private void ReportSetup1()
{
    //Reports...
    //declare connection string

    //string cnString = @"(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(WhatIsMyConnectionString);
    SqlCommand cmdReport = new SqlCommand();
    SqlDataReader drReport;
    DataSet dsReport = new AppLoaderDataSet1();

    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 Domain, FullName, MachineName, WindowsUserName, ApplicationName, WorkstationVersion, ServerVersion from vw_Users_vs_Server_Versions_Match";
        //cmdReport.CommandText = "Select ApplicationName, UserName, ServerVersion, WorkstationVersion, tblApplicationDistribution_idx, SNVersion_idx, WSUVersion_idx FROM DifferentVersions";

        //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);

        //dsReport.Tables[1].Load(drReport);
        //close reader and connection
        drReport.Close();
        conReport.Close();
        //////////////////////////////////////////////////////////////////////////////////////////////
        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 Domain, FullName, MachineName, WindowsUserName, ApplicationName, WorkstationVersion, ServerVersion from vw_Users_vs_Server_Versions_NoMatch";
        //cmdReport.CommandText = "Select ApplicationName, UserName, ServerVersion, WorkstationVersion, tblApplicationDistribution_idx, SNVersion_idx, WSUVersion_idx FROM DifferentVersions";

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

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

        //dsReport.Tables[1].Load(drReport);
        //close reader and connection
        drReport.Close();
        conReport.Close();
        //////////////////////////////////////////////////////////////////////////////////////////////

        //provide local report information to viewer
        ADMCReportViewer.LocalReport.ReportEmbeddedResource = "PeerAssistLoader.UsersWithInvalidApplicationVersion.rdlc";
        //ADMCReportViewer.LocalReport.ReportEmbeddedResource = "PeerAssistLoader.UsersWithDifferentVersions.rdlc";

        //prepare report data source
        ReportDataSource rds = new ReportDataSource();
        //rds.Name = "AppLoaderDataSet1_vw_Users_vs_Server_Versions_NoMatch";
        rds.Name = "AppLoaderDataSet1_vwUsersvsServerVersionsMatch";
        rds.Value = dsReport.Tables[1];
        ADMCReportViewer.LocalReport.DataSources.Add(rds);//AppLoaderDataSet1.vw_Users_vs_Server_Versions_NoMatch

        //load report viewer
        ADMCReportViewer.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();
        }
    }
    //http://www.codeproject.com/KB/reporting-services/rswin101.aspx

    //this.AppLoaderDataSet.DifferentVersions;
    //this.ADMCReportViewer.RefreshReport();
    //this.ADMCReportViewer.RefreshReport();

    //this.bwthread = new Thread(new ThreadStart(this.backgroundWorker1));
    //this.bwthread.Start();
    //this.backgroundWorker1 = new Thread(new ThreadStart(this.backgroundWorker1));
    //this.backgroundWorker1.Start();
    //backgroundWorker1_DoWork();
}