TreeView数据控件 添加新的节点

[w809026418]

我的treeview控件已经从数据库中读取和绑定好了，但是我要添加新的节点到数据库
我在重新进行Treeview进行数据绑定的时候，treeview进行重新的刷新，但是我的问题是我原来tree打开
的节点，就会关闭了。我不想让他关闭，还显示原来打开的Tree的节点，但是我新插入的节点，也要显示

[gongsun]

额...

[llsen]

up

[xu54647265]

在程序加个变量，专门存储当前打开的节点位置，为空的时候关闭全部节点。

[w809026418]

可是当你打开的节点并不是只有一个呢，那我要做多少个变量啊。

[emoheshang]

一个节点，一个节点的绑定上去，不要一下子就全部绑定上去了塞

[emoheshang]

等会给你代码，记得给我分哦

[w809026418]

我的QQ：809026418

[wuyq11]

保存所选值
重新绑定数据后，展开treeview
TreeView.SelectedNode.Parent.Expand()

[emoheshang]

DictionaryDAL.cs里的代码
using Microsoft.ApplicationBlocks.Data;
using System.Data.SqlClient;
using System.Data;
using System;

#region DictionaryDAL
/// <summary>
/// This object represents the properties and methods of a Dictionary.
/// </summary>
public class DictionaryDAL
{
public static void AddDictionary(DictionaryInfo DInfo)
{
string Sql = "Insert into Dictionary(ParentId,Title,DirValue)values(@ParentId,@Title,@DirValue)";

SqlParameter[] arParms = new SqlParameter[3];

arParms[0] = new SqlParameter("@ParentId", SqlDbType.Int);
arParms[0].Value = DInfo.ParentId;
arParms[1] = new SqlParameter("@Title", SqlDbType.VarChar, 50);
arParms[1].Value = DInfo.Title;
arParms[2] = new SqlParameter("@DirValue", SqlDbType.VarChar, 10);
arParms[2].Value = DInfo.DirValue;
using (SqlConnection sqlconn = DALUtil.GetConnection())
{
SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, Sql, arParms);
}
}

public static void EditDictionary(DictionaryInfo DInfo)
{
string Sql = "Update Dictionary set ParentId = @ParentId,Title = @Title,DirValue = @DirValue Where Id = @Id";

SqlParameter[] arParms = new SqlParameter[5];
arParms[0] = new SqlParameter("@Id", SqlDbType.Int);
arParms[0].Value = DInfo.Id;
arParms[1] = new SqlParameter("@ParentId", SqlDbType.Int);
arParms[1].Value = DInfo.ParentId;
arParms[2] = new SqlParameter("@Title", SqlDbType.VarChar, 50);
arParms[2].Value = DInfo.Title;
arParms[3] = new SqlParameter("@DirValue", SqlDbType.VarChar, 10);
arParms[3].Value = DInfo.DirValue;
using (SqlConnection sqlconn = DALUtil.GetConnection())
{
SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, Sql, arParms);
}
}

public static void DelDictionary(int Id)
{
string Sql = "Delete from Dictionary Where Id = @Id";

SqlParameter[] arParms = new SqlParameter[1];
arParms[0] = new SqlParameter("@Id", SqlDbType.Int);
arParms[0].Value = Id;
using (SqlConnection sqlconn = DALUtil.GetConnection())
{
SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, Sql, arParms);
}
}

public static DataSet GetDictionaryDataSet()
{
string Sql = "Select * from Dictionary";

DataSet ds = new DataSet();
using (SqlConnection sqlconn = DALUtil.GetConnection())
{
ds = SqlHelper.ExecuteDataset(sqlconn, CommandType.Text, Sql);
return ds;
}
}

private static DictionaryInfo GetDictionaryInfoByReader(SqlDataReader reader)
{
DictionaryInfo DInfo = new DictionaryInfo();
if (reader != null && !reader.IsClosed && reader.Read())
{
if (reader["Id"] != DBNull.Value)
{
DInfo.Id = (int)reader["Id"];
}

if (reader["ParentId"] != DBNull.Value)
{
DInfo.ParentId = (int)reader["ParentId"];
}

if (reader["Title"] != DBNull.Value)
{
DInfo.Title = (string)reader["Title"];
}

if (reader["DirValue"] != DBNull.Value)
{
DInfo.DirValue = (string)reader["DirValue"];
}

}
else
{
throw new Exception("DataAccess Errors");
}
reader.Close();
return DInfo;
}

