-
大小: 45KB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-06-04
- 語言: C#
- 標(biāo)簽:
資源簡介
Treeview在winform中的運用(從數(shù)據(jù)庫動態(tài)添加節(jié)點,增加節(jié)點、刪除節(jié)點、復(fù)制節(jié)點)

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.Sql;
using?System.Data.SqlClient;
using?System.Windows.Forms;
namespace?Treeview
{
????public?class?Add_Nodes
????{
????????public?void?add(string?FromNodestring?ToName)
????????{
????????????try
????????????{
????????????????SqlConnection?conn?=?new?SqlConnection(“server=INSIGMA112\\SQLEXPRESS;uid=smxzk32145745;pwd=smxzk471848347;database=train“);
????????????????conn.Open();
????????????????SqlCommand?cmm?=?new?SqlCommand(“add_Nodes“?conn);
????????????????cmm.CommandType?=?CommandType.StoredProcedure;
????????????????SqlParameter?str1?=?new?SqlParameter(“@name“?SqlDbType.VarChar?4);
????????????????SqlParameter?str2?=?new?SqlParameter(“@Tonode“?SqlDbType.Int);
????????????????str1.Value?=?FromNode.ToString();
????????????????str2.Value?=?int.Parse(ID(ToName).ToString());
????????????????cmm.Parameters.Add(str1);
????????????????cmm.Parameters.Add(str2);
????????????????cmm.ExecuteNonQuery();
????????????}
????????????catch?(Exception?E)
????????????{
????????????????MessageBox.Show(E.Message);
????????????}
?????????}???????????????????
????????public?static?string?ID(string?ToName)
????????{???????????
????????????????SqlConnection?conn?=?new?SqlConnection(“server=INSIGMA112\\SQLEXPRESS;uid=smxzk32145745;pwd=smxzk471848347;database=train“);
????????????????conn.Open();
????????????????SqlCommand?cmd?=?new?SqlCommand(“select?ID?from?Nodes?where?NodeName=‘“?+?ToName?+?“‘“?conn);
????????????????SqlDataReader?read?=?cmd.ExecuteReader();
????????????????if?(read.Read())
????????????????{
????????????????????return?read[“ID“].ToString();
????????????????}
????????????????else
????????????????{
????????????????????return?“0“;
????????????????}
?????????}??????
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1854??2009-08-05?18:47??Treeview\Treeview\Add_Nodes.cs
?????文件??????28672??2009-08-05?20:22??Treeview\Treeview\bin\Debug\Treeview.exe
?????文件??????40448??2009-08-05?20:22??Treeview\Treeview\bin\Debug\Treeview.pdb
?????文件???????5632??2005-12-08?14:51??Treeview\Treeview\bin\Debug\Treeview.vshost.exe
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\bin\Debug
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\bin
?????文件???????1224??2009-08-05?18:38??Treeview\Treeview\CopyNode.cs
?????文件???????2125??2009-08-05?19:58??Treeview\Treeview\Display.cs
?????文件???????1026??2009-08-05?18:47??Treeview\Treeview\DropNodes.cs
?????文件???????1766??2009-08-05?20:22??Treeview\Treeview\Form1.cs
?????文件??????15431??2009-08-05?20:22??Treeview\Treeview\Form1.Designer.cs
?????文件???????6019??2009-08-05?20:22??Treeview\Treeview\Form1.resx
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\obj\Debug\Refactor
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\obj\Debug\TempPE
?????文件????????842??2009-08-05?20:22??Treeview\Treeview\obj\Debug\Treeview.csproj.GenerateResource.Cache
?????文件??????28672??2009-08-05?20:22??Treeview\Treeview\obj\Debug\Treeview.exe
?????文件????????180??2009-08-05?20:22??Treeview\Treeview\obj\Debug\Treeview.Form1.resources
?????文件??????40448??2009-08-05?20:22??Treeview\Treeview\obj\Debug\Treeview.pdb
?????文件????????180??2009-08-05?16:47??Treeview\Treeview\obj\Debug\Treeview.Properties.Resources.resources
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\obj\Debug
?????文件????????275??2009-08-06?09:07??Treeview\Treeview\obj\Treeview.csproj.FileList.txt
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\obj
?????文件????????467??2009-08-05?13:50??Treeview\Treeview\Program.cs
?????文件???????1164??2009-08-05?13:50??Treeview\Treeview\Properties\AssemblyInfo.cs
?????文件???????2871??2009-08-05?13:50??Treeview\Treeview\Properties\Resources.Designer.cs
?????文件???????5612??2009-08-05?13:50??Treeview\Treeview\Properties\Resources.resx
?????文件???????1092??2009-08-05?13:50??Treeview\Treeview\Properties\Settings.Designer.cs
?????文件????????249??2009-08-05?13:50??Treeview\Treeview\Properties\Settings.settings
?????目錄??????????0??2009-08-06?09:05??Treeview\Treeview\Properties
?????文件???????3380??2009-08-05?19:23??Treeview\Treeview\Treeview.csproj
............此處省略7個文件信息
評論
共有 條評論