using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;

namespace?SMS.baseClass
{
????class?DataCon
????{
????????#region??建立數據庫連接
????????///?

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

????????///?返回SqlConnection對象
????????public?SqlConnection?getcon（）
????????{
????????????//string?M_str_sqlcon?=?“Data?Source=（local）;Database=db_SMS;User?id=sa;PWD=“;
????????????string?M_str_sqlcon?=?“Data?Source=MICROSOF-2D00F5;Database=db_SMS;User?id=sa;PWD=abcdef“;
????????????SqlConnection?myCon?=?new?SqlConnection（M_str_sqlcon）;
????????????return?myCon;
????????}
????????#endregion

????????#region??執行SqlCommand命令
????????///?

????????///?創建SqlCommand對象并執行SQL語句
????????///?

????????///?要執行的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語句
????????///?表名
????????///?返回DataSet對象
????????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（CommandBehavior.CloseConnection）;
????????????return?sqlread;
????????}
????????#endregion
????}
}

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

?????文件?????158208??2007-02-10?09:38??c#庫存管理系統\商品進銷存報表系統使用說明書.doc

?????文件?????158720??2007-02-10?09:36??c#庫存管理系統\庫存管理系統使用說明書.doc

?????文件????????445??2009-11-03?20:48??c#庫存管理系統\商品進銷存報表系統1110\補充知識.txt

?????文件????????940??2006-10-18?16:20??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage.sln

????..A..H.????142336??2008-09-20?16:04??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage.suo

?????文件???????3612??2010-11-23?22:56??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\AppMain.cs

?????文件??????28208??2010-11-23?22:56??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\AppMain.Designer.cs

?????文件?????219731??2010-11-23?22:56??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\AppMain.resx

?????文件??????20635??2010-11-24?11:23??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\GoodsReportManage.csproj

?????文件????????382??2006-12-15?10:07??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\GoodsReportManage.csproj.user

?????文件???????3176??2010-11-11?18:20??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\Login.cs

?????文件???????7544??2010-11-11?18:20??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\Login.Designer.cs

?????文件???????6012??2010-11-11?18:20??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\Login.resx

?????文件????????476??2006-10-31?19:52??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\Program.cs

?????文件???????1821??2006-12-02?15:18??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\BakData.cs

?????文件???????6072??2006-10-25?15:34??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\BakData.Designer.cs

?????文件???????9355??2006-10-25?15:14??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\BakData.resx

?????文件???????2621??2006-12-08?09:09??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\ChangePwd.cs

?????文件???????7313??2006-11-04?14:44??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\ChangePwd.Designer.cs

?????文件???????7771??2006-11-04?14:44??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\ChangePwd.resx

?????文件???????2918??2006-12-08?09:59??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\ReBakData.cs

?????文件???????4925??2006-10-25?15:44??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\ReBakData.Designer.cs

?????文件???????8797??2006-10-25?15:44??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\ReBakData.resx

?????文件???????5609??2009-11-10?22:13??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\SetPopedom.cs

?????文件??????10993??2006-12-07?18:37??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\SetPopedom.Designer.cs

?????文件???????7221??2006-12-07?18:37??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\SetPopedom.resx

?????文件??????11348??2009-11-10?22:24??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\SysUser.cs

?????文件??????18778??2009-11-08?22:22??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\SysUser.Designer.cs

?????文件???????9531??2009-11-08?22:22??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage\SysUser.resx

?????目錄??????????0??2011-10-18?20:28??c#庫存管理系統\商品進銷存報表系統1110\GoodsReportManage\GoodsReportManage\SysManage

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