loading report to report viewer dynamically

See more:

ASP.NET

Hello All

I am using reportwizard for reports.
i am using MicrosoftReportViewer to show these reports.
i want to choose report to show in reportviewer at runtime.
for this i am using following code :

private void Report_Load(object sender, EventArgs e)
        {
            reportViewer1.ProcessingMode=ProcessingMode.Local;
            LocalReport lr = reportViewer1.LocalReport;
            lr.ReportPath = AppDomain.CurrentDomain.BaseDirectory+"..\\..\\Reports\\rptSaleHotel.rdlc";
            SqlDataAdapter adp = new SqlDataAdapter("HotelSale", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
            adp.SelectCommand.CommandType = CommandType.StoredProcedure;
            adp.SelectCommand.Parameters.Add("@from",SqlDbType.DateTime).Value="02-02-2011";
            adp.SelectCommand.Parameters.Add("@to", SqlDbType.DateTime).Value = "02-17-2011";
            DataSet ds = new DataSet();
            adp.Fill(ds);
            ReportDataSource rds = new ReportDataSource();
            this.reportViewer1.LocalReport.DataSources.Clear();
            rds.Value = ds.Tables[0];
            rds.Name = "salehotel";
            string st=lr.ReportPath.ToString();
            lr.DataSources.Add(rds);      
        }

but it is showing totally blank report and a message
A datasource instance has not been supplied for the datasource 'dbTraDeskDatase_HotelSale'.i have checked the value in dataset it contain 6 records.

can anyone please tell me where i am wrong


thanks in advance