public static DictionaryInfo GetDictionaryInfoById(int Id)
{
string Sql = "Select * from Dictionary where Id = @Id";

SqlParameter[] arParms = new SqlParameter[1];
arParms[0] = new SqlParameter("@Id", SqlDbType.Int);
arParms[0].Value = Id;

SqlDataReader sReader = null;
using (SqlConnection sqlconn = DALUtil.GetConnection())
{
sReader = SqlHelper.ExecuteReader(sqlconn, CommandType.Text, Sql, arParms);
return GetDictionaryInfoByReader(sReader);
}
}
}
#endregion
Default.aspx.cs里面的代码
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds = DictionaryDAL.GetDictionaryDataSet();
TreeBind(ds, "0", TreeView1.Nodes);
}

}
public static void TreeBind(DataSet ds,
string ParentId, TreeNodeCollection nodes)
{
DataView dv = new DataView();
TreeNode tmpNd;
string strId;

dv.Table = ds.Tables[0];
dv.RowFilter = "ParentId='" + ParentId + "'";

foreach (DataRowView objRow in dv)
{
tmpNd = new TreeNode();
strId = objRow["Id"].ToString() ;
tmpNd.Value = strId;
tmpNd.Text = objRow["Title"].ToString();
nodes.Add(tmpNd);
TreeBind(ds,strId, nodes[nodes.Count - 1].ChildNodes);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string Title = TextBox1.Text;
//Response.Write(FormateString(Name,10,'0'));
SearchNode(Title, TreeView1.Nodes[0]);
}

private void SearchNode(string SearchName, TreeNode node)
{
if (node.Text.IndexOf(SearchName) >= 0)
{
node.Checked = true;
}
for (int i = 0; i < node.ChildNodes.Count; i++)
{
SearchNode(SearchName, node.ChildNodes[i]);
}

}

private string FormateString(string NoFormateString, int FormatedLong, char Fill)
{
int Strlen = NoFormateString.Length;
if (Strlen >= FormatedLong) return NoFormateString;
for (int i = 0; i < FormatedLong - Strlen; i++)
{
NoFormateString = Fill.ToString() + NoFormateString;
}
return NoFormateString;
}
protected void Button2_Click(object sender, EventArgs e)
{
int ParentId = TreeView1.SelectedNode == null ? 0 : Convert.ToInt32(TreeView1.SelectedNode.Value);

DictionaryInfo dInfo = new DictionaryInfo();
dInfo.Title = TextBox1.Text;
dInfo.ParentId = ParentId;
dInfo.DirValue = "";

try
{
DictionaryDAL.AddDictionary(dInfo);
Page.ClientScript.RegisterClientScriptBlock(GetType(), "aaa", "<script>alert('Success!!');</script>");
}
catch
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "aaa", "<script>alert('Fail!!!');</script>");
}

TreeView1.Nodes.Clear();
TreeView1.ExpandDepth =2 ;
DataSet ds = DictionaryDAL.GetDictionaryDataSet();
TreeBind(ds, "0", TreeView1.Nodes);

}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
TextBox1.Text = TreeView1.SelectedNode.Text;
}
}

[emoheshang]

希望对你有用

[emoheshang]

还有就是一个一个绑定，不一次全部绑定完，只改点点代码就ol
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds = DictionaryDAL.GetDictionaryDataSet();
TreeBind(ds, "0", TreeView1.Nodes);
}

}
public static void TreeBind(DataSet ds,
string ParentId, TreeNodeCollection nodes)
{
DataView dv = new DataView();
TreeNode tmpNd;
string strId;

dv.Table = ds.Tables[0];
dv.RowFilter = "ParentId='" + ParentId + "'";

foreach (DataRowView objRow in dv)
{
tmpNd = new TreeNode();
strId = objRow["Id"].ToString() ;
tmpNd.Value = strId;
tmpNd.Text = objRow["Title"].ToString();
nodes.Add(tmpNd);
//TreeBind(ds,strId, nodes[nodes.Count - 1].ChildNodes);
}
}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
//TextBox1.Text = TreeView1.SelectedNode.Text;
DataSet ds = DictionaryDAL.GetDictionaryDataSet();
if (TreeView1.SelectedNode.ChildNodes.Count <= 0)
{
TreeBind(ds, TreeView1.SelectedNode.Value, TreeView1.SelectedNode.ChildNodes);
}
}

[tangwei5233]

public void FillTemp(TreeNode root, int parentNodeId)
{
foreach (SysFun sysFun in list)
{
if (sysFun.ParentNodeId == parentNodeId)
{
TreeNode node = new TreeNode();
node.Value = sysFun.NodeId.ToString();
node.Text = sysFun.DisplayName;
node.NavigateUrl = sysFun.NavigateUrl;
FillTemp(node, int.Parse(node.Value));
root.ChildNodes.Add(node);
}
}
}

[tangwei5233]

List<SysFun> list;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
list = SysFunManager.GetSysFuns();
TreeNode root = new TreeNode("管理员控制面板");
//root.NavigateUrl = "~/Admin/Index.aspx";
tvwAdmin.Nodes.Add(root);
FillTemp(root, 0);
}
}
public void FillTemp(TreeNode root, int parentNodeId)
{
foreach (SysFun sysFun in list)
{
if (sysFun.ParentNodeId == parentNodeId)
{
TreeNode node = new TreeNode();
node.Value = sysFun.NodeId.ToString();
node.Text = sysFun.DisplayName;
node.NavigateUrl = sysFun.NavigateUrl;
FillTemp(node, int.Parse(node.Value));
root.ChildNodes.Add(node);
}
}
}

[xu54647265]

[Quote=引用 4 楼 w809026418 的回复:]
可是当你打开的节点并不是只有一个呢，那我要做多少个变量啊。
[/Quote]
……你就不会变通下啊，用LIST啊