Public Connection

[abdullauthan]

I declared a connection as Public in a module and it always gives me an error when I pass the connectstring from the login page.

When I declare the connection with Dim within the button_click event, it works fine.

I'm new to ASP.Net and I'm declaring the connection Public because I hope I can use the connection from other pages to open tables.

If there is any other way around, please let me know.

 

[Isadore]

abdull: Do a search here at Tek-Tips - there are several threads on this -- a couple very good (regarding the best place to "store" a connection string, etc). See what you can find - don't have the thread references available to me at the moment -- but I would spend some time looking for them -- as they are very good and cover your question completely.

 

[Lenvdb]

Hi gurus! - my 2 cents worth...
As far as I know in ASP one stored Global Variables in the Global.asa and now in ASP.Net in the Global.asax file. We used to always Create a ConnectString here and it is visible anywhere.

Application("sSQLConn&quot = "Initial Catalog=SomeDB;Data Source=SomeServer;Integrated Security=SSPI;"

Then you can retrieve this from anywhere...

CNN.ConnectionString = Application("sSQLConn&quot

Rgds
Len

 

[LV]

Another way would be storing the connection string in Web.config file:

<configuration>
 <appSettings>
   <add key=&quot;ConnectionString&quot; value=&quot;server=localhost;uid=sa;password=;database=MyDB&quot; />
 </appSettings>
</configuration>

You can get a reference on it from your code behind:

string conn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];