hi frnds,
i have a certain application in vs2008 with several windows forms.my question is that i have to mention connectionstring on each n every form as:
con.ConnectionString = "Data Source=mypc;Initial Catalog=Main;User ID=me;Password=pwd"Is there any way to define connectionstring for once for all forms and and one more thing if the database location is changed ,my application itself look for it wherever the database file is?
Jump to PostDefine a global constant (or variable) in a module and set the value to your string. Then when you set con.connectionstring, set it equal to your global constant (or variable).
Define a global constant (or variable) in a module and set the value to your string. Then when you set con.connectionstring, set it equal to your global constant (or variable).
The "Help" system is a great place to start for simple stuff. I suggest you look there before posting questions here.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.