using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.IO;
using?System.xml;

namespace?StudentAttendanceMgr
{
????public?partial?class?frmConnectServer?:?Form
????{
????????public?frmConnectServer（）
????????{
????????????InitializeComponent（）;
????????}

????????//按Windows身份驗證，檢查能否成功建立數據庫連接。
????????private?bool?CheckConnection（string?serverAddress?string?databaseName）
????????{
????????????bool?result?=?false;

????????????SqlConnection?connection?=?new?SqlConnection（）;

????????????try
????????????{
????????????????string?connString?=?String.Format（“Data?Source={0};Initial?Catalog={1};Integrated?Security=true“?serverAddress?databaseName）;

????????????????connection.ConnectionString?=?connString;

????????????????connection.Open（）;

????????????????result?=?true;???//建立數據庫連接成功，返回true。
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“連接失敗“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????result?=?false;??//建立數據庫連接失敗，返回false。
????????????}
????????????finally
????????????{
????????????????connection.Close（）;
????????????}

????????????return?result;
????????}

????????//按SQL?Server身份驗證，檢查能否成功建立數據庫連接。
????????private?bool?CheckConnection（string?serverAddress?string?databaseName?string?userId?string?userPwd）
????????{
????????????bool?result?=?false;

????????????SqlConnection?connection?=?new?SqlConnection（）;

????????????try
????????????{
????????????????string?connString?=?String.Format（“Data?Source={0};Initial?Catalog={1};User?ID={2};Pwd={3}“?serverAddress?databaseName?userId?userPwd）;

????????????????connection.ConnectionString?=?connString;

????????????????connection.Open（）;

????????????????result?=?true;???//建立數據庫連接成功，返回true。
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“連接失敗“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????result?=?false;??//建立數據庫連接失敗，返回false。
????????????}
????????????finally
????????????{
????????????????connection.Close（）;
????????????}

????????????return?result;
????????}

????????//測試數據庫連接
????????public?bool?CheckConnection（）
????????{
????????????bool?result?=?false;

????????????string?xmlFilePath?=?“ConnectServer.xml“;??//連接服務器的xml配置文件放在當前工程的bin\Debug目錄下

????????????if?（File.Exists（xmlFilePath）?==?false）
????????????{
????????????????MessageBox.Show（“連接服務器的xml配置文件不存在！“?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????result?=?false;
????????????????return?result;
????????????}

????????????//創建xml文檔對象
????????????xmlDocument?doc?=?new?xmlDocument（）;

????????????//加載xml文檔
????????????doc.Load（xmlFilePath）;

????????????//讀取所有節點
????????????xmlNamespaceManager?xnm?=?new?xmlNamespaceManager（do

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????162304??2010-07-01?23:36??學生考勤管理系統?數據庫設計.doc

?????文件?????187904??2010-07-01?23:36??學生考勤管理系統?需求分析.doc

?????文件?????131072??2010-07-01?23:37??第三方控件\BSE.Windows.Forms.dll

?????文件?????516096??2010-07-01?23:37??第三方控件\IrisSkin2.dll

?????文件??????20139??2010-07-01?23:37??第三方控件\skin\Calmness.ssk

?????文件??????20271??2010-07-01?23:37??第三方控件\skin\CalmnessColor1.ssk

?????文件??????20208??2010-07-01?23:37??第三方控件\skin\CalmnessColor2.ssk

?????文件???????5032??2010-07-01?23:37??第三方控件\skin\DeepCyan.ssk

?????文件???????5037??2010-07-01?23:37??第三方控件\skin\DeepGreen.ssk

?????文件???????4908??2010-07-01?23:37??第三方控件\skin\DeepOrange.ssk

?????文件??????16021??2010-07-01?23:37??第三方控件\skin\DiamondBlue.ssk

?????文件??????16669??2010-07-01?23:37??第三方控件\skin\DiamondGreen.ssk

?????文件??????10439??2010-07-01?23:37??第三方控件\skin\Eighteen.ssk

?????文件??????10382??2010-07-01?23:37??第三方控件\skin\EighteenColor1.ssk

?????文件???????9746??2010-07-01?23:37??第三方控件\skin\EighteenColor2.ssk

?????文件??????12666??2010-07-01?23:37??第三方控件\skin\Emerald.ssk

?????文件??????12261??2010-07-01?23:38??第三方控件\skin\EmeraldColor1.ssk

?????文件??????12360??2010-07-01?23:38??第三方控件\skin\EmeraldColor2.ssk

?????文件??????11422??2010-07-01?23:38??第三方控件\skin\EmeraldColor3.ssk

?????文件??????18859??2010-07-01?23:38??第三方控件\skin\GlassBrown.ssk

?????文件??????16097??2010-07-01?23:38??第三方控件\skin\GlassGreen.ssk

?????文件??????17010??2010-07-01?23:38??第三方控件\skin\GlassOrange.ssk

?????文件??????18988??2010-07-01?23:38??第三方控件\skin\Longhorn.ssk

?????文件??????15156??2010-07-01?23:38??第三方控件\skin\MacOS.ssk

?????文件??????12477??2010-07-01?23:38??第三方控件\skin\Midsummer.ssk

?????文件??????12542??2010-07-01?23:38??第三方控件\skin\MidsummerColor1.ssk

?????文件??????12238??2010-07-01?23:38??第三方控件\skin\MidsummerColor2.ssk

?????文件??????12127??2010-07-01?23:38??第三方控件\skin\MidsummerColor3.ssk

?????文件??????15899??2010-07-01?23:38??第三方控件\skin\MP10.ssk

?????文件??????16292??2010-07-01?23:38??第三方控件\skin\MSN.ssk

............此處省略314個文件信息