using?System;
using?System.Data;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?InsertUpdateDeleteDemo
{
????public?partial?class?frmMain?:?Form
????{
????????SqlConnection?con=?new?SqlConnection（“Data?Source=.;Initial?Catalog=Sample;Integrated?Security=true;“）;
????????SqlCommand?cmd;
????????SqlDataAdapter?adapt;
????????//ID?variable?used?in?Updating?and?Deleting?Record
????????int?ID?=?0;
????????public?frmMain（）
????????{
????????????InitializeComponent（）;
????????????DisplayData（）;
????????}
????????//Insert?Data
????????private?void?btn_Insert_Click（object?sender?EventArgs?e）
????????{
????????????if?（txt_Name.Text?!=?““?&&?txt_State.Text?!=?““）
????????????{
????????????????cmd?=?new?SqlCommand（“insert?into?tbl_Record（NameState）?values

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-01-28?14:08??Insert?Update?Delete?Source?Code\
?????目錄???????????0??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\
?????目錄???????????0??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\
?????目錄???????????0??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\bin\
?????目錄???????????0??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\bin\Debug\
?????文件???????12800??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\bin\Debug\InsertUpdateDeleteDemo.exe
?????文件???????30208??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\bin\Debug\InsertUpdateDeleteDemo.pdb
?????文件???????21464??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\bin\Debug\InsertUpdateDeleteDemo.vshost.exe
?????目錄???????????0??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\bin\Release\
?????文件????????3786??2015-01-28?13:19??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\frmMain.cs
?????文件????????7064??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\frmMain.Designer.cs
?????文件????????5817??2015-01-28?01:55??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\frmMain.resx
?????文件????????3721??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo.csproj
?????目錄???????????0??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\
?????目錄???????????0??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\
?????文件????????1229??2015-01-28?01:15??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????7028??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????1300??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.csproj.FileListAbsolute.txt
?????文件?????????907??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.csproj.GenerateResource.Cache
?????文件????????1757??2015-01-28?01:23??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.csprojResolveAssemblyReference.cache
?????文件???????12800??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.exe
?????文件?????????180??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.frmMain.resources
?????文件???????30208??2015-01-28?13:06??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.pdb
?????文件?????????180??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\InsertUpdateDeleteDemo.Properties.Resources.resources
?????目錄???????????0??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\obj\Debug\TempPE\
?????文件?????????516??2015-01-28?13:04??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\Program.cs
?????目錄???????????0??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\Properties\
?????文件????????1456??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\Properties\AssemblyInfo.cs
?????文件????????2874??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\Properties\Resources.Designer.cs
?????文件????????5612??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\Properties\Resources.resx
?????文件????????1109??2015-01-25?00:07??Insert?Update?Delete?Source?Code\InsertUpdateDeleteDemo\InsertUpdateDeleteDemo\Properties\Settings.Designer.cs
............此處省略4個文件信息