Treeview已选中复选框 [英] Treeview checked checkboxes

问题描述

大家好，

我在树视图上工作，我试图在用户再次更新表单时检索已经检查过的树视图复选框。

我已经尝试了很多我试图检索数据库数据并与treeview数据进行比较但没有用。我需要这个东西。请帮我找到这个解决方案。

全部谢谢，

Hi all,
Im working on treeview in which I am trying to retrieve already checked checkboxes of treeview when user updates the form again.
I have tried a lot.I have tried to retrieve the database data and compared to treeview data but no use.I need this thing.Please,help me to find this solution.
Thanks all,

StringBuilder sbSQLCompany = new StringBuilder();
sbSQLCompany.Append("Select HouseFeatureID,HouseName,Features from tblHouseFeatureP");
//SqlConnection conn = new SqlConnection();
//conn.ConnectionString = ConfigurationManager.ConnectionStrings["BuckshawHomesConnectionString"].ToString();
try
{
  using (SqlConnection cn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["BuckshawHomesConnectionString"].ConnectionString))
  {
     using (SqlCommand cm1 = new SqlCommand(sbSQLCompany.ToString(), cn1))
  {
  //cm1.Parameters.AddWithValue("@HouseFeatureID",  Membership.GetUser().ProviderUserKey.ToString());
  cn1.Open();
  using (SqlDataReader rd = cm1.ExecuteReader(CommandBehavior.CloseConnection))
  {
    while (rd.Read())
    {
      string s = rd["Features"].ToString();
      foreach (TreeNode Node in TreeView1.Nodes[0].ChildNodes)
      {
        if(rd["HouseName"].ToString()==tbPropertyName.Text)
        {
          if (Node.Depth == 1)
          {
            if (Node.Text == rd["Features"].ToString())
            {
              Node.Checked = true;
            }
            else
            {
              Node.Checked = false;
            }
          }
        }
      }
    }
  }
}
catch
{

}

推荐答案

这篇关于Treeview已选中复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！