Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET Treeview
here i have this code where i want to delete all the entries from database which are unchecked in the treeview checkbox. i am able to reach only till the parent nodes.my code doesnt reach till childnodes. kindly help.
 
p.s. i dont want to delete the nodes, i just want to find out which nodes are unchecked on button_click event and delete the values of those nodes in the database.
thanks
 
foreach (TreeNode tn in this.TreeView1.Nodes)
{
int strTreeValue = Convert.ToInt32(tn.Value);
if (tn.Checked == false)
{
SqlCommand com = new SqlCommand("Delete From Role_Menu Where Menu_id=" + strTreeValue, con);
com.ExecuteNonQuery();
}
if (tn.ChildNodes.Count > 0)
{
foreach (TreeNode Ctn in TreeView1.Nodes)
{
SqlCommand com = new SqlCommand("Delete From Role_Menu Where Menu_id=" + strTreeValue, con);
com.ExecuteNonQuery();
}
}
}
Posted 14-Mar-13 19:45pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I think you make a simple mistake. You need to find Child Nodes so your loop must be go through the "tn.ChildNodes". see below code block...
Your code:
if (tn.ChildNodes.Count > 0)
{
    foreach (TreeNode Ctn in TreeView1.Nodes)
    {
        SqlCommand com = new SqlCommand("Delete From Role_Menu Where Menu_id=" + strTreeValue, con);
        com.ExecuteNonQuery();
    }
}
Change Code:
if (tn.ChildNodes.Count > 0)
{
    foreach (TreeNode Ctn in tn.ChildNodes)
    {
        SqlCommand com = new SqlCommand("Delete From Role_Menu Where Menu_id=" + strTreeValue, con);
        com.ExecuteNonQuery();
    }
}
 
Try this maybe it's help you.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You want to delete unchecked nodes . is it?
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

i want to delete the database entries of all unchecked nodes including parent and child nodes.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 490
1 Maciej Los 305
2 Richard MacCutchan 270
3 Mathew Soji 220
4 BillWoodruff 210
0 OriginalGriff 8,834
1 Sergey Alexandrovich Kryukov 7,477
2 DamithSL 5,689
3 Maciej Los 5,329
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411028.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100