private void treeList1_CustomDrawNodeCell(object sender, DevExpress.XtraTreeList.CustomDrawNodeCellEventArgs e)
    {
      TreeList node = sender as TreeList;
      if (e.Node == node.FocusedNode)
      {
        e.Graphics.FillRectangle(SystemBrushes.Window, e.Bounds);
        Rectangle r = new Rectangle(e.EditViewInfo.ContentRect.Left, e.EditViewInfo.ContentRect.Top,
        Convert.ToInt32(e.Graphics.MeasureString(e.CellText,  treeList1.Font).Width + 1), Convert.ToInt32(e.Graphics.MeasureString(e.CellText,treeList1.Font).Height));
        e.Graphics.FillRectangle(SystemBrushes.Highlight, r);
        e.Graphics.DrawString(e.CellText, treeList1.Font, SystemBrushes.HighlightText, r);
        e.Handled = true;
      }
    }

 private void BindData()
      {
      this.tlOffice.DataSource = dtOffice;
      tlOffice.KeyFieldName = "OfficeID";
      //tlOffice.DataMember = "OfficeName";
      tlOffice.Columns["OfficeName"].Caption = "局名称";
      tlOffice.ParentFieldName = "ParentOfficeID";
    }

    /// 选择某一节点时,该节点的子节点全部选择 取消某一节点时,该节点的子节点全部取消选择
    /// <param name="node"></param>
    /// <param name="state"></param>
    private void SetCheckedChildNodes(TreeListNode node, CheckState check)
    {
      for (int i = 0; i < node.Nodes.Count; i++)
      {
        node.Nodes[i].CheckState = check;
        SetCheckedChildNodes(node.Nodes[i], check);
      }
  } 

private void tlOffice_AfterCheckNode(object sender, DevExpress.XtraTreeList.NodeEventArgs e) 
{ 
  SetCheckedChildNodes(e.Node, e.Node.CheckState); 
  SetCheckedParentNodes(e.Node, e.Node.CheckState); 
}

 /// 某节点的子节点全部选择时,该节点选择  某节点的子节点未全部选择时,该节点不选择
    /// <param name="node"></param>
    /// <param name="check"></param>
    private void SetCheckedParentNodes(TreeListNode node, CheckState check)
    {
      if (node.ParentNode != null)
      {
        CheckState parentCheckState = node.ParentNode.CheckState;
        CheckState nodeCheckState;
        for (int i = 0; i < node.ParentNode.Nodes.Count; i++)
        {
          nodeCheckState = (CheckState)node.ParentNode.Nodes[i].CheckState;
          if (!check.Equals(nodeCheckState))//只要任意一个与其选中状态不一样即父节点状态不全选
          {
            parentCheckState = CheckState.Unchecked;
            break;
          }
          parentCheckState = check;//否则（该节点的兄弟节点选中状态都相同），则父节点选中状态为该节点的选中状态
        }
        node.ParentNode.CheckState = parentCheckState;
        SetCheckedParentNodes(node.ParentNode, check);//遍历上级节点
      }
    }

private void tlOffice_AfterCheckNode(object sender, DevExpress.XtraTreeList.NodeEventArgs e)
    {
      SetCheckedChildNodes(e.Node, e.Node.CheckState);
      SetCheckedParentNodes(e.Node, e.Node.CheckState);
    }

 private List<int> lstCheckedOfficeID = new List<int>();//选择局ID集合
    /// 获取选择状态的数据主键ID集合
    /// <param name="parentNode">父级节点</param>
    private void GetCheckedOfficeID(TreeListNode parentNode)
    {
      if (parentNode.Nodes.Count == 0)
      {
        return;//递归终止
      }
      foreach (TreeListNode node in parentNode.Nodes)
      {
        if (node.CheckState == CheckState.Checked)
        {
          DataRowView drv = tlOffice.GetDataRecordByNode(node) as DataRowView;//关键代码，就是不知道是这样获取数据而纠结了很久(鬼知道可以转换为DataRowView啊)
          if (drv != null)
          {
            int OfficeID = (int)drv["OfficeID"];
            lstCheckedOfficeID.Add(OfficeID);
          } 
        }
        GetCheckedOfficeID(node);
      }
    }

 private void btnCheck_Click(object sender, EventArgs e)
    {
      this.lstCheckedOfficeID.Clear();
      if (tlOffice.Nodes.Count > 0)
      {
        foreach (TreeListNode root in tlOffice.Nodes)
        {
          GetCheckedOfficeID(root);
        }
      }
      string idStr = string.Empty;
      foreach (int id in lstCheckedOfficeID)
      {
        idStr += id + " ";
      }
      MessageBox.Show(idStr);
    }

 this. 数据库表名TableAdapter.Fill(this.dataDataSet4.数据库表名);

 String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
      connectionString += @"D:\Data.mdb";//这用的是绝对路径

（String connectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
      connectionString += Application.StartupPath + @"\Data.mdb";
 ）
      System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(connectionString);
      con.Open();
      System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("SELECT * FROM FS_STAFF", con);
      System.Data.OleDb.OleDbDataReader reader = cmd.ExecuteReader();
      DataTable table = new DataTable();
      table.Load(reader);
      gridControl2.DataSource = table;