Hello all

Up till now I've been creating my data connection within my .net pages or web service but would like to have one common place for all connections. How can this be accomplished.

use module component and public the variable

for your case:

Imports System.Data.SqlClient
Module Module1
    Public conn As SqlClient.SqlConnection

    'other code here your sub,function,class

End Module



Ahmed Ali
Software Developer

Do you want a place to store the connection string? Are you looking to connect and maintain a single connection object that all parts of a page will use? Or do you want just centralize where/how you handle data? There are several different techniques depending on what your needs/desires are.

Peter
------------------------------------------------------
Work smarter, not harder.

YOU CAN STORE THE CONNECTION STRING IN WEB.CONFIG FILE
EXAMPLE
<appSettings>
<add key="connectionString" value="server=IP;uid=USERNAME;pwd=***;database=DB" />
</appSettings>
AND YOU CAN CALL ON *.ASPX
...................
String cn=ConfigurationSettings.AppSettings["connectionString"];
                SqlConnection con =new SqlConnection(cn);