TREELIST 与数据库绑定

最新推荐文章于 2022-05-10 23:34:13 发布

Rex2008

最新推荐文章于 2022-05-10 23:34:13 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/Rex2008/article/details/1550449

本文展示了如何将TREELIST控件与数据库进行绑定，通过C#代码实现与SQL Server数据库中Customers和Orders表的交互，创建父子节点结构，以便于展示客户及其对应的订单。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

PS:结合KARLI的数据库代码和网络一位兄弟的TREELIST代码，写了如下的TREELIST 与数据库绑定的代码，希望对各位有点小帮助。

private void Form1_Load(object sender, EventArgs e)
        {
            SqlConnection thisConn = new SqlConnection(@"server=sun;database=Northwind;user=sa;password=0810");
            SqlDataAdapter thisDA = new SqlDataAdapter("SELECT CustomerID,CompanyName FROM Customers", thisConn);
            SqlCommandBuilder thisCB = new SqlCommandBuilder(thisDA);

DataSet thisDS = new DataSet();

            SqlDataAdapter custAD = new SqlDataAdapter("SELECT * FROM Customers", thisConn);
            custAD.Fill(thisDS, "Customers");
            SqlDataAdapter orderAD = new SqlDataAdapter("SELECT * FROM Orders", thisConn);
            orderAD.Fill(thisDS, "Orders");

DataRelation custOrderRel = thisDS.Relations.Add("CustOrders", thisDS.Tables["Customers"].Columns["CustomerID"], thisDS.Tables["Orders"].Columns["CustomerID"]);

           treeView1.Nodes.Clear();
           TreeNode tableTree = new TreeNode("客户");
           treeView1.Nodes.Add(tableTree);

            foreach (DataRow custRow in thisDS.Tables["Customers"].Rows)
           {
               TreeNode newNode = new TreeNode(custRow["CompanyName"].ToString());
               tableTree.Nodes.Add(newNode);
               int depth = newNode.Index;
                foreach (DataRow orderRow in custRow.GetChildRows(custOrderRel ))
                {
                    TreeNode newNode1=new TreeNode(orderRow ["OrderID"].ToString());
                    newNode.Nodes.Add(newNode1);
                }

           }
           treeView1.ExpandAll();
           thisConn.Close();
        }