Also about the checkbox in treeview

q197688

I want to ask, how does the text value of the multi-select box I use enter the database? I can only enter one. I want to ask how to loop, I don't understand, thank you ~~
code show as below:
 if (TreeView1.CheckedNodes.Count> 0)
        {
            foreach (TreeNode tn in TreeView1.CheckedNodes)
            {
              if (tn.Checked == true)
                {

                    addtext = tn.Text;
                }

            }

        }
        string EIPConnectionString = ConfigurationSettings.AppSettings ["EIPConnectionString"]. ToString ();
        SqlConnection conn = new SqlConnection (EIPConnectionString);
        conn.Open ();
        SqlCommand cmd1 = new SqlCommand ("select KindID, ParentID from sys_menu where Context = '" + addtext + "'", conn);
        SqlDataReader readr = cmd1.ExecuteReader ();
       while (readr.Read ())
        {
          // pid = readr ["pid"]. ToString ();

            kindid = readr ["KindID"]. ToString ();
            preatenid = readr ["ParentID"]. ToString ();
        }

        readr.Close ();
        id = Request ["groupid"]. ToString ();
        SqlCommand cmd = new SqlCommand ("insert into groups_menu (KindID, ParentID, id) values ​​('" + kindid + "', '" + preatenid + "', '" + id + "')", conn);
        cmd.ExecuteNonQuery ();
        Response.Write ("<script> window.alert ('Send successfully!'); </ Script>");
        conn.Close ();

34rere

ArrayList arr = new ArrayList();
            
            if (TreeView1.CheckedNodes.Count> 0)
            {
                foreach (TreeNode node in TreeView1.Nodes)
                {
                    if (node.Checked == true)
                    {
                        arr.Add(node.Text);
                    }
                }
            }

            string addtext = null;
            string EIPConnectionString = ConfigurationSettings.AppSettings["EIPConnectionString"].ToString();
            SqlConnection conn = new SqlConnection(EIPConnectionString);
            conn.Open();
            for (int i = 0; i <arr.Count; i++)
            {
                addtext = arr[i].ToString();
                SqlCommand cmd1 = new SqlCommand("select KindID,ParentID from sys_menu where Context='" + addtext + "'", conn);
                SqlDataReader readr = cmd1.ExecuteReader();
                while (readr.Read())
                {
                    // pid = readr["pid"].ToString();

                    kindid = readr["KindID"].ToString();
                    preatenid = readr["ParentID"].ToString();
                }

                readr.Close();
                id = Request["groupid"].ToString();
                SqlCommand cmd = new SqlCommand("insert into groups_menu(KindID,ParentID,id)values('" + kindid + "','" + preatenid + "','" + id + "')", conn);
                cmd.ExecuteNonQuery();
            }
            
            Response.Write("<script>window.alert('Sent successfully!');</script>");
            conn.Close();

fifa112

TreeView also needs to traverse child nodes

q197688

Solved, thank you very much

kydliu0

kydliu0

Brother, I don’t know how to do that. I can only enter one value. I don’t know how to add all the selected checkbox items to the database. Could you please send the code? Thank you, let me refer to it. under