private void CreateTree( )
{
OracleConnection conn = new OracleConnection(ConnectionString);
adpMs.Fill(dsMs);
{
TreeNode Msnode = new TreeNode();
Msnode.Text = dsMs.Tables[0].Rows[i]["CK_NO"].ToString();
{
TreeNode Pronode = new TreeNode();
if (dsMs.Tables[0].Rows[i]["CK_NO"].ToString() == dsPro.Tables[0].Rows[j]["CK_NO"].ToString())
{
Pronode.Text = dsPro.Tables[0].Rows[j]["Shelve_NO"].ToString();
treeView1.Nodes[i].Nodes.Add(Pronode);
}
}
}
}
{
OracleConnection conn = new OracleConnection(ConnectionString);
OracleDataAdapter adpMs = new OracleDataAdapter("Select Distinct CK_NO from T_GJ_Shelve Order by CK_NO", conn);
DataSet dsMs = new DataSet();adpMs.Fill(dsMs);
OracleDataAdapter adpPro = new OracleDataAdapter("Select Distinct Shelve_NO, CK_NO From T_GJ_Shelve Order by CK_NO, Shelve_NO", conn);
DataSet dsPro = new DataSet(); adpPro.Fill(dsPro);
int MsCount = dsMs.Tables[0].Rows.Count;
int ProCount = dsPro.Tables[0].Rows.Count;
{
TreeNode Msnode = new TreeNode();
Msnode.Text = dsMs.Tables[0].Rows[i]["CK_NO"].ToString();
treeView1.Nodes.Add(Msnode);
{
TreeNode Pronode = new TreeNode();
if (dsMs.Tables[0].Rows[i]["CK_NO"].ToString() == dsPro.Tables[0].Rows[j]["CK_NO"].ToString())
{
Pronode.Text = dsPro.Tables[0].Rows[j]["Shelve_NO"].ToString();
treeView1.Nodes[i].Nodes.Add(Pronode);
}
}
}
}