using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data?.SqlClient;
using?System.Data;
namespace?ClassLibrary
{
????public?class?Dbconnection
????{
????????///?

????????///?SQL-server?數據庫連接
????????///?

????????///?SqlConnection?myConnection
????????public?static?SqlConnection?Dblink（）
????????{
????????????string?connectionString?=?“server=.;database?=51asp.net_Library;uid=sa;pwd=51asp.net“;
????????????SqlConnection?myConnection?=?new?SqlConnection（connectionString）;
????????????//SqlCommand?command?=?new?SqlCommand（connectionString）;
????????????return?myConnection;
????????}

????????///?

????????///?執行SQL語句
????????///?

????????///?
????????///?int?number
????????public?int?ExeInfochange（string?sql）
????????{
????????????try
????????????{
????????????????SqlConnection?myConnection?=?Dblink（）;
????????????????SqlCommand?myCommand?=?myConnection.CreateCommand（）;
????????????????myCommand.CommandText?=?sql;
????????????????myConnection.Open（）;
????????????????int?number?=?myCommand.ExecuteNonQuery（）;
????????????????myConnection.Close（）;
????????????????myConnection.Dispose（）;
????????????????return?number;
????????????}
????????????catch?（Exception）
????????????{
????????????????return?0;
????????????}
????????}

????????///?

????????///?執行?Select?語句
????????///?

????????///?
????????///?
????????public?object?ExecuteSelect（string?sql）
????????{
????????????try
????????????{
????????????????SqlConnection?myConnection?=?Dblink（）;
????????????????SqlCommand?myCommand?=?myConnection.CreateCommand（）;
????????????????myCommand.CommandText?=?sql;
????????????????myConnection.Open（）;
????????????????int?number?=?Convert?.ToInt32（myCommand.ExecuteScalar（））;
????????????????myConnection.Close（）;
????????????????myConnection.Dispose（）;
????????????????return?number;
????????????}
????????????catch?（Exception）
????????????{
????????????????return?0;
????????????}
????????}

????????///?

????????///?獲取數據集
????????///?

????????///?
????????///?DataSet?ds
????????public?DataSet?ds（string?str1）
????????{
????????????string?sql?=?str1;
????????????try
????????????{
????????????????SqlConnection?myConnection?=?Dblink（）;
????????????????SqlCommand?myCommand?=?myConnection.CreateCommand（）;
????????????????myCommand.CommandText?=?sql;
????????????????myConnection.Open（）;
????????????????SqlDataAdapter?myDataReader?=?new?SqlDataAdapter（）;
????????????????myDataReader.SelectCommand?=?myCommand;
????????????????DataSet?ds?=?new?DataSet（）;
????????????????myDataReader.Fill（ds）;
????????????????myConnection.Close（）;
????????????????myConnection.Dispose（）;
????????????????return?ds;

????????????}
????????????catch?（Excepti

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

????.CA..H.????424448??2017-10-08?11:58??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\.vs\圖書管理系統（二）\v14\.suo

????.CA....???3145728??2015-05-28?13:26??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\51asp.net_DB\51asp.net_Library.mdf

????.CA....???1048576??2015-05-28?13:26??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\51asp.net_DB\51asp.net_Library_log.ldf

????.CA....?????15843??2009-01-01?19:33??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\51asp.net_DB\Library.sql

????.CA....??????3107??2015-03-18?20:48??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\51asp.net源碼申明.txt

????.CA....???????120??2015-04-03?21:35??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\asp.net源碼免費下載.url

????.CA....??????7680??2015-05-28?12:23??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\bin\Debug\ClassLibrary.dll

????.CA....?????22016??2015-05-28?12:23??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\bin\Debug\ClassLibrary.pdb

????.CA....???1048576??2015-05-16?10:44??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\bin\Debug\Interop.Excel.dll

????.CA....????217088??2015-05-16?10:44??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\bin\Debug\Interop.Microsoft.Office.Core.dll

????.CA....?????57344??2009-01-01?20:36??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\bin\Debug\Interop.VBIDE.dll

????.CA....??????4751??2015-05-05?17:42??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\ClassLibrary.csproj

????.CA....???????452??2015-05-05?17:42??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\ClassLibrary.csproj.user

????.CA....??????3102??2015-05-28?12:23??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\Dbconnection.cs

????.CA....??????6947??2015-05-28?12:23??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\Dbinfoshow.cs

????.CA....???????417??2009-01-01?20:36??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\ClassLibrary.csproj.FileList.txt

????.CA....??????1257??2008-12-28?20:25??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\ClassLibrary.csproj.FileListAbsolute.txt

????.CA....??????1669??2015-05-28?11:58??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\ClassLibrary.csproj.FileListAbsolute.txt

????.CA....???????939??2017-10-08?11:54??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\ClassLibrary.csproj.ResolveComReference.cache

????.CA....??????7680??2015-05-28?12:23??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\ClassLibrary.dll

????.CA....?????22016??2015-05-28?12:23??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\ClassLibrary.pdb

????.CA....??????6522??2017-10-08?11:54??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

????.CA....???1048576??2015-05-16?10:44??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\Interop.Excel.dll

????.CA....????442368??2017-10-08?11:53??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\Interop.Microsoft.Office.Core.dll

????.CA....???1544192??2017-10-08?11:54??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\Interop.Microsoft.Office.Interop.Excel.dll

????.CA....????446464??2015-05-05?17:41??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\Interop.Office.dll

????.CA....?????57344??2017-10-08?11:53??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\Interop.VBIDE.dll

????.CA....?????16384??2009-01-01?15:34??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\obj\Debug\Refactor\ClassLibrary.dll

????.CA....??????1327??2008-11-21?16:39??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\ClassLibrary\Properties\AssemblyInfo.cs

????.CA....??????3107??2015-03-18?20:48??圖書館管理系統?租書?圖書借閱管理軟件c#源碼\圖書管理系統（二）\51asp.net源碼申明.txt

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