using?System;
using?System.Collections.Generic;
using?System.Web;
using?System.Data.SqlClient;
using?System.Configuration;
using?System.Data;

///?

///DBHelp?的摘要說明
///創(chuàng)建日期：2012-11-21
///創(chuàng)建人：Devin
///?

public?class?DBHelp
{

????#region?構(gòu)造函數(shù)
????public?DBHelp（）
????{

????}
????#endregion

????#region?建立和數(shù)據(jù)庫的連接
????///?

????///?建立和數(shù)據(jù)庫的連接
????///?

????private?static?SqlConnection?GetConn（）
????{
????????string?settings?=?Convert.ToString（ConfigurationManager.ConnectionStrings[“connection“]）;
????????SqlConnection?conn?=?new?SqlConnection（settings）;
????????if?（conn.State.Equals（ConnectionState.Closed））
????????{
????????????conn.Open（）;
????????}
????????return?conn;
????}
????#endregion

????#region?填充DataSet
????/

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-12-12?19:36??ContactWinForm\
?????目錄???????????0??2012-12-07?15:02??ContactWinForm\Contacts\
?????文件?????????866??2012-12-07?15:41??ContactWinForm\Contacts.sln
?????文件???????37376??2013-03-10?12:08??ContactWinForm\Contacts.suo
?????目錄???????????0??2012-12-07?15:02??ContactWinForm\Contacts\Admin\
?????文件????????3490??2012-12-06?17:06??ContactWinForm\Contacts\Admin\A_AddInfo.cs
?????文件???????18736??2012-12-06?17:06??ContactWinForm\Contacts\Admin\A_AddInfo.Designer.cs
?????文件???????28749??2012-12-06?17:06??ContactWinForm\Contacts\Admin\A_AddInfo.resx
?????文件????????1210??2012-12-07?15:02??ContactWinForm\Contacts\Admin\A_AddSort.cs
?????文件????????5626??2012-12-07?15:02??ContactWinForm\Contacts\Admin\A_AddSort.Designer.cs
?????文件???????28749??2012-12-07?15:02??ContactWinForm\Contacts\Admin\A_AddSort.resx
?????文件????????4276??2012-12-07?14:29??ContactWinForm\Contacts\Admin\A_AdminMain.cs
?????文件???????17598??2012-12-07?14:17??ContactWinForm\Contacts\Admin\A_AdminMain.Designer.cs
?????文件??????607476??2012-12-07?14:17??ContactWinForm\Contacts\Admin\A_AdminMain.resx
?????文件???????14339??2012-12-09?16:00??ContactWinForm\Contacts\Admin\A_ManageInfo.cs
?????文件???????26945??2012-12-07?23:33??ContactWinForm\Contacts\Admin\A_ManageInfo.Designer.cs
?????文件???????36880??2012-12-07?23:33??ContactWinForm\Contacts\Admin\A_ManageInfo.resx
?????文件????????1490??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_PrintInfo.cs
?????文件????????3243??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_PrintInfo.Designer.cs
?????文件???????28749??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_PrintInfo.resx
?????文件????????4880??2012-12-07?15:44??ContactWinForm\Contacts\Admin\A_SortManage.cs
?????文件????????7087??2012-12-07?15:44??ContactWinForm\Contacts\Admin\A_SortManage.Designer.cs
?????文件???????29480??2012-12-07?15:44??ContactWinForm\Contacts\Admin\A_SortManage.resx
?????文件????????5269??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_Update.cs
?????文件???????18748??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_Update.Designer.cs
?????文件???????28749??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_Update.resx
?????文件????????3623??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_UserAdd.cs
?????文件???????10010??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_UserAdd.Designer.cs
?????文件???????28749??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_UserAdd.resx
?????文件???????10642??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_UserManage.cs
?????文件???????18928??2012-12-06?17:04??ContactWinForm\Contacts\Admin\A_UserManage.Designer.cs
............此處省略113個文件信息