how to compare two connection string in sql server

Question

sir i have two database one is connection string (year 2014-2015 ) && second is (year 2015-2016) the user select 2014-2015 the open database (year 2014-2015) connection string the user select 2015-2015 the open connction string is 2015-2016 how can possible in public class c# code

Answer 1

no sir online database string in web.config

Answer 2

Do you mean the database is in your local network or in local machine ? Then also you can switch the connectionstrings.

Answer 3

sir this is not set online database connection string

Answer 4

You can store the connection strings in web.config or app.config. Depending upon the year selection just reinitialize the connection object.

Below is a link, may not be an exact answer to your questions but would be a hint for you.


http://www.codeproject.com/Tips/411013/Configuring-a-Connection-String-in-the-App-Config