Generally machine specific constants refrenced alot in code are best kept in the web.config file in the connectionStrings section. This is so you can just change these according to what machine the application is running on and they are used across the site.
You have to be mindfull not to hard code things like file paths, server names, DB conn's etc. If you can't get them dynamically in code at run time, don't hard code them - put them in the web.config and refrence them like - System.Configuration.ConfigurationManager.ConnectionStrings("theName")connectionString.
Have a look at where the sqlDataSource DataBase connectionString is located. if it is hard coded in the vb or c# page then you want to move it to the web.config file and refrence it from there. I would gess that VS 2005 would give you the option of getting them from the web.config file.
Regards
Brin
Enter your message below
Sign in or Join us (it's free).