using System.Data.OleDb;

private void Form1_Load(object sender, EventArgs e)

{

    //declare connection string

     string cnString = @"Provider=Microsoft.Jet.OLEDB.4.0;

      Data Source=c:\nwind.mdb;User Id=admin;Password=;";

    //declare Connection, command and other related objects

    OleDbConnection conReport = new OleDbConnection(cnString);

    OleDbCommand cmdReport = new OleDbCommand();

    OleDbDataReader drReport;

    DataSet dsReport = new dsProduct();

    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 TOP 5 * FROM

                       Products Order By ProductName" ;

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

        rpvAbraKaDabra.LocalReport.ReportEmbeddedResource =

        "rsWin101.rptProductList.rdlc ";

        //prepare report data source

        ReportDataSource rds = new ReportDataSource();

        rds.Name = "dsProduct_dtProductList" ;

        rds.Value = dsReport.Tables[0];

        rpvAbraKaDabra.LocalReport.DataSources.Add(rds);

        //load report viewer

        rpvAbraKaDabra.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 ();

        }

    }

}