Lấy ConnectionString từ Web.Config

Ví dụ trong web.config tab appSetting chứa connection string trong key "Conn" như sau:

<configuration>

<appSettings>

<add key="Conn" value="server=MINHANH\SQLEXPRESS;uid=sa;pwd=123456;database=QLNV"/>

<add key="ConnGrid" value="Provider=sqloledb;Data

Source=MINHANH;Initial Catalog=QLNV;User Id=sa;Password=123456"/>

</appSettings>

</configuration>

Lấy giá trị trong chứa trong web.config dùng code sau:

Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DBConn As SqlConnection

Dim ConnectString As String

ConnectString =System.Configuration.ConfigurationManager.AppSettings("Conn")

DBConn = New
SqlConnection(ConnectString)

'perform work

with connection

End Sub