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;
using?System.Text.Regularexpressions;

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

????????#region?定義公共對象及變量
????????SqlConnection?sqlcon;
????????SqlDataAdapter?sqlda;
????????DataSet?myds;
????????string?strCon?=?“Data?Source?=（local）;Database=db_09;Uid=sa;Pwd=;“;
????????string?strSql?=?“select?ID?as?職工編號Name?as?職工姓名Sex?as?性別Age?as?年齡Tel?as?聯系電話Address?as?家庭地址QQ?as?QQ號碼Email?as?Email地址?from?tb_Employee“;
????????#endregion

????????//窗體初始化時顯示所有職工信息
????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????GetAllInfo（strSql）;
????????????labCount.Text?=?“共有“?+?（dgvInfo.Rows.Count?-?1）?+?“條記錄“;

????????}

???

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????920??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo.sln
?????文件???????26112??2009-02-11?10:05??sj\01\GetAllInfo\GetAllInfo.suo
?????文件????????1638??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\Form1.cs
?????文件????????5131??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\Form1.designer.cs
?????文件????????6014??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\Form1.resx
?????文件????????3766??2009-02-11?09:53??sj\01\GetAllInfo\GetAllInfo\GetAllInfo.csproj
?????文件?????????491??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo\Program.cs
?????文件???????10240??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\bin\Debug\GetAllInfo.exe
?????文件???????22016??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\bin\Debug\GetAllInfo.pdb
?????文件???????14328??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\bin\Debug\GetAllInfo.vshost.exe
?????文件?????????769??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\obj\Debug\GetAllInfo.csproj.FileListAbsolute.txt
?????文件?????????847??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\obj\Debug\GetAllInfo.csproj.GenerateResource.Cache
?????文件???????10240??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\obj\Debug\GetAllInfo.exe
?????文件?????????180??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\obj\Debug\GetAllInfo.Form1.resources
?????文件???????22016??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\obj\Debug\GetAllInfo.pdb
?????文件?????????180??2009-02-11?09:55??sj\01\GetAllInfo\GetAllInfo\obj\Debug\GetAllInfo.Properties.Resources.resources
?????文件????????1376??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo\Properties\AssemblyInfo.cs
?????文件????????2870??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo\Properties\Resources.Designer.cs
?????文件????????5612??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo\Properties\Resources.resx
?????文件????????1095??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo\Properties\Settings.Designer.cs
?????文件?????????249??2009-02-11?09:51??sj\01\GetAllInfo\GetAllInfo\Properties\Settings.settings
?????文件?????????923??2009-02-11?10:05??sj\02\GetInfoByID\GetInfoByID.sln
?????文件???????26624??2009-02-11?10:15??sj\02\GetInfoByID\GetInfoByID.suo
?????文件????????2889??2009-02-11?10:09??sj\02\GetInfoByID\GetInfoByID\Form1.cs
?????文件????????7882??2009-02-11?10:09??sj\02\GetInfoByID\GetInfoByID\Form1.designer.cs
?????文件????????6209??2009-02-11?10:09??sj\02\GetInfoByID\GetInfoByID\Form1.resx
?????文件????????3768??2009-02-11?10:06??sj\02\GetInfoByID\GetInfoByID\GetInfoByID.csproj
?????文件?????????492??2009-02-11?10:05??sj\02\GetInfoByID\GetInfoByID\Program.cs
?????文件???????12288??2009-02-11?10:09??sj\02\GetInfoByID\GetInfoByID\bin\Debug\GetInfoByID.exe
?????文件???????22016??2009-02-11?10:09??sj\02\GetInfoByID\GetInfoByID\bin\Debug\GetInfoByID.pdb
?????文件???????14328??2009-02-11?10:09??sj\02\GetInfoByID\GetInfoByID\bin\Debug\GetInfoByID.vshost.exe
............此處省略33個文件信息