www.pudn.com > 20071920285172.rar > DataSource.cs

using System; 
using System.Data.SqlClient; 
using System.Data.OleDb; 
using System.Data.Common; 
using System.Data; 
using System.Xml; 
 
namespace Login.DataSource 
{ 
    public class DataSource 
    { 
        public static string DataType; 
        private static string DataPath; 
        private static string DataUser; 
        private static string DataPwd; 
        private static string DataName; 
        public static void toreadxml() 
        { 
            readxml(); 
        } 
        /// 
 
        /// 读取XML信息 
        /// 
 
        /// 将XML节点的值赋予各个数据成员 
        private static void readxml() 
        { 
            DESEncrypt des = new DESEncrypt();//创建DES算法实例 
            XmlDocument mydoc = new XmlDocument();//创建DES算法实例 
            mydoc.Load("Database.xml"); 
            XmlNode node = mydoc.DocumentElement;//移到config节点 
            node = node.FirstChild;//移到DataType子节点 
            DataType = node.InnerXml;//得到采用的数据库类型 
            node = node.NextSibling;//移到database子节点 
            if (DataType == "1") 
            { 
                node = node.FirstChild;//移动到SQL节点 
                node = node.FirstChild;//移到Server子节点 
                DataPath = node.InnerXml; 
                node = node.NextSibling;//移到UserName子节点 
                DataUser = des.UNDES(node.InnerXml); 
                node = node.NextSibling;//移到PassWord子节点 
                DataPwd = des.UNDES(node.InnerXml); 
                node = node.NextSibling;//移到DbName子节点 
                DataName = des.UNDES(node.InnerXml); 
            } 
            else  
            { 
                node = node.FirstChild;//移动到SQL节点 
                node = node.NextSibling;//移动到ACCESS节点 
                node = node.FirstChild;//移到Path子节点 
                DataPath = des.UNDES(node.InnerXml); 
            } 
        } 
        /// 
 
        /// 获得SQL数据库连接串 
        /// 
 
        ///返回SQL连接字符串 
        public static SqlConnection gSqlConnect() 
        { 
            readxml(); 
            SqlConnection Conn = new SqlConnection("server=" + DataPath + ";uid=" + DataUser + ";pwd=" + DataPwd + ";database="+DataName+""); 
            return Conn; 
        } 
        /// 
 
        /// 获得ACCESS数据库连接串 
        /// 返回ACCESS连接字符串 
        public static OleDbConnection gAccessConnect() 
        { 
            readxml(); 
            string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + DataPath + ";Persist Security Info=False"; 
            OleDbConnection myConn = new OleDbConnection(strConnection); 
            return myConn; 
        } 
    } 
}