通过List动态传递参数给 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 == && iNode.Checked==true)
{
richTextBox_tabPage1.AppendText("名称:" + iNode.Name + " | " +
"Caption:" + iNode.Text + " | " +
"Index:" + iNode.Index.ToString() + "\n");
TotalNodeCount = TotalNodeCount + ;
listItem.Add(iNode.Text);
}
;
if (iNode.Nodes.Count > )
{
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=;
richTextBox_tabPage1.AppendText("TotalNode in the treeView1_UserGroup: " + treeView1_UserGroup.GetNodeCount(true).ToString()+"\n");
if (treeView1_UserGroup.Nodes.Count>)
{
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

<略>

上一篇:sql的列的说明


下一篇:jvm系列(五):tomcat性能调优和性能监控(visualvm)