using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;


namespace?WindowsFormsApplication2
{
?????
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????textBox1.Text?=?““;
????????????string?cm1=““;
???????????//string?cn?=?“Data?Source=LT-PC\\SQLEXPRESS;AttachDbFilename=D:\\Program?Files\\Microsoft?SQL?Server\\MSSQL.1\\MSSQL\\Data\\chainstoreMSys.mdf;Persist?Security?Info=True;User?ID=taoer;Password=147258“;
???????????string?cn?=?“Data?Source=LT-PC\\SQLEXPRESS;AttachDbFilename=E:\\chainstoreMSys.mdf;Persist?Security?Info=True;User?ID=depstore;Password=147258“;
????????????SqlConnection?con?=?new?SqlConnection（cn）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（）;
????????????if?（!（textBox2.Text?==?““）?&&?（textBox3.Text?==?““）?&&?（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Snum=\‘“?+?textBox2.Text?+?“\‘“;
????????????else?if?（（textBox2.Text?==?““）?&&?!（textBox3.Text?==?““）?&&?（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Cnum=\‘“?+?textBox3.Text?+?“\‘“;
????????????else?if?（（textBox2.Text?==?““）?&&?（textBox3.Text?==?““）?&&?!（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Cname=\‘“?+?textBox4.Text?+?“\‘“;
????????????else?if?（!（textBox2.Text?==?““）?&&?!（textBox3.Text?==?““）?&&?（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Snum=\‘“?+?textBox2.Text?+?“\‘?and?Cnum=\‘“?+?textBox3.Text?+?“\‘“;
????????????else?if?（（textBox2.Text?==?““）?&&?!（textBox3.Text?==?““）?&&?!（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Cnum=\‘“?+?textBox3.Text?+?“\‘?and?Cname=\‘“?+?textBox4.Text?+?“\‘“;
????????????else?if?（!（textBox2.Text?==?““）?&&?（textBox3.Text?==?““）?&&?!（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Snum=\‘“?+?textBox2.Text?+?“\‘?and?Cname=\‘“?+?textBox4.Text?+?“\‘“;
????????????else?if?（!（textBox2.Text?==?““）?&&?!（textBox3.Text?==?““）?&&?!（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk?where?Snum=\‘“?+?textBox2.Text?+?“\‘?and?Cname=\‘“?+?textBox3.Text?+?“\‘?and?Cname=\‘“?+?textBox4.Text?+?“\‘“;
????????????else?if?（（textBox2.Text?==?““）?&&?（textBox3.Text?==?““）?&&?（textBox4.Text?==?““））
????????????????cm1?=?“select?*?from?clerk“;
????????????SqlCommand?com1?=?new?SqlCommand（cm1?con）;
????????????da.SelectCommand?=?com1;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds?“clerk“）;
????????????foreach?（DataTable?dt?in?ds.Tables）
????????????{
????????????????foreach?（DataRow?dr?in?dt.Rows）
????????????????{
????????????????????for?（int?i?=?0;?i?????????????????????{
???????????????

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

?????文件???????1632??2009-07-01?17:16??WindowsFormsApplication2\bin\Release\WindowsFormsApplication2.application

?????文件??????69632??2009-07-01?17:16??WindowsFormsApplication2\bin\Release\WindowsFormsApplication2.exe

?????文件???????3619??2009-07-01?17:16??WindowsFormsApplication2\bin\Release\WindowsFormsApplication2.exe.manifest

?????文件?????161280??2009-07-01?17:16??WindowsFormsApplication2\bin\Release\WindowsFormsApplication2.pdb

?????文件???????1632??2009-07-01?17:16??WindowsFormsApplication2\bin\Release\WindowsFormsApplication2.vshost.application

?????文件??????14328??2009-07-01?17:17??WindowsFormsApplication2\bin\Release\WindowsFormsApplication2.vshost.exe

?????文件???????8873??2009-07-01?16:40??WindowsFormsApplication2\Form1.cs

?????文件??????18402??2009-07-01?16:40??WindowsFormsApplication2\Form1.Designer.cs

?????文件???????5814??2009-07-01?16:40??WindowsFormsApplication2\Form1.resx

?????文件???????4056??2009-07-01?17:14??WindowsFormsApplication2\Form10.cs

?????文件???????9564??2009-07-01?17:04??WindowsFormsApplication2\Form10.Designer.cs

?????文件???????5814??2009-07-01?17:04??WindowsFormsApplication2\Form10.resx

?????文件???????2831??2009-07-01?17:07??WindowsFormsApplication2\Form11.cs

?????文件???????9503??2009-07-01?17:06??WindowsFormsApplication2\Form11.Designer.cs

?????文件???????5814??2009-07-01?17:06??WindowsFormsApplication2\Form11.resx

?????文件???????3090??2009-07-01?17:08??WindowsFormsApplication2\Form12.cs

?????文件???????8971??2009-07-01?17:08??WindowsFormsApplication2\Form12.Designer.cs

?????文件???????5814??2009-07-01?17:08??WindowsFormsApplication2\Form12.resx

?????文件???????1286??2009-07-01?17:08??WindowsFormsApplication2\Form13.cs

?????文件???????4086??2009-07-01?15:24??WindowsFormsApplication2\Form13.Designer.cs

?????文件???????5814??2009-07-01?15:24??WindowsFormsApplication2\Form13.resx

?????文件????????494??2009-07-01?15:16??WindowsFormsApplication2\Form14.cs

?????文件???????2629??2009-07-01?15:16??WindowsFormsApplication2\Form14.Designer.cs

?????文件???????5814??2009-07-01?15:16??WindowsFormsApplication2\Form14.resx

?????文件???????6661??2009-07-01?16:43??WindowsFormsApplication2\Form2.cs

?????文件??????15187??2009-07-01?16:43??WindowsFormsApplication2\Form2.Designer.cs

?????文件???????5814??2009-07-01?16:43??WindowsFormsApplication2\Form2.resx

?????文件???????6538??2009-07-01?16:47??WindowsFormsApplication2\Form3.cs

?????文件??????13752??2009-07-01?16:47??WindowsFormsApplication2\Form3.Designer.cs

?????文件???????5814??2009-07-01?16:47??WindowsFormsApplication2\Form3.resx

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