using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
namespace?WindowsApplication1
{
????class?connectdatabase
????{//SqlConnection?conn?=?new?SqlConnection（“Server=（local）;Integrated?Security=SSPI;database=supermarketdb;“）;
????????//SqlConnection?conn?=?new?SqlConnection（“server=ZTF\\SQLEXPRESS;Integrated?Security=SSPI;database=supermarketdb;“）;一般數據庫連接?不同身份連接數據庫
????
????????private?static?string?UserJ?=?““;//標示用戶訪問數據庫的級別??數據庫連接選擇
????????public?static?string?UserJB
????????{
????????????get?{?return?UserJ;?}
????????????set?{?UserJ?=?value;?}

????????}

????????SqlConnection?conn?=?new?SqlConnection（“server=ZTF\\SQLEXPRESS;Integrated?Security=SSPI;database=supermarketdb;“）;
???????
????????public?connectdatabase（）
????????{
???????????
????????????if?（UserJB?==?“1“）?{?conn?=?new?SqlConnection（“server=ZTF\\SQLEXPRESS;database=supermarketdb;uid=ztf;pwd=123;“）;?}

????????????if?（UserJB?==?“2“）?{?conn?=?new?SqlConnection（“server=ZTF\\SQLEXPRESS;database=supermarketdb;uid=saa;pwd=123;“）;?}
????????????if?（UserJB?==?“3“）?{?conn?=?new?SqlConnection（“server=ZTF\\SQLEXPRESS;database=supermarketdb;uid=sas;pwd=123;“）;?}

????????????else?{?conn?=?new?SqlConnection（“server=ZTF\\SQLEXPRESS;Integrated?Security=SSPI;database=supermarketdb;“）;?}


????????????try
????????????{
????????????????conn.Open（）;
????????????}
????????????catch?（DataException?e）
????????????{
????????????????System.Windows.Forms.MessageBox.Show（“連接數據庫失敗“）;
????????????}
????????}
????????public?bool?readdate（string?SQLstr?out?DataTable?dt）/*執行相關查詢讀出表集合*/
????????{
????????????bool?flag?=?false;
????????????dt?=?new?DataTable（）;
????????????try
????????????{
????????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（SQLstr?conn）;
????????????????sda.Fill（dt）;

????????????????flag?=?true;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????System.Windows.Forms.MessageBox.Show（“讀取數據失敗失敗原因：“?+?e.Message）;
????????????}
????????????return?flag;
????????}






????????public?void?cmdm（string?sql）/*執行任何數據庫的相關語句過程*/
????????{
????????????SqlCommand?sc?=?new?SqlCommand（sql?conn）;
????????????sc.CommandType?=?CommandType.Text;

????????????try
????????????{
????????????????sc.ExecuteNonQuery（）;
????????????????System.Windows.Forms.MessageBox.Show（“執行成功“）;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????System.Windows.Forms.MessageBox.Show（“執行失敗“?+?e.Message）;
????????????}
????????????finally
????????????{
????????????????if?（conn.State?==?System.Data.ConnectionState.Open）
????????????????{
????????????????????conn.Close（）;
????????????????????conn.Dispose（）;
????????????????}
????????????}

????????}

????????public?string?rcmdm（string?sql）/*執行任何數據庫的相關語句調用數據返回值*/
????????{
????????????string?k?=?““;
????????????SqlCommand?sc?=?new?SqlCommand（sql?conn）;
????????????sc.CommandType?=?Co

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

?????文件?????118784??2008-08-25?13:44??word\可視化程序設計課程設計任務及報告書.doc

?????文件?????417792??2008-08-25?14:04??word\數據庫應用課程設計任務及報告書.doc

?????文件????3145728??2008-08-25?15:05??數據庫SuperMarketdb\supermarketdb.mdf

?????文件????1048576??2008-08-25?15:05??數據庫SuperMarketdb\supermarketdb_log.ldf

?????文件?????417792??2008-08-25?14:04??數據庫SuperMarketdb\數據庫應用課程設計任務及報告書.doc

?????文件???????3842??2008-07-10?02:16??WindowsApplication1\connectdatabase.cs

?????文件???????1713??2008-07-07?18:07??WindowsApplication1\connectdatabase1.cs

?????文件???????4855??2008-08-23?16:40??WindowsApplication1\CrystalReport1.cs

?????文件??????16384??2008-07-04?02:20??WindowsApplication1\CrystalReport1.rpt

?????文件??????16734??2008-07-10?03:27??WindowsApplication1\pos前臺.cs

?????文件??????44311??2008-07-07?03:55??WindowsApplication1\pos前臺.Designer.cs

?????文件???????8010??2008-07-07?03:55??WindowsApplication1\pos前臺.resx

?????文件????????479??2008-08-24?14:25??WindowsApplication1\Program.cs

?????文件???????7603??2008-07-07?18:02??WindowsApplication1\WindowsApplication1.csproj

?????文件????????219??2008-07-03?18:27??WindowsApplication1\WindowsApplication1.csproj.user

?????文件????????926??2008-06-30?20:21??WindowsApplication1\WindowsApplication1.sln

????..A..H.?????31232??2008-08-24?14:32??WindowsApplication1\WindowsApplication1.suo

?????文件??????10472??2008-07-06?23:38??WindowsApplication1\商品入庫.cs

?????文件??????18354??2008-07-06?23:37??WindowsApplication1\商品入庫.Designer.cs

?????文件???????5814??2008-07-06?23:37??WindowsApplication1\商品入庫.resx

?????文件??????10757??2008-07-10?01:22??WindowsApplication1\基本信息瀏覽.cs

?????文件???????8629??2008-07-10?01:22??WindowsApplication1\基本信息瀏覽.Designer.cs

?????文件???????5814??2008-07-10?01:22??WindowsApplication1\基本信息瀏覽.resx

?????文件????????649??2008-07-10?02:15??WindowsApplication1\庫存門市查詢.cs

?????文件???????2415??2008-07-04?15:56??WindowsApplication1\庫存門市查詢.Designer.cs

?????文件???????5814??2008-07-02?03:49??WindowsApplication1\庫存門市查詢.resx

?????文件???????2074??2008-07-10?01:48??WindowsApplication1\登錄.cs

?????文件???????5779??2008-07-07?18:04??WindowsApplication1\登錄.Designer.cs

?????文件???????5814??2008-07-03?01:34??WindowsApplication1\登錄.resx

?????文件??????15095??2008-07-10?04:51??WindowsApplication1\訂_進_退_貨物單據管理.cs

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