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

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

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

????????///?返回SqlConnection對象
????????public?SqlConnection?getcon（）
????????{
????????????string?M_str_sqlcon?=?“Data?Source=（local）;Database=db_wz;User?id=sa;PWD=“;
????????????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語句
????????///?表名
????????///?返回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（mydsM_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
????}
}

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

?????文件????1179648??2007-12-17?17:21??MSM\Database\db_wz.mdf

?????文件?????786432??2007-12-17?17:21??MSM\Database\db_wz_log.LDF

?????文件????????210??2007-12-12?23:12??MSM\Database\存儲過程\存儲過程.sql

?????文件???????3284??2007-12-16?21:53??MSM\Database\存儲過程\存儲過程1.sql

?????文件????????405??2007-12-15?23:59??MSM\Database\存儲過程\存儲過程2.sql

?????文件????????372??2007-12-11?23:12??MSM\login\app.config

?????文件????????372??2007-12-11?23:12??MSM\login\bin\app.config

?????文件???????1086??2007-12-14?16:46??MSM\login\bin\Debug\login.csproj.GenerateResource.Cache

?????文件?????434176??2007-12-17?22:59??MSM\login\bin\Debug\login.exe

?????文件????????372??2007-12-11?23:12??MSM\login\bin\Debug\login.exe.config

?????文件?????429568??2007-12-17?22:59??MSM\login\bin\Debug\login.pdb

?????文件???????5632??2005-12-08?14:51??MSM\login\bin\Debug\login.vshost.exe

?????文件????????372??2007-12-11?23:12??MSM\login\bin\Debug\login.vshost.exe.config

?????文件???????2161??2007-12-15?14:54??MSM\login\bin\登陸.cs

?????文件???????7989??2007-12-15?14:54??MSM\login\bin\登陸.Designer.cs

?????文件??????51091??2007-12-15?14:54??MSM\login\bin\登陸.resx

?????文件???????2456??2007-12-14?21:31??MSM\login\DataCon.cs

?????文件??????27640??2007-12-16?19:58??MSM\login\DataOperate.cs

?????文件?????340768??2007-12-15?16:12??MSM\login\db_wzDataSet.Designer.cs

?????文件??????33767??2007-12-14?13:52??MSM\login\db_wzDataSet1.Designer.cs

?????文件???????1831??2007-12-17?13:03??MSM\login\frmEditPwd.cs

?????文件???????7487??2007-12-14?16:46??MSM\login\frmEditPwd.Designer.cs

?????文件???????7776??2007-12-14?16:46??MSM\login\frmEditPwd.resx

?????文件???????6612??2007-12-17?13:03??MSM\login\frmEmployee.cs

?????文件??????17397??2007-12-17?13:03??MSM\login\frmEmployee.Designer.cs

?????文件???????8784??2007-12-17?13:03??MSM\login\frmEmployee.resx

?????文件???????4488??2007-12-17?17:49??MSM\login\frmItem.cs

?????文件??????11851??2007-12-16?13:00??MSM\login\frmItem.Designer.cs

?????文件???????6594??2007-12-16?13:00??MSM\login\frmItem.resx

?????文件???????4245??2007-12-17?12:20??MSM\login\frmkucun.cs

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