TreeView 小问题 顶楼主你一下。 http://qzshi.com 网站建设技术论坛 另外招版主,或合作管理员,有兴趣的加群4228406 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 还有个问题:发送空格SendKeys.Send("{BREAK}")无效,求解决方法.目的:实现软键盘(屏幕键盘)的功能,如汉字输入时选择汉字.注意:不要SendKeys.Send(" ") C# code DataSet dsdata=new DataSet(); private void button3_Click(object sender, EventArgs e) { string con = "server=localhost;Integrated Security=SSPI;database=Common"; string sqlstr = "Select ID , parentId , name from Company "; SqlConnection connect = new SqlConnection(con); SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlstr; cmd.Connection = connect; SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = cmd; dap.Fill(dsdata); TreeNode tmnode = new TreeNode("部门"); this.treeView1.Nodes.Add(tmnode); CreatTreeView2(tmnode, 0); } private void CreatTreeView2(TreeNode parentNode,int parentid) { DataRow[] drs = dsdata.Tables[0].Select("parentId= " + parentid.ToString().Trim()); foreach (DataRow dr in drs) { TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim()); parentNode.Nodes.Add(tmnode); CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"])); } } C# code DataSet dsdata=new DataSet(); private void button3_Click(object sender, EventArgs e) { string con = "server=localhost;Integrated Security=SSPI;database=Common"; string sqlstr = "Select ID , parentId , name from Company "; SqlConnection connect = new SqlConnection(con); SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlstr; cmd.Connection = connect; SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = cmd; dap.Fill(dsdata); TreeNode tmnode = new TreeNode("AA"); this.treeView1.Nodes.Add(tmnode); CreatTreeView2(tmnode, 0); } private void CreatTreeView2(TreeNode parentNode,int parentid) { DataRow[] drs = dsdata.Tables[0].Select("parentId= " + parentid.ToString().Trim()); foreach (DataRow dr in drs) { TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim()); parentNode.Nodes.Add(tmnode); CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"])); } } C# code DataSet dsdata=new DataSet(); private void button3_Click(object sender, EventArgs e) { string con = "server=localhost;Integrated Security=SSPI;database=Common"; string sqlstr = "Select ID , ParentNode , name from Company "; SqlConnection connect = new SqlConnection(con); SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlstr; cmd.Connection = connect; SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = cmd; dap.Fill(dsdata); TreeNode tmnode = new TreeNode("部门"); this.treeView1.Nodes.Add(tmnode); CreatTreeView2(tmnode, 0); } private void CreatTreeView2(TreeNode parentNode,int ParentNode ) { DataRow[] drs = dsdata.Tables[0].Select("ParentNode = " + ParentNode .ToString().Trim()); foreach (DataRow dr in drs) { TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim()); parentNode.Nodes.Add(tmnode); CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"])); } } C# code DataSet dsdata=new DataSet(); private void button3_Click(object sender, EventArgs e) { string con = "server=localhost;Integrated Security=SSPI;database=Common"; string sqlstr = "Select ID , ParentNode , name from Company "; SqlConnection connect = new SqlConnection(con); SqlCommand cmd = new SqlCommand(); cmd.CommandText = sqlstr; cmd.Connection = connect; SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = cmd; dap.Fill(dsdata); TreeNode tmnode = new TreeNode("我的列表 "); this.treeView1.Nodes.Add(tmnode); CreatTreeView2(tmnode, 0); } private void CreatTreeView2(TreeNode parentNode,int parentid) { DataRow[] drs = dsdata.Tables[0].Select("ParentNode = " + ParentNode .ToString().Trim()); foreach (DataRow dr in drs) { TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim()); parentNode.Nodes.Add(tmnode); CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"])); } } Good,[tmd456]肯定有60分了,以下的问题送出40分.还有个问题: 发送空格SendKeys.Send("{BREAK}")无效,求解决方法. 目的:实现软键盘(屏幕键盘)的功能,如汉字输入时用空格按钮(button)选择汉字. 注意:不要SendKeys.Send(" ") 递归绑定树;递归绑定树这种方法只适合 一个表总的某一列引用自己的主键的情况..C/S: //创建根节点 public void BindCategoryTreeVew(TreeView treeView, bool isExpanded, string sSelectedData) { //将获取的数据转换为 一个DataTable DataTable dt=GetCategorys().Tables[0]; treeView.Nodes.Clear();//清空 树的所有节点 //获取与排序顺序中的筛选器以及指定的状态相匹配的所有System.Data.DataRow 数组 DataRow []rowlist=dt.Select("ParentID='-1'"); if (rowlist.Length <= 0) return; //创建跟节点 TreeNode rootNode = new TreeNode(); //设置根节点的属性 rootNode.Text = rowlist[0]["Desn"].ToString(); //设置根节点的值 rootNode.Text = rowlist[0]["CategoryID"].ToString(); rootNode.Expanded = isExpanded; rootNode.Selected = true; //添加跟节点 CategoryView.Nodes.Add(rootNode); CreateChildNode(rootNode, dt, isExpanded, sSelectedData); } private void CreateChildNode(TreeNode parentNode, DataTable dt, bool isExpanded, string sSelecedData) { //选择数据,添加排序表达市 DataRow [] rowList = dt.Select("ParentID=" + Convert.ToInt32(parentNode.Value)); foreach (DataRow row in rowList) { //创建一个新的节点了 TreeNode node = new TreeNode(); node.Text = row["Desn"].ToString(); node.Value = row["CategoryID"].ToString(); node.Expanded = isExpanded; if (node.Value == sSelecedData) { node.Selected = true; } parentNode.ChildNodes.Add(node); //递归调用,创建其他节点 CreateChildNode(node,dt,isExpanded,sSelecedData); } } '(' 附近有语法错误。 c# form 中的comboBox做了数据绑定后,回车键不能跳转到下一控件了! 如何判断textbox1中当前输入的字符? 有点难度的正则表达式:判断是否为正确的成绩!解决结贴!! 关于类的地址 一个跟反射有关的问题,初学.NET,还不是很熟练,希望高手赐教,来者有分!(急) 利用ISerializable进行自定义序列化的N多疑问 关于多个DropDownList的关联刷新的问题? Coolshow的C#学习笔记 怎么得到DataSet里Table的索引信息? 文件和文件夹的图像索引ImageIndex是自动生成的吗? 字符串转换问题
发送空格SendKeys.Send("{BREAK}")无效,求解决方法.
目的:实现软键盘(屏幕键盘)的功能,如汉字输入时选择汉字.注意:不要SendKeys.Send(" ")
DataSet dsdata=new DataSet();
private void button3_Click(object sender, EventArgs e)
{
string con = "server=localhost;Integrated Security=SSPI;database=Common";
string sqlstr = "Select ID , parentId , name from Company ";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Connection = connect;
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = cmd;
dap.Fill(dsdata); TreeNode tmnode = new TreeNode("部门");
this.treeView1.Nodes.Add(tmnode);
CreatTreeView2(tmnode, 0);
} private void CreatTreeView2(TreeNode parentNode,int parentid)
{
DataRow[] drs = dsdata.Tables[0].Select("parentId= " + parentid.ToString().Trim()); foreach (DataRow dr in drs)
{
TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim());
parentNode.Nodes.Add(tmnode);
CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"]));
}
}
DataSet dsdata=new DataSet();
private void button3_Click(object sender, EventArgs e)
{
string con = "server=localhost;Integrated Security=SSPI;database=Common";
string sqlstr = "Select ID , parentId , name from Company ";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Connection = connect;
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = cmd;
dap.Fill(dsdata); TreeNode tmnode = new TreeNode("AA");
this.treeView1.Nodes.Add(tmnode);
CreatTreeView2(tmnode, 0);
} private void CreatTreeView2(TreeNode parentNode,int parentid)
{
DataRow[] drs = dsdata.Tables[0].Select("parentId= " + parentid.ToString().Trim()); foreach (DataRow dr in drs)
{
TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim());
parentNode.Nodes.Add(tmnode);
CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"]));
}
}
DataSet dsdata=new DataSet();
private void button3_Click(object sender, EventArgs e)
{
string con = "server=localhost;Integrated Security=SSPI;database=Common";
string sqlstr = "Select ID , ParentNode
, name from Company ";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Connection = connect;
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = cmd;
dap.Fill(dsdata); TreeNode tmnode = new TreeNode("部门");
this.treeView1.Nodes.Add(tmnode);
CreatTreeView2(tmnode, 0);
} private void CreatTreeView2(TreeNode parentNode,int ParentNode
)
{
DataRow[] drs = dsdata.Tables[0].Select("ParentNode
= " + ParentNode
.ToString().Trim()); foreach (DataRow dr in drs)
{
TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim());
parentNode.Nodes.Add(tmnode);
CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"]));
}
}
DataSet dsdata=new DataSet();
private void button3_Click(object sender, EventArgs e)
{
string con = "server=localhost;Integrated Security=SSPI;database=Common";
string sqlstr = "Select ID , ParentNode
, name from Company ";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Connection = connect;
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = cmd;
dap.Fill(dsdata); TreeNode tmnode = new TreeNode("我的列表 ");
this.treeView1.Nodes.Add(tmnode);
CreatTreeView2(tmnode, 0);
} private void CreatTreeView2(TreeNode parentNode,int parentid)
{
DataRow[] drs = dsdata.Tables[0].Select("ParentNode
= " + ParentNode
.ToString().Trim()); foreach (DataRow dr in drs)
{
TreeNode tmnode = new TreeNode(dr["name"].ToString().Trim());
parentNode.Nodes.Add(tmnode);
CreatTreeView2(tmnode, Convert.ToInt32(dr["ID"]));
}
}
发送空格SendKeys.Send("{BREAK}")无效,求解决方法.
目的:实现软键盘(屏幕键盘)的功能,如汉字输入时用空格按钮(button)选择汉字. 注意:不要SendKeys.Send(" ")
递归绑定树
这种方法只适合 一个表总的某一列引用自己的主键的情况..
C/S:
//创建根节点
public void BindCategoryTreeVew(TreeView treeView, bool isExpanded, string sSelectedData)
{
//将获取的数据转换为 一个DataTable
DataTable dt=GetCategorys().Tables[0];
treeView.Nodes.Clear();//清空 树的所有节点
//获取与排序顺序中的筛选器以及指定的状态相匹配的所有System.Data.DataRow 数组
DataRow []rowlist=dt.Select("ParentID='-1'");
if (rowlist.Length <= 0) return;
//创建跟节点
TreeNode rootNode = new TreeNode();
//设置根节点的属性
rootNode.Text = rowlist[0]["Desn"].ToString();
//设置根节点的值
rootNode.Text = rowlist[0]["CategoryID"].ToString();
rootNode.Expanded = isExpanded;
rootNode.Selected = true;
//添加跟节点
CategoryView.Nodes.Add(rootNode);
CreateChildNode(rootNode, dt, isExpanded, sSelectedData); }
private void CreateChildNode(TreeNode parentNode, DataTable dt, bool isExpanded, string sSelecedData)
{
//选择数据,添加排序表达市
DataRow [] rowList = dt.Select("ParentID=" + Convert.ToInt32(parentNode.Value));
foreach (DataRow row in rowList)
{
//创建一个新的节点了
TreeNode node = new TreeNode();
node.Text = row["Desn"].ToString();
node.Value = row["CategoryID"].ToString();
node.Expanded = isExpanded;
if (node.Value == sSelecedData)
{
node.Selected = true;
}
parentNode.ChildNodes.Add(node);
//递归调用,创建其他节点
CreateChildNode(node,dt,isExpanded,sSelecedData);
}
}