数据层怎么读取xml文档
vs05做的cs/程序
xml文档E9HelperConfig.xmlE9HelperConfig.xml如下:
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<Host>192.168.0.9</Host>
<Db>mfgsys</Db>
<Port>9070</Port>
</Configuration>
数据层DataAccess.vb如下:
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports System.Runtime.InteropServices
Imports System.Data
Imports System.Data.SqlClient
Public Class Class1
Public Shared strCon As String = "uid=sa;pwd=sa;server=IP27\YHSQL2000;database=3layer"
Public Shared con_Sql As SqlConnection = New SqlConnection(strCon)
Public Function Get_DataTable(ByVal strsql As String) As DataTable
Dim strCon As String = "uid=sa;pwd=sa;server=IP27\YHSQL2000;database=3layer"
Dim con_Sql2 As SqlConnection = New SqlConnection(strCon)
con_Sql2.Open()
Dim dt_dataGridView As DataTable = New DataTable()
Dim ada_dataGridView As SqlDataAdapter = New SqlDataAdapter(strsql, strCon)
ada_dataGridView.Fill(dt_dataGridView)
Return dt_dataGridView
ada_dataGridView.Dispose()
con_Sql2.Close()
End Function
End Class
如何修改DataAccess.vb,使得其能读取E9HelperConfig.xmlE9HelperConfig.xml这个文件?