一、连接SQL Server 数据库

①以下是Web.config文件配置

<configuration>

<appSettings>

<!--连接数据库-->

<add key="AAA" value="server=localhost;database=网上报障系统;uid=sa;pwd=" />

</appSettings>

</configuration>

②以下是在XXX.aspx.vb中调用数据库连接字符串

Imports System.Data

Imports System.Data.SqlClient

Public Class DataList

    Inherits System.Web.UI.Page

    Dim conn As New SqlConnection

    Dim BBB As String

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

'在此处放置初始化页的用户代码

BBB = System.Configuration.ConfigurationSettings.AppSettings("AAA").ToString.Trim

conn = New SqlConnection(BBB)

conn.Open()

二、连接ACCESS数据库

①以下是Web.config文件配置

<configuration>

<appSettings>

<!--连接数据库-->

<add key="connString" value="provider=microsoft.jet.oledb.4.0;data source= "/>

<add key="dbPath" value="/database/网上报障系统.mdb"/>

</appSettings>

</configuration>

②以下是在XXX.aspx.vb中调用数据库连接字符串

Imports System.Data

Imports System.Data.OleDb

Public AAA As String = System.Configuration.ConfigurationSettings.AppSettings("Connstring").ToString.Trim + HttpContext.Current.Request.MapPath("~") + ConfigurationSettings.AppSettings("dbpath").Trim

Dim conn As New OleDbConnection(AAA)

(注：其中AAA、BBB可以换成其它容易辨别的字符串，此处使用AAA、BBB是为了更显眼地说明哪些字符串是相同的，以免把应该填AAA的却错写成BBB)