从Access Db到Treeview [英] From Access Db to Treeview

问题描述

string strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=axb.mdb";
            string strSql = "SELECT Categories , subcategories FROM Categories INNER JOIN subcategories ON Categories .Key= subcategories.Id";
            OleDbConnection con = new OleDbConnection(strProvider);
            OleDbCommand cmd = new OleDbCommand(strSql, con);
            con.Open();
            cmd.CommandType = CommandType.Text;
            OleDbDataReader dr = cmd.ExecuteReader();
 
             DataTable dtTree = new DataTable();
 
             int columnCount = dr.FieldCount;
 
             for (int i = 0; i < columnCount; i++)
             {
                 dataGridView1.Columns.Add(dr.GetName(i).ToString(), dr.GetName(i).ToString());
             }
 
 
             string[] rowData = new string[columnCount];
             while (dr.Read())
             {
                 for (int k = 0; k < columnCount; k++)
                 {
                     if (dr.GetFieldType(k).ToString() == "System.Int32")
                     {
                         rowData[k] = dr.GetInt32(k).ToString();
                     }
 
                     if (dr.GetFieldType(k).ToString() == "System.String")
                     {
                         rowData[k] = dr.GetString(k);
                     }
                 }
 
                 dataGridView1.Rows.Add(rowData);
             }

我向datagrid添加了数据，但是我可以向treeview添加信息.
表类别和子类别与一对多的比率有关.

I add data to datagrid, but i can add information to treeview.
Table Categories and subcategories related to the ratio of one to many

推荐答案

那是什么问题?

请参阅此处 [

So what is the question?

See here[^]

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