in web.config
<connectionStrings>
<add name="Conn" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=D:\New Folder\WebApp\App_Data\Database.mdf;Integrated Security=True;User Instance=True"></add>
</connectionStrings>
in Code Behind
'Calling a function for connection
Dim connect As SqlConnection = ConnectToDatabase()
Connect To Database Function
'Getting the connection string
Dim connectString As String = ConfigurationManager.ConnectionStrings("Conn").ConnectionString
'Creating connection object
Dim connect As SqlConnection = New SqlConnection(connectString)
Return connect
____________
www.flickr.com/photos/psdesigner/
Gow.Net, if this helps please login to Mark As Answer. |
Reply | Alert Moderator