如何在c#中使用datatable父表和子表将数据库中的数据结点到树中

DataTable parentTable = new DataTable();
string connectionString = "your_connection_string";
string query = "SELECT * FROM your_table";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    SqlDataAdapter adapter = new SqlDataAdapter(command);
    adapter.Fill(parentTable);
}

DataTable childTable = parentTable.Clone(); // 克隆父表结构作为子表
string filterExpression = "your_filter_expression";
DataRow[] rows = parentTable.Select(filterExpression);
foreach (DataRow row in rows)
{
    childTable.ImportRow(row);
}

TreeView treeView = new TreeView();
foreach (DataRow row in childTable.Rows)
{
    TreeNode node = new TreeNode(row["your_node_text_column"].ToString());
    // 可以根据需要设置节点的其他属性
    treeView.Nodes.Add(node);
}