Home » 2012 » August » 21

Archive for August 21, 2012

SqlConnection from web config file in code behind

August 21, 2012 - Posted in .NET 4.0, Access, Applications, MS SQL, VS2010 - Permalink

test.aspx.vb Imports System.Data.SqlClient ————————————- Dim connString As String connString = ConfigurationManager.ConnectionStrings(“MyConnectionString1″).ToString Dim conn As New SqlConnection(connString) web.config <connectionstrings> <add name=”MyConnectionString1″ connectionString=”Data Source=MY-SQL-SRV;Initial Catalog=Northwind; Persist Security Info=True; User ID=my_user;Password=my_pwd” providerName=”System.Data.SqlClient” /> </connectionstrings>