最近研究了一下VB.net 中的app.config文件的配置,发现和C#里面的配置文件是一样的,具体的例子如下:
在DAL的数据库连接类(DBHelper)中加入
------------------------coding------------------------
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
'数据库连接层
Public Class DBHelper
Private Shared e_connection As SqlConnection
Public Shared ReadOnly Property Connection() As SqlConnection
Get
Dim connectionString As String = System.Configuration.ConfigurationManager.ConnectionStrings("yourConnectionString").ConnectionString
If Connection Is Nothing Then
Connection = New SqlConnection(connectionString)
Connection.Open()
ElseIf e_connection.State = System.Data.ConnectionState.Closed Then
Connection.Open()
ElseIf Connection.State = System.Data.ConnectionState.Broken Then
Connection.Close()
Connection.Open()
End If
Return Connection
End Get
End Property
------------------------coding------------------------
以上只是DBHepler类中的一下段代码,红色部分就是调用app.config配置的语句
当然下面是app.config(注意,这个文件需要创建在UI层中,并且在该层需要添加引用System.Configuration)
------------------------coding------------------------
<connectionStrings>
<add name="yourConnectionString" connectionString="Data Source=数据库服务器名字;Initial Catalog=连接的数据库文件名;User ID=sa;Password=密码"
providerName="System.Data.SqlClient" ></add >
</connectionStrings>
------------------------coding------------------------
完成了这两步,app.config已经配置完成,可以进行数据的连接了