To keep Information User Logged

Question

Hi.

I Have Login Page. I need to keep Information about logging user.

Each user has its database and through code login I get connectionstring. I need to keep this connectionstring in memory to use next query. Any ideia?

Thankyou

Teles

brunda k · Answer

we can use Session to store the information as it is user specific requirment.

Nadia Teles · Answer

Hi. My application will be installed in a WebServer. Some customers will use this application. I have an xml file with connectionstring of each clients. Example: Client A > Client B > In the login page  I have an client code and through it I locate connection string . This connectionstring need to be available in some place because she will be used in the next queries. Beyond of connection string  I need to keep other information. How to make this for each user logado in the system? Thankyou Teles

Senthilkumar · Answer

Hi I bit confused with your question. If you want to store the logged information of the user for the next time login then you are prefer to use the cookies. But you mentioned each user has own database and you want to remember the connection string for the next query? Microsoft suggests to use the connection pooling and it will open the maximum number of connection and it will be in the memory. For the further request it uses the same connection string and will be fast to the connection with sql server. For this you need to enable the connection pool property in the web.config file. If i am not right then clarify me.