treeview 绑定 datatable 或 dataset 添加节点
来源:互联网 发布:淘宝0元购平台 编辑:程序博客网 时间:2024/04/30 14:40
{
public partial class Form1 : Form
{
private static string connString = "Data Source=.;Initial Catalog=***;Integrated Security=True";
public static SqlConnection connection = new SqlConnection(connString);
private DataTable datatable;
SqlDataAdapter dataAdapter;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
BindTree();
}
private DataTable getTreeViewData()
{
string sql = "select no,title from b_table";
try
{
datatable = new DataTable();
dataAdapter = new SqlDataAdapter(sql, connection);
dataAdapter.Fill(datatable);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
return datatable;
}
private void BindTree()
{
datatable = getTreeViewData();
TreeNode allNode = new TreeNode("全部节点");
allNode.Name = "node1";
this.treeView1.Nodes.Add(allNode);
for (int i = 0; i < datatable.Rows.Count; i++) {
TreeNode temp_Node = new TreeNode(datatable.Rows[i]["title"].ToString());
temp_Node.Name = "node2";
allNode.Nodes.Add(temp_Node);
}
this.treeView1.Nodes[0].Expand();
}
}
}
namespace TreeView1
{
public partial class Form1 : Form
{
private static string connString = "Data Source=.;Initial Catalog=***;Integrated Security=True";
public static SqlConnection connection = new SqlConnection(connString);
private DataSet dataset;
SqlDataAdapter dataAdapter;
public Form1()
{
InitializeComponent();
//this.treeView1.LabelEdit = true;
}
private void Form1_Load(object sender, EventArgs e)
{
BindTree();
}
private DataSet getTreeViewData() {
string sql = "select no,title from b_table";
try
{
dataset = new DataSet();
dataAdapter = new SqlDataAdapter(sql,connection);
dataAdapter.Fill(dataset,"table1");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally {
connection.Close();
}
return dataset;
}
private void BindTree() {
dataset = getTreeViewData();
TreeNode allNode = new TreeNode("所有节点");
allNode.Name = "node1";
this.treeView1.Nodes.Add(allNode);
foreach (DataRow temp_Row in dataset.Tables["table1"].Rows) {
TreeNode temp_Node = new TreeNode(temp_Row["title"].ToString());
temp_Node.Name = "node2";
allNode.Nodes.Add(qtemp_Node);
}
this.treeView1.Nodes[0].Expand();
}
}
}
- treeview 绑定 datatable 或 dataset 添加节点
- DataSet,DataTable绑定gridview
- datatable或dataset應用
- treeview递归绑定节点
- asp.net treeview数据库绑定 (节点添加 删除 修改)
- asp.net treeview数据库绑定 (节点添加 删除 修改)
- TreeView与DataTable的绑定
- TreeView与DataTable的绑定
- ASP.NET - 如何:添加或删除 TreeView 节点元素
- DropDownList如何绑定DataTable,如何绑定DataSet
- treeview添加节点
- delphi treeview添加节点
- treeview添加节点
- TreeView添加节点刷新
- TreeView递归添加节点
- 向dataset中添加datatable
- 在DataSet中添加DataTable
- 读取Xml文件,创建DataTable,递归循环Xml节点,添加数据到DataTable,绑定到GridView
- javascript事件处理(续2)
- Java - 高级线程
- 最短路径算法-广度优先搜索
- DB_WRITER_PROCESSES与LOG_ARCHIVE_MAX_PROCESSES
- Android桌面悬浮窗效果实现,仿360手机卫士悬浮窗效果
- treeview 绑定 datatable 或 dataset 添加节点
- NCL命令行快捷键
- Xilinx FPGA用户约束文件
- 为 Fragment 的Preference 添加自定义的布局
- tomcat Per Gem内存不足
- POJ 2516
- 【检测tor程序占用9050端口的办法和解决问题】
- IOS触屏应用开发
- 打印机驱动安装打印机端口监视