读取数据库 动态生成树

 

绑定？你要的是数据集一次绑定的？
由于我项目中节点不定的复杂性，我是节点逐个生成，生成时逐个附加数据的

【jiatong1981】:
private bool FillTree()
{
   try
   {
      this._mConn.ConnectionString = ConStrr;
      string _sqlstrr = "select * from PsnInfo";
      this._mDa = new SqlDataAdapter(_sqlstrr,this._mConn);
      this._mDa.Fill(this._mDs,"PersonInfo");
      for (int i = 0; i < _mDs.Tables["PersonInfo"].Rows.Count; i++)
{
string strtemp1,strtemp2,strtemp3;
strtemp1= _mDs.Tables["PersonInfo"].Rows[i]["PersonID"].ToString();
TreeNode parentRoot = new TreeNode(strtemp1);
string _strsql = "select * from PsnDetail where PersonID='" + strtemp1 + "'";
DataSet ds = new DataSet();
_mDa.SelectCommand.CommandText = _strsql;
_mDa.Fill(ds,"city");
for (int j = 0; j < ds.Tables["city"].Rows.Count; j++)
{
   strtemp2 = ds.Tables["city"].Rows[j]["aa"].ToString();
   parentRoot.Nodes.Add(new TreeNode(strtemp2));
}
this.treeView1.Nodes.Add(parentRoot);

}
return true;
}
catch(SqlException ex)
{
MessageBox.Show(ex.Message);
return false;
}
finally
{
this._mConn.Close();
}
}

读取数据库 动态生成树