Link to home
Start Free TrialLog in
Avatar of ayha1999
ayha1999

asked on

Passing parameters to ReportViewer

HI,

How can I pass parameters to ReportViewer in c# 2010 windows application? Please provide some samples. I am using Access 2007 database.

Thanks

ayha
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ayha1999
ayha1999

ASKER

I am using ReportViewer control not Crystal Report.

I bind the ReportViewer as

       private void Report_Load (object sender, EventArgs e)
       {
          // TODO: This line of code loads data into the 'dsReport.qReport' table. You can move, or remove it, as needed.

          this.qReportTableAdapter.Fill (this.dsReport.qReport);
          this.reportViewer1.RefreshReport ();

The Access 2007 query is

select * from mytable where id=@id

How can I add Id and its value in dataset?

Thanks
Thanks