private void AddChilds(string sKeyTemp)
{
Button nodebutton;
Hashtable htselect = new Hashtable();
DataTable dtselect = new System.Data.DataTable();
htselect.Add("@Trans", "ALL_ORDER_ALLOCATE");
// htselect.Add("@Subprocess_id", Subprocess_id);
dtselect = dataaccess.ExecuteSP("Sp_Orders_Que", htselect);
DataTable dtchild = new DataTable();
dtchild = gen.FillChildTable();
for (int i = 0; i < dtchild.Rows.Count; i++)
{
TreeView1.Nodes.Add(dtchild.Rows[i]["User_ID"].ToString(), dtchild.Rows[i]["User_Name"].ToString());
}
foreach (TreeNode myNode in TreeView1.Nodes)
{
//myNode.BackColor = Color.White;
}
}
private void PopulateTreeview()
{
try
{
//get data from user
Hashtable htselect = new Hashtable();
DataTable dtselect = new System.Data.DataTable();
//if (Session_OrderType == "Web/Call")
//{
// htselect.Add("@Trans", "INSERT_ALL_USER_ORDERS");
//}
//else if (Session_OrderType == "Mail/Fax")
//{
// htselect.Add("@Trans", "INSERT_MAIL_FAX_USER_ORDERS");
//}
//else if (Session_OrderType == "QC")
//{
// htselect.Add("@Trans", "INSERT_QC_USER_ORDERS");
//}
//else if (Session_OrderType == "Hold")
//{
// htselect.Add("@Trans", "INSERT_HOLD_USER_ORDERS");
//}
//else if (Session_OrderType == "Clarification")
//{
// htselect.Add("@Trans", "INSERT_CLARIFICATION_USER_ORDERS");
//}
//else if (Session_OrderType == "Cancelled")
//{
// htselect.Add("@Trans", "INSERT_CANCELLED_USER_ORDERS");
//}
htselect.Add("@Trans", "INSERT_ALL_USER_ORDERS");
dtselect = dataaccess.ExecuteSP("Sp_Order_Allocate", htselect);
DataSet ds = new DataSet();
DataTable dtparent = new DataTable();
DataTable dtchild = new DataTable();
dtparent = gen.FillParentTable();
dtparent.TableName = "A";
dtchild = gen.FillChildTable();
dtchild.TableName = "B";
ds.Tables.Add(dtparent);
ds.Tables.Add(dtchild);
ds.Relations.Add("Main_id", dtparent.Columns["Main_id"], dtchild.
Columns["Main_id"]);
if (ds.Tables[0].Rows.Count > 0)
{
TreeView1.Nodes.Clear();
foreach (DataRow masterRow in ds.Tables[0].Rows)
{
TreeNode masterNode = new TreeNode((string)masterRow["Main_Name"],
Convert.ToString(masterRow["Main_Id"]));
TreeView1.Nodes.Add(masterNode);
TreeView1.CollapseAll();
foreach (DataRow childRow in masterRow.GetChildRows("Main_id"))
{
TreeNode childNode = new TreeNode((string)childRow["User_Name"],
Convert.ToString(childRow["Main_id"]));
masterNode.ChildNodes.Add(childNode);
childNode.Value = Convert.ToString(childRow["User_id"]);
}
}
}
TreeView1.ExpandAll();
}
catch (Exception ex)
{
throw new Exception("Unable to populate treeview" + ex.Message);
}
}