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?TreeViewSql
{
????public?partial?class?AddTree?:?Form
????{
????????public?int?pId;
????????public?int?Id;
????????public?bool?bEditMode?=?false;??//false為添加?true為修改
????????ConnDatabase?cd;
????????Tree樹?tre;
????????public?AddTree（）
????????{
????????????InitializeComponent（）;????
????????}
????????public?AddTree（string?str）?
????????{
????????????InitializeComponent（）;
????????????tbx_TreeNodeName.Text?=?str;????
????????}
????????private?void?AddTree_Load（object?sender?EventArgs?e）
????????{
????????????if?（bEditMode）
????????????????button1.Text?=?“修改“;
????????????else
????????????????button1.Text?=?“添加“;

????????}
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????if?（string.IsNullOrEmpty（tbx_TreeNodeName.Text））
????????????{
????????????????MessageBox.Show（“不能為空“）;
????????????????this.tbx_TreeNodeName.Focus（）;
????????????????return;
????????????}
????????????if?（this.validate（this.tbx_TreeNodeName.Text））
????????????{
????????????????MessageBox.Show（“含有不法字符“）;
????????????????this.tbx_TreeNodeName.Focus（）;
????????????????return;
????????????}
????????????string?SqlStr?=?““;
????????????if?（bEditMode）
????????????{
????????????????SqlStr?=?“UPDATE?TreeStructure?SET?Name=‘“?+?tbx_TreeNodeName.Text?+?“‘WHERE?ID=“+Id;
????????????}
????????????else
????????????{
????????????????SqlStr?=?“INSERT?INTO?TreeStructure?（[GroupID][Name]）VALUES（“?+?pId?+?“‘“?+?tbx_TreeNodeName.Text?+?“‘）“;
????????????}
????????????cd?=?new?ConnDatabase（）;
????????????tre?=?new?Tree樹（）;
????????????if?（cd.ConnectionDB（））
????????????{
????????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?cd.Connection（））;
????????????????cmd.ExecuteNonQuery（）;
????????????????this.Close（）;
????????????}
????????}

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

????????///?驗證輸入框代碼塊
????????///?

????????public?bool?validate（string?str）
????????{
????????????string?strobj;
????????????bool?flag?=?false;
????????????for?（int?i?=?0;?i?????????????{
????????????????strobj?=?str.Substring（i?1）;
????????????????if?（strobj?==?“%“?||?strobj?==?“&“?||?strobj?==?“‘“?||?strobj?==?“|“?||?strobj?==?“<“?||?strobj?==?“>“）
????????????????{
????????????????????flag?=?true;
????????????????????break;
????????????????}
????????????}
????????????return?flag;
????????}
????}
}

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

?????文件????3145728??2013-03-08?17:26??簡單的TreeView右鍵增刪改\DAtA\Test.mdf

?????文件????1048576??2013-03-08?17:26??簡單的TreeView右鍵增刪改\DAtA\Test_log.ldf

?????文件??????14848??2013-03-08?17:31??簡單的TreeView右鍵增刪改\DEMO\TreeViewSql.exe

?????文件???????2683??2013-03-08?14:24??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\AddTree.cs

?????文件???????3314??2013-03-07?16:33??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\AddTree.Designer.cs

?????文件??????14848??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\bin\Release\TreeViewSql.exe

?????文件???????1088??2013-03-08?14:39??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\ConnDatabase.cs

?????文件????????818??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Debug\TreeViewSql.csproj.FileListAbsolute.txt

?????文件????????849??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Debug\TreeViewSql.csproj.GenerateResource.Cache

?????文件??????15360??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Debug\TreeViewSql.exe

?????文件??????34304??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Debug\TreeViewSql.pdb

?????文件????????180??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Debug\TreeViewSql.Properties.Resources.resources

?????文件????????180??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Debug\TreeViewSql.Tree樹.resources

?????文件????????834??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Release\TreeViewSql.csproj.FileListAbsolute.txt

?????文件????????849??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Release\TreeViewSql.csproj.GenerateResource.Cache

?????文件??????14848??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Release\TreeViewSql.exe

?????文件??????32256??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Release\TreeViewSql.pdb

?????文件????????180??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Release\TreeViewSql.Properties.Resources.resources

?????文件????????180??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\obj\Release\TreeViewSql.Tree樹.resources

?????文件????????494??2013-03-07?16:32??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Program.cs

?????文件???????1378??2013-03-07?16:28??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Properties\AssemblyInfo.cs

?????文件???????2872??2013-03-07?16:28??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Properties\Resources.Designer.cs

?????文件???????5612??2013-03-07?16:28??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Properties\Resources.resx

?????文件???????1096??2013-03-07?16:28??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Properties\Settings.Designer.cs

?????文件????????249??2013-03-07?16:28??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Properties\Settings.settings

?????文件???????4014??2013-03-08?17:19??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\TreeViewSql.csproj

?????文件???????8283??2013-03-08?17:31??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Tree樹.cs

?????文件???????5901??2013-03-08?17:15??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Tree樹.Designer.cs

?????文件???????6019??2013-03-08?17:15??簡單的TreeView右鍵增刪改\SourceCode\TreeViewSql\Tree樹.resx

?????文件????????923??2013-03-07?16:34??簡單的TreeView右鍵增刪改\SourceCode\TreeView_SQL.sln

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