hi,

i have few forms in my form.i dont want to repeat coding for database connectivity.i want to make it as standard in one file.so that in future if any changes in database i can access that file and modify it.

im using global.aspx file here

' Fires when the session is started

Session("ConnectionPath") = "DRIVER={SQL server};SERVER=localhost;UID=sa;PWD=;DATABASE=mas;"

End Sub

now in my forms how can i access this connection path without repeatin the above code again in my dim con = new sql(...) i dont want to do like this..

Hi There,

To access session, all you need to do it:

example:

SqlConnection scon = New SqlConnection(Session("ConnectionPath") );

The above method is not recommended, you can store your connectionstring in web.config

example:

1) Add connection string to web.config

<configuration>

<.....

<add name="MyConnectionString" connectionString="Data Source=localhost;Initial Catalog=DatabaseName;Persist Security Info=True;User ID=Username;Password=Password" providerName="System.Data.SqlClient"/>

</connectionStrings>

2) Get connectionstring from web.config

hi,thanks

 but in con , im getting error that

Dim com, com1 As New SqlCommand

con= new SqlConnection(configurationManager.ConnectionStrings["misConnectionString"].ConnectionString);

value of type system.settings .connection string settings collection cannot converted to string..

Hi There,

Example given is in C#, hence VB version should be something like this

Dim com, com1 As New SqlCommand

con= new SqlConnection(configurationManager.ConnectionStrings("misConnectionString").ConnectionString)

Hope it helps!

Thanks buddy,it works

No probs, its my pleasure.