//实例化dataSet
dataSet = new DataSet();
newdataSet = new DataSet();
TreeNode main = new TreeNode();
main.Text = "所有";
connection = new SqlConnection("Data source = .;Initial Catalog=SuperMarkets;user id = sa; pwd = 12345678;");
string sql = "select distinct ItType from IntoTable";//这个是找出表中所有类型的集合
dataAdapter = new SqlDataAdapter(sql, connection);
//填充到数据集
dataAdapter.Fill(dataSet);
string sql1 = "select distinct ItType from IntoTable";
dataAdapter = new SqlDataAdapter(sql1,connection); dataAdapter.Fill(newdataSet);
DataTable dt = dataSet.Tables[0];
foreach (DataRow dr in dt.Rows)
{
TreeNode NodeType = new TreeNode();
NodeType.Text = dr["ItType"].ToString();
main.Nodes.Add(NodeType);
}
//到这里,所有类型就加进去了
DataTable dt2 = newdataSet.Tables[0];
foreach(DataRow dr in dt2.Rows)
{
foreach(Nodes tn in main.Nodes)//这里提示错误 错误“System.Data.DataRow”不包含“Nodes”的定义 {
if(dr["ItType"].ToString() == tn.Text)
{
TreeNode ProductType = new TreeNode();
ProductType.Text = dr["ItName"].ToString();
dr.Nodes.Add(ProductType);
}
}
}
treeView1.Nodes.Add(main);
treeView1.ExpandAll();
}
dataSet = new DataSet();
newdataSet = new DataSet();
TreeNode main = new TreeNode();
main.Text = "所有";
connection = new SqlConnection("Data source = .;Initial Catalog=SuperMarkets;user id = sa; pwd = 12345678;");
string sql = "select distinct ItType from IntoTable";//这个是找出表中所有类型的集合
dataAdapter = new SqlDataAdapter(sql, connection);
//填充到数据集
dataAdapter.Fill(dataSet);
string sql1 = "select distinct ItType from IntoTable";
dataAdapter = new SqlDataAdapter(sql1,connection); dataAdapter.Fill(newdataSet);
DataTable dt = dataSet.Tables[0];
foreach (DataRow dr in dt.Rows)
{
TreeNode NodeType = new TreeNode();
NodeType.Text = dr["ItType"].ToString();
main.Nodes.Add(NodeType);
}
//到这里,所有类型就加进去了
DataTable dt2 = newdataSet.Tables[0];
foreach(DataRow dr in dt2.Rows)
{
foreach(Nodes tn in main.Nodes)//这里提示错误 错误“System.Data.DataRow”不包含“Nodes”的定义 {
if(dr["ItType"].ToString() == tn.Text)
{
TreeNode ProductType = new TreeNode();
ProductType.Text = dr["ItName"].ToString();
dr.Nodes.Add(ProductType);
}
}
}
treeView1.Nodes.Add(main);
treeView1.ExpandAll();
}
很明确