Populating the TreeView

Hello Kiran,


Thanx for the help. This thing is started to work now :). You're the best!


Regards!

Hello Kiran,

Thanx for the response. My query for the retrieval of record is

string getOnline = "Select Friend from FriendList";

and it gets all the fields in the 'Friend' column and put them in the tree view under the same Root/Node i.e. Online.

Any information about the exception?

Thanx for the code and the response.


Regards!

what is your query to be executed,you want to get a single row,or you want to get all the rows to treeview...


MARK THE ANSWER IF IT HELPED YOU

TreeNode Online = new TreeNode();
         
            conn.Open();            
            SqlCommand cmd = new SqlCommand(getOnline,conn);
            SqlDataReader reader = null;
            reader = cmd.ExecuteReader();            
            while (reader.Read())
            {
                this.trv_ShowUsers.Nodes.Add(Online);
                Online.Text = "Online Users";
                Online.Nodes.Add(reader[0].ToString());
            }
            conn.Close();

This is the code but its giving the exception of "Cannot add or insert the item 'Online Users' in more than one place. You must first remove it from its current location or clone it.".

hello rashid,i am helping you with complete code and design...
suppose this is my database table
rollno     name  class
1231     kiran     10
1232     kumar    9
1233     kkk        8

CHECK THE 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.Data.SqlClient;

namespace treeview
{
public partial class Form1 : Form
{
TreeView tr = new TreeView();
TreeNode[] student = new TreeNode[10];


public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
this.tr.Location = new Point(60, 35);
this.tr.Size = new Size(341, 246);
SqlConnection con = new SqlConnection("Data Source=KIRAN\\SQLEXPRESS;Initial Catalog=kiran;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from tree",con);
SqlDataReader dr = cmd.ExecuteReader();
int i=0;
while (dr.Read())
{
i++;
student[i] = new TreeNode();
student[i].Text = "student"+i+"";
this.tr.Nodes.Add(student[i]);
this.student[i].Nodes.Add(dr["rollno"].ToString());
this.student[i].Nodes.Add(dr["name"].ToString());
this.student[i].Nodes.Add(dr["class"].ToString());
}
con.Close();
this.Controls.Add(tr);

}
}
}
MARK THE ANSWER IF IT HELPED YOU