using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
namespace?TBsystem
{
????class?baseSqlCon
????{
????????#region?建立數據庫連接
????????///?

????????///?建立數據庫連接
????????///?

????????///?返回sqlConnection對象
????????public?SqlConnection?getcon（）
????????{
????????????string?M_str_sqlcon?=?“Data?Source=.;Integrated?Security=true;Initial?Catalog=tianbing“;
????????????SqlConnection?mycon?=?new?SqlConnection（M_str_sqlcon）;
????????????return?mycon;
????????}
????????#endregion
????????#region?執行sqlCommand命令
????????///

????????///?執行sqlCommand
????????///

????????///sql語句
????????public?void?getcom（string?M_str_sqlstr）
????????{
????????????SqlConnection?sqlcon?=?this.getcon（）;
????????????sqlcon.Open（）;
????????????SqlCommand?sqlcom?=?new?SqlCommand（M_str_sqlstr?sqlcon）;
????????????sqlcom.ExecuteNonQuery（）;
????????????sqlcom.Dispose（）;
????????????sqlcon.Close（）;
????????????sqlcon.Dispose（）;
????????}
????????#endregion
????????#region?創建DataSet對象
????????///

????????///??創建一個Dataset對象
????????///

????????///?SQL語句
????????///
????????public?DataSet?getds（string?M_str_sqlstr?string?M_str_table）
????????{
????????????SqlConnection?sqlcon?=?this.getcon（）;
????????????SqlDataAdapter?sqlda?=?new?SqlDataAdapter（M_str_sqlstr?sqlcon）;
????????????DataSet?myds?=?new?DataSet（）;
????????????sqlda.Fill（myds?M_str_table）;
????????????return?myds;
????????}
????????#endregion
????????#region?創建一個sqlDataReader對象
????????///

????????///?創建一個sqlDataReader對象
????????///

????????///sql語句
????????///返回sqlDataReader對象
????????public?SqlDataReader?getread（string?M_str_sqlstr）
????????{
????????????SqlConnection?sqlcon?=?this.getcon（）;
????????????SqlCommand?sqlcom?=?new?SqlCommand（M_str_sqlstr?sqlcon）;
????????????sqlcon.Open（）;
????????????SqlDataReader?sqlread?=?sqlcom.ExecuteReader（）;
????????????return?sqlread;
????????}
????????#endregion
????}
}

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

????..A.SHR?????????9??2009-07-10?14:36??天冰\Desktop_1.ini

????..A.SHR?????????9??2009-07-10?14:39??天冰\Desktop_2.ini

????..A.SHR?????????9??2009-07-10?14:36??天冰\Setup\Debug\Desktop_1.ini

????..A.SHR?????????9??2009-07-10?14:39??天冰\Setup\Debug\Desktop_2.ini

?????文件?????422912??2008-04-17?11:33??天冰\Setup\Debug\setup.exe

?????文件????9310208??2008-01-15?14:16??天冰\Setup\Debug\Setup.msi

????..A.SHR?????????9??2009-07-10?14:36??天冰\Setup\Desktop_1.ini

????..A.SHR?????????9??2009-07-10?14:39??天冰\Setup\Desktop_2.ini

????..A.SHR?????????9??2009-07-10?14:36??天冰\Setup\Release\Desktop_1.ini

????..A.SHR?????????9??2009-07-10?14:39??天冰\Setup\Release\Desktop_2.ini

?????文件??????46863??2008-01-14?19:25??天冰\Setup\Setup.vdproj

?????文件????2490368??2010-11-11?19:18??天冰\tianbing_Data.MDF

?????文件????4325376??2010-11-11?19:18??天冰\tianbing_Log.LDF

?????文件???????3638??2008-01-14?19:34??天冰\天冰管理系統\123.ico

?????文件????????394??2008-01-10?12:35??天冰\天冰管理系統\app.config

?????文件???????2302??2008-10-10?11:08??天冰\天冰管理系統\baseSqlCon.cs

?????文件??????91884??2000-01-09?08:46??天冰\天冰管理系統\bin\Debug\111.jpg

?????文件???????3638??2008-01-08?19:52??天冰\天冰管理系統\bin\Debug\123.ico

????..A.SHR?????????9??2009-07-10?14:36??天冰\天冰管理系統\bin\Debug\Desktop_1.ini

????..A.SHR?????????9??2009-07-10?14:39??天冰\天冰管理系統\bin\Debug\Desktop_2.ini

?????文件?????213592??2008-01-04?22:28??天冰\天冰管理系統\bin\Debug\happy?new?year.jpg

?????文件???????3584??2008-01-15?14:16??天冰\天冰管理系統\bin\Debug\Interop.ACTIVEXLib.dll

?????文件????1093632??2008-01-15?14:16??天冰\天冰管理系統\bin\Debug\Interop.Excel.dll

?????文件???????4608??2008-01-15?14:16??天冰\天冰管理系統\bin\Debug\Interop.LCC11.dll

?????文件?????368640??2010-11-11?19:15??天冰\天冰管理系統\bin\Debug\Interop.Microsoft.Vbe.Interop.Forms.dll

?????文件?????364544??2008-01-15?16:15??天冰\天冰管理系統\bin\Debug\Interop.MSForms.dll

?????文件??????49152??2010-11-10?10:17??天冰\天冰管理系統\bin\Debug\Interop.RefEdit.dll

?????文件??????64088??2007-11-30?13:22??天冰\天冰管理系統\bin\Debug\Microsoft.Vbe.Interop.dll

?????文件?????223800??2007-11-30?13:22??天冰\天冰管理系統\bin\Debug\office.dll

????..A.SH.?????26112??2100-01-09?10:07??天冰\天冰管理系統\bin\Debug\Thumbs.db

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