Try
{
Sqldatareader salespersonreader = getsaleperson ();
Salesordertreeview. imagelist = imglist;
// Traverse and add a Treeview Node
While (salespersonreader. Read ())
{
Treenode salespersonnode = new treenode (salespersonreader. getstring (1 ));
SalesPersonNode. Tag = SalesPersonReader. GetInt32 (0 );
SalesPersonNode. ImageIndex = 0;
SalesPersonNode. StateImageIndex = 0;
SalesPersonNode. SelectedImageIndex = 0;
// Add a salesman Node
SalesOrdertreeView. Nodes. Add (SalesPersonNode );
Sqldatareader salesmarketreader = getsalesmarket (salespersonreader. getint32 (0 ));
// Add a market Node
While (salesmarketreader. Read ())
{
Treenode salesmarketnode = new treenode (salesmarketreader. getstring (1 ));
Salespersonnode. nodes. Add (salesmarketnode );
Salesmarketnode. Tag = salesmarketreader. getint32 (0 );
Salesmarketnode. imageindex = 3;
Salesmarketnode. stateimageindex = 3;
Salesmarketnode. selectedimageindex = 1;
SqlDataReader SalesCustomerReader = GetSalesCustomer (SalesMarketReader. GetInt32 (0 ));
// Add a customer Node
While (SalesCustomerReader. Read ())
{
TreeNode SalesCustomerNode = new TreeNode (SalesCustomerReader. GetString (1 ));
SalesCustomerNode. Tag = SalesCustomerReader. GetInt32 (0 );
SalesCustomerNode. ImageIndex = 5;
SalesCustomerNode. StateImageIndex = 5;
SalesCustomerNode. SelectedImageIndex = 2;
SalesMarketNode. Nodes. Add (SalesCustomerNode );
}
SalesCustomerReader. Close ();
}
SalesMarketReader. Close ();
}
SalesPersonReader. Close ();
}
Catch (Exception EX)
{
MessageBox. Show (EX. Message );
}
Finally
{
Conn. Close ();
}