Copy Code code as follows:
Private DataTable gettable (int topid)
{
DataTable dt = null;
Try
{
String constr = "server=.; Database=tqnpc;uid=sa;pwd=sa ";
String selstr = "SELECT * from rw_ working relationship where main_id=" + Topid + "";
SqlConnection con = new SqlConnection (CONSTR);
SqlDataAdapter da = new SqlDataAdapter (Selstr, con);
DT = new DataTable ();
Da. Fill (DT);
}
catch (Exception ex)
{
Response.Write (ex. message);
}
return DT;
}
protected void Maketree ()
{
DataTable dt = gettable (0);
Try
{
if (dt!= null)
{
for (int i = 0; i < dt. Rows.Count; i++)
{
TreeNode tn = new TreeNode ();
Tn. Text = dt. rows[i]["main_id"]. ToString ();
Tn. Value = dt. rows[i]["ref_id"]. ToString ();
Tn. SelectAction = Treenodeselectaction.select;
TreeView1.Nodes.Add (TN);
Addtreenodes (int. Parse (dt. rows[i]["ref_id"]. ToString ()), Int. Parse (dt. rows[i]["ref_id"]. ToString ()), TN);
}
}
}
catch (Exception ex)
{
Response.Write (ex. message);
}
}
This method has certain requirements to the structure of the database, the database design is as follows:
