Connection String

Sanjay bakshi

16y3k

Hi All,
I have to create a connection string which i can use in all the pages.I do not want to write connection strings codes in all the pages.
Please help

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Crish16y ago
Hi

To come out this issue you can create just one class.

In this class you can create one method of connection(with any name) and just pass the connection string .
then you can call this method in every pages in page load event .. so there is no need to create a connection string which you can use in all the pages.

You should pass connection string only one time and use it in every pages using call that method.

Also you can set connection string in web.config file.
Hirendra Sisodiya16y ago
use config file or you can declare connection string in module than you can access this in your whole applicaition.

thanks

Jiteendra Sampathirao16y ago

Hi,

Add namespace : System.configuration in code behind page

In web.config file write this code under appsettings tag write



And retrive the connection string using below code
    Public Shared Function getConnectionString() As String 
        Return ConfigurationManager.AppSettings("sql")
    End Function

write like this when creating a connectionstring:

 conn = New Mysqlconnection((getConnectionString())
conn.open


-----------------------------------------------------------------------------------------------------------
If this post helped you, then tick the "Do you like this Answer" checkbox which is placed at above this post.