ok, but I still think using sessions is much more effective :P. I used to code cms systems in PHP. User logged in (or sent some information), those were processed and saved into sessions. It is simple, fast and quite secured.
2009/7/3 The_Fruitman <[email protected]> > > "It will be different for each session (to be entered from login > screen) " I would think that the connection string would be different > for each user not each session. > > Here's one way I can think of doing this (its early here and I may not > be thinking this through in the best way). > > > I'm not sure why the VB forms are in different projects, but it > doesn't matter for this. I would recommend creating a DLL (Class > Library project) that both projects would reference. This DLL would > facilitate communication to and from the database as well as any other > code that you tend to use repeatedly (Its nice to have code in one > location if you need to make a change rather than having identical > code in many locations that requires changing). Since most of your > connection string remains the same, have it coded inside the a class > in the DLL project. The DLL Project can have an app config that you > can store configurables such as the IP address or server name and the > database name. Then create a function that builds your connection > string. The username and password variables come from the login > form. > > (Note: the following code was typed in here and is most likely missing > some important syntax - I haven't coded in VB for over a year). > > Public String CreateConnectionString(UserName as String, Password as > String) > Return Server=(from app.config);Database=(from > app.config);Uid=UserName;Pwd=Password; > > End Sub > > > > > On Jul 2, 11:46 pm, Vineet <[email protected]> wrote: > > This is editing by the author himself: (since google groups doesn't > > have edit facility) > > ============================================ > > The VB forms are in different projects. That's why I am wondering how > > to store & retrieve database connection string in app.config > > ---Vineet > > ============================================= > > On Jul 3, 9:51 am, vineet <[email protected]> wrote: > > > > > > > > > Dear Friends, > > > May I request for a small help regarding VB-MySQL ! > > > I have ERP solution in VFP for medium scale businesses. > > > I am now converting it to VB-MySQL. > > > In this, different users need to login with their ID's. > > > So, the connection string can't be defined while writing code. It will > > > be different for each session (to be entered from login screen) > > > Secondly, there are more that 100 VB.NET <http://vb.net/> forms, each > requiring > > > connection string to MySQL. > > > If we store conn string in app.config of a particular form, how other > > > forms can retrieve it ? > > > My query is that, where & how to store the connection string sothat -- > > > 1) it will be available to all different VB.NET <http://vb.net/>forms, and > > > 2) connection string to MySQL will be different for every session. > > > You are requested to throw some light on the above-mentioned task. > > > Thanks, > > > Vineet.- Hide quoted text - > > > > - Show quoted text -
