Hi,
I have a login page where I display all the sql servers available and when the user selects the server, all the databases are displayed in a different combo box. Then the user enters the userid/pwd and clicks logon button.
Assume that the credentials are correct and sucessfully established.
Now what I want is to store that connection string into somewhere so that all the different operations can be carried out without referring to the config file.
One option that I have is to declare a public variable in DAO class and assign the connection string to it.
Is there any other better way to handle this situation.
I have a login page where I display all the sql servers available and when the user selects the server, all the databases are displayed in a different combo box. Then the user enters the userid/pwd and clicks logon button.
Assume that the credentials are correct and sucessfully established.
Now what I want is to store that connection string into somewhere so that all the different operations can be carried out without referring to the config file.
One option that I have is to declare a public variable in DAO class and assign the connection string to it.
Is there any other better way to handle this situation.