i want to show all nodes in treeview whatever i enter in database...

Question

0.00/5 (No votes)

See more:

I would like to show all nodes in tree view whatever I enter in database, but it is showing only one node. Only the Top node is showing.

How can I show all the nodes from database?

This is my code:

C#

public partial class treeview : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Data Source=........;Initial Catalog=EmployeeDB;Integrated Security=True");
    TreeNode PNode = new TreeNode();
protected void Page_Load(object sender, EventArgs e)
   {
      BindDataInTreeView();
   }

private void BindDataInTreeView()
   {
        SqlConnection con = new SqlConnection("Data Source=..............;Initial Catalog=EmployeeDB;Integrated Security=True");
     
        DataRow dr;
        TreeView1.Nodes.Clear();
        con.Open();
        string qry = "select * from Student1";
        SqlCommand cmd = new SqlCommand(qry,con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        PNode.CollapseAll();
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i <= dt.Rows.Count-1; i++)
            {
                dr = dt.Rows[i];
                switch (dr["StudentId"].ToString())
                {
                    case "1":
                        PNode = new TreeNode(dr["StudentName"].ToString().Trim());
                        this.TreeView1.Nodes.Add(PNode);
                        break;
                }
                PNode.ExpandAll();
            }
          
        }
    }

protected void btnsave_Click(object sender, EventArgs e)
    {
       con.Open();
       string qry = "insert into Student1 values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";
          SqlCommand cmd = new SqlCommand(qry,con);
           cmd.ExecuteNonQuery();
           con.Close();
           BindDataInTreeView();
    }
 }

Posted 26-Mar-12 20:05pm

rockpune

Updated 26-Mar-12 20:16pm

André Kraak

v2

Add a Solution

Comments

André Kraak 27-Mar-12 2:16am

Edited question:
Added pre tags
Formatted text/code
Spelling/Grammar

Mohamed Mitwalli 27-Mar-12 2:38am

hi ,
you were saying
"would like to show all nodes in tree view whatever I enter in database"
do u mean like parent and Child ??

senguptaamlan 27-Mar-12 2:41am

please, explain the requirement in details....with DB table structure...and all the artifacts....

Mohamed Mitwalli 27-Mar-12 2:52am

you want show all student on the DB right Coz this code only show the First one right

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohamed Mitwalli · Answer 1 · 2012-03-26T20:55:00

If i understand you right this would be ur Solution

C#

SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=test;Integrated Security=True");
    TreeNode PNode = new TreeNode();
    protected void Page_Load(object sender, EventArgs e)
    {
        BindDataInTreeView();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        string qry = "insert into Student1 values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";
        SqlCommand cmd = new SqlCommand(qry, con);
        cmd.ExecuteNonQuery();
        con.Close();
        BindDataInTreeView();
    }

    private void BindDataInTreeView()
    {
        //SqlConnection con = new SqlConnection("Data Source=..............;Initial Catalog=EmployeeDB;Integrated Security=True");

        DataRow dr;
        TreeView1.Nodes.Clear();
        con.Open();
        string qry = "select * from Student1";
        SqlCommand cmd = new SqlCommand(qry, con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        PNode.CollapseAll();
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i <= dt.Rows.Count - 1; i++)
            {
                 dr = dt.Rows[i];
                //switch (dr["StudentId"].ToString())
                //{
                //    case "1":
                //        PNode = new TreeNode(dr["StudentName"].ToString().Trim());
                //        this.TreeView1.Nodes.Add(PNode);
                //        break;


                 PNode = new TreeNode(dr["StudentName"].ToString().Trim());
                 this.TreeView1.Nodes.Add(PNode);
                PNode.ExpandAll();
            }

        }
    }