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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
brunda kPosted Apr 4, 2012, 12:12 AM
Nadia TelesPosted Apr 3, 2012, 7:52 AM
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 connectionstring. This connectionstring need to be available in some place because she will be used in the next queries.
Beyond of connectionstring , I need to keep other information. How to make this for each user logado in the system?
Thankyou
Teles
SenthilkumarPosted Apr 2, 2012, 11:22 PM
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.