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

namespace?SqlHelper
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????SQLHelper?_db?=?new?SQLHelper（）;
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????GetSource（）;
????????}
????????private?SqlParameter?CreateSqlParameter（string?name?object?value）
????????{
????????????return?value?==?null???new?SqlParameter（name?DBNull.Value）
????????????????:?new?SqlParameter（name?value）;
????????}

???????

????????public?void?GetSource（）
????????{
????????????string?UName?=?““;
????????????string?strSql?=?string.Format（@“select?*?from?users?where?UName?<>?@UName“）;
????????????List?parameters?=?new?List（）
????????????{
????????????????CreateSqlParameter（“@UName“UName）
????????????};
????????????DataTable?dt?=?_db.ExecuteDataTable（strSql?parameters.ToArray（））;
????????????dataGridView1.DataSource?=?dt;
????????}

????????///?

????????///?讀取數據
????????///?

????????///?
????????public?List?GetListName（）
????????{
????????????string?strSql?=?string.Format（@“select?UName?from?users?where?UName?<>?@UName“）;
????????????List?data?=?new?List（）;
????????????using?（IDataReader?dr?=?_db.ExecuteReader（strSql））
????????????{
????????????????while?（dr.Read（））
????????????????{
????????????????????data.Add（dr[“UName“].ToString（））;
????????????????}
????????????}
????????????return?data;
????????}
????}
}

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

?????文件??????13312??2019-01-23?13:19??SqlHelper\SqlHelper\bin\Debug\SqlHelper.exe

?????文件??????34304??2019-01-23?13:19??SqlHelper\SqlHelper\bin\Debug\SqlHelper.pdb

?????文件??????22688??2019-01-23?11:45??SqlHelper\SqlHelper\bin\Debug\SqlHelper.vshost.exe

?????文件????????490??2012-06-06?02:06??SqlHelper\SqlHelper\bin\Debug\SqlHelper.vshost.exe.manifest

?????文件???????1800??2019-01-23?13:27??SqlHelper\SqlHelper\Form1.cs

?????文件???????3048??2019-01-23?11:58??SqlHelper\SqlHelper\Form1.Designer.cs

?????文件???????5817??2019-01-23?11:58??SqlHelper\SqlHelper\Form1.resx

?????文件????????865??2019-01-23?11:45??SqlHelper\SqlHelper\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6878??2019-01-23?11:45??SqlHelper\SqlHelper\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????810??2019-01-23?11:55??SqlHelper\SqlHelper\obj\Debug\SqlHelper.csproj.FileListAbsolute.txt

?????文件????????977??2019-01-23?11:58??SqlHelper\SqlHelper\obj\Debug\SqlHelper.csproj.GenerateResource.Cache

?????文件???????2211??2019-01-23?11:55??SqlHelper\SqlHelper\obj\Debug\SqlHelper.csprojResolveAssemblyReference.cache

?????文件??????13312??2019-01-23?13:19??SqlHelper\SqlHelper\obj\Debug\SqlHelper.exe

?????文件????????180??2019-01-23?11:58??SqlHelper\SqlHelper\obj\Debug\SqlHelper.Form1.resources

?????文件??????34304??2019-01-23?13:19??SqlHelper\SqlHelper\obj\Debug\SqlHelper.pdb

?????文件????????180??2019-01-23?11:55??SqlHelper\SqlHelper\obj\Debug\SqlHelper.Properties.Resources.resources

?????文件????????490??2019-01-23?11:44??SqlHelper\SqlHelper\Program.cs

?????文件???????1360??2019-01-23?11:44??SqlHelper\SqlHelper\Properties\AssemblyInfo.cs

?????文件???????2870??2019-01-23?11:44??SqlHelper\SqlHelper\Properties\Resources.Designer.cs

?????文件???????5612??2019-01-23?11:44??SqlHelper\SqlHelper\Properties\Resources.resx

?????文件???????1096??2019-01-23?11:44??SqlHelper\SqlHelper\Properties\Settings.Designer.cs

?????文件????????249??2019-01-23?11:44??SqlHelper\SqlHelper\Properties\Settings.settings

?????文件???????6802??2019-01-23?13:27??SqlHelper\SqlHelper\SqlHelper.cs.cs

?????文件???????3775??2019-01-23?11:55??SqlHelper\SqlHelper\SqlHelper.csproj

?????文件????????996??2019-01-23?11:45??SqlHelper\SqlHelper.sln

????..A..H.?????10752??2019-01-23?11:45??SqlHelper\SqlHelper.v12.suo

?????目錄??????????0??2019-01-23?11:44??SqlHelper\SqlHelper\obj\Debug\TempPE

?????目錄??????????0??2019-01-23?11:55??SqlHelper\SqlHelper\bin\Debug

?????目錄??????????0??2019-01-23?13:19??SqlHelper\SqlHelper\obj\Debug

?????目錄??????????0??2019-01-23?11:44??SqlHelper\SqlHelper\bin

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