通过List<String>动态传递参数给 sqlcommand.Parameters

通过List<String>动态传递参数

 private void GetallChecked_TreeNote(TreeNodeCollection aNodes, ref  int TotalNodeCount, ref  List<string> listItem)
        {

            foreach (TreeNode iNode in aNodes)  
            {

                if (iNode.Nodes.Count == 0 && iNode.Checked==true)
                {
                    richTextBox_tabPage1.AppendText("名称：" + iNode.Name + " | " +
                            "Caption：" + iNode.Text + " | " +
                            "Index：" + iNode.Index.ToString() + "\n");
                    TotalNodeCount = TotalNodeCount + 1;
                    listItem.Add(iNode.Text);
                }
                ;
                if (iNode.Nodes.Count > 0)
                {
                    GetallChecked_TreeNote(iNode.Nodes, ref TotalNodeCount,ref listItem);
                }

            }
        }

 

调用

 private void button2_Click(object sender, EventArgs e)
        {
            int TotalNodeCount;
           
          
            List<string> listItem = new List<string>();
            TotalNodeCount=0;
            richTextBox_tabPage1.AppendText("TotalNode in the treeView1_UserGroup: " + treeView1_UserGroup.GetNodeCount(true).ToString()+"\n");
            if (treeView1_UserGroup.Nodes.Count>0)
            {
                GetallChecked_TreeNote(treeView1_UserGroup.Nodes, ref TotalNodeCount,ref listItem);
            }
            richTextBox_tabPage1.AppendText("Total Selected Nodes : " + TotalNodeCount.ToString() + "\n");
            richTextBox_tabPage1.AppendText("Selected Nodes : " + string.Join(",",listItem.ToArray())+ "\n");
            richTextBox_tabPage1.AppendText("Selected Nodes : " + string.Concat("'", string.Join(",", listItem.ToArray()),"'") + "\n");
            richTextBox_tabPage1.AppendText("Selected Nodes : " + string.Join(",", listItem.Select(x => "'" + x + "'").ToArray()) + "\n");
  }

 

动态 传递给sqlparamter

<略>