CODE
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.Threading;
using System.Collections;
using System.Data.SqlClient;
namespace Envision
{
public partial class Envision : Form
{
SqlConnection conn = new SqlConnection("Data Source=ICNWS00054;Initial Catalog=EnvisionPlatformDatabase;User ID=sa;Password=3Password5");
SqlDataAdapter dtd;
DataSet ds;
DataView dv;
public TreeNode node;
public Envision()
{
InitializeComponent();
}
//
private void GetData(int EnCid, TreeNode EnNode)
{
dv = ds.Tables[0].DefaultView;
dv.RowFilter = "EnCid=" + EnCid;
int dvC = dv.Count;
if (EnNode == null)
{
int i = 0;
while (i < dvC)
{
dv = ds.Tables[0].DefaultView;
dv.RowFilter = "EnCid=" + EnCid;
TreeNode node = new TreeNode();
node.Text = dv[i]["EnNode"].ToString();
node.Tag = int.Parse(dv[i]["NodeId"].ToString());
this.treeView1.Nodes.Add(node);
GetData((int)node.Tag, node);
i++;
}
}
else
{
int i = 0;
while (i < dvC)
{
dv = ds.Tables[0].DefaultView;
dv.RowFilter = "EnCid=" + EnCid;
TreeNode node = new TreeNode();
node.Text = dv[i]["EnNode"].ToString();
node.Tag = int.Parse(dv[i]["NodeId"].ToString());
EnNode.Nodes.Add(node);
GetData(int.Parse(dv[i]["NodeId"].ToString()), node);
i++;
}
}
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
ArrayList EnvisionP = new ArrayList();
TreeNode EnNode = new TreeNode("EnNode");
EnNode.Tag = EnvisionP;
dtd = new SqlDataAdapter("select * from [User Panel] order by NodeId", conn);
ds = new DataSet();
dtd.Fill(ds, "User Panel");
GetData(0, null);
}
private void ultraExplorerBar1_ItemClick(object sender, Infragistics.Win.UltraWinExplorerBar.ItemEventArgs e)
{
}
private void treeView1_AfterSelect_1(object sender, TreeViewEventArgs e)
{
}
private void treeView2_AfterSelect(object sender, TreeViewEventArgs e)
{
}
private void ultraListView1_ItemActivated(object sender, Infragistics.Win.UltraWinListView.ItemActivatedEventArgs e)
{
}
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
}
Hi I am trying to make three treeviews to populate from the same database but using diffrent tables for each tree view.
Can Some One Help Me
Mod edit - Please
~BetaWar
| 