Set Report Parameter Connection String

[Dan]

I have two report parameters which need to have their data populated via a SQL datasource.  I see how to do this by setting up a SQL dataadapter in the report and then setting the adapter as the DataSource for the report parameter.

The issue that I have is this.  I distribute this website to multiple clients.  Each client has a different SQL connection string which I store in the appSettings in web.config.  I cannot figure out how to set or associate this connection string at runtime from the appSetting to the report dataadapter connection.  Is there a way in the code behind to do this?

Thanks.
Dan

[Patrick]

put the following after the call to the InitializeComponent() method in the report constructor, replacing "foobar" with a valid connection string of course :), and renaming the table adapter, data set and data table accordingly:

this.myDataSetTableAdapter1.Connection.ConnectionString = "foobar";
this.myDataSetTableAdapter1.Fill(this.myDataSet.MyDataSetTable);

[Dan]

Excellent.  That fixed it.  Thanks so much.

Dan

[Patrick]

I got that code from somewhere, can't remember where. Glad it helped!