You are correct. But I am not trying to build a car, just want to drive it.
1- I have a dataset with a SQL query statement that has a single parameter. That is simple.
2- The dataset (and associated table adapter) are used in a local SQL Server report
3- The report is published using a web form and a Microsoft Report Viewer control
2- Somewhere in the VB code of the Report Viewer I should be able to set the value of the parameter based on program logic. It appears that the data set (and associated components, i.e. tableadapter) are in a different dimension than the rest of the web forms in the project and there is no way of sharing information, for example using the session-state variables. All I want to do is i.e.:
where parm_a is a vlaue generated inside the VB code.
Well, to try to point you in a possible right direction
You need to use an objectdatasource, hand it the table adapater, and the object datasource will realize the table adapter requires a parameter, so it will want to know where to get that parameter from, and you'd point it to a textbox, or dropdown or whatever.
That's a really brief synopsis that hopefully helps you out, and almost all of it can be done from a design window without writing any code so long as you've deployed all needed objects to your webform already