--------------------------------------------------------------------------------------------------------------- 1) My application is Win Forms application. Not a web app.
2) Conn Strings will be built dynamically. (In short, each user will login with his/her ID and password to mysql through VB.NET WinForms, doint some work like adding records, fetching reports, ets., then logging off.) So connection string will be different for different users. 3) The reason as to WHY I maintain separate projects for separate forms--- This is to simplify client-updates. I distribute only .exe files to my clients. If there is any bug in my code, I can send only a small .exe file pertaining to that Form. This way, customer servicing is very easy. What I Tried after my initial post -- 1)Created a DLL project with public string property with user scope in Preferences--Settings. 2)This DLL is referenced in Login form project. 3) From Login form, this string property is modified to hold user's connection string. 4) This DLL is referred in all other projects requiring conn string. .......and this works....... I hope there will not be any security threat for capturing login info by any malicious lifeform !! Any ideas for the betterment of the Solution? Thanks, Vineet. ---------------------------------------------------------------------------------------------------------------
