C# Code Help

[boiDev]

i have three treeviews and they used the same database to but use difrent table to populate. I have written the code i just dont know how i am going populate the Others. Please help This is my code that i have done 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) {

[Pedram Behroozi]

Hello dear friend, It's clear that you are new in CP. So read the first post of page1, titled "How to get an answer to your question" by "Chris Maunder", it will guide you how to post your questions. Take a look here[^] and here[^] for more info. Have a nice journey here in CP ;)

While (true) { Human.isLearnable = true; }

[Le centriste]

:rolleyes:

[boiDev]

Thank You Very Much :)

[Le centriste]

Let's see... not too familiar with sarcasm, aren't we?

[boiDev]

Ohh Sorry

[boiDev]

Thank You Very Much

[nelsonpaixao]

Hi Craig, if you need urgent help d´ont post call 911 instead!!! :laugh:

nelsonpaixao@yahoo.com.br trying to help & get help

[Lea Hayes]

Okay... Personally I would create some sort of a class which contains the data I want to access.

    public class MyDataTag
    {
        public MyDataTag(DataRowView dataRow)
        {
            itemID = dataRow\["NodeId"\];
            text = dataRow\["EnNode"\].ToString();
            otherInfo = dataRow\["OtherInfo"\].ToString();
        }

        public object itemID;
        public string text;
        public string otherInfo;
    }

Then I would replace the tree node creation code with:

        TreeNode node = new TreeNode();
        MyDataTag dataTag = new MyDataTag(dv\[i\]);
        node.Text = dataTag.text;
        node.Tag = dataTag;

And your AfterSelect event handler:

        MyDataNode itemData = e.Node.Tag as MyDataNode;
        if (itemData != null)
        {
            string test = string.Format("ID: {0}  Other Info: {1}", itemData.itemID.ToString(), itemData.otherInfo);
            ListViewItem newItem = listView1.Items.Add(test);
            newItem.Tag = itemData;
        }

:) Lea Hayes

[boiDev]

Thank you very much