I have an application built using VS2008. The connection string for the app is declared at runtime (hostname is taken and given to the connection string). I have used an xsd file to create and use DataSets in my reports.
The application is running fine on my local machine, but when I publish the code, and install on some other machine, only the reports are not working.
Is there any way I can declare the connection string for the dataset dynamically? Or, maybe use the connection string generated earlier here also?
I am confused.
Please help!