|
Search Engine Optimization Romania |
 |
www.seo-romania.ro |
|
|
|
|
|
Dynamic TreeView
|
|
|
Pentru popularea dinamica a unui TreeView
pagina.aspx.cs
void fill_Tree()
{
SqlConnection SqlCon = new SqlConnection("seteaza conexiunea");
if (SqlCon.State != ConnectionState.Open)
SqlCon.Open();
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand SqlCmd;
string idcateg = "";
string idsubcateg = "";
string idprod = "";
SqlCmd = new SqlCommand("Selecteaza categoriile", SqlCon);
SqlDataReader Sdr = SqlCmd.ExecuteReader();
SqlCmd.Dispose();
string[,] ParentNode = new string[100, 2];
int count = 0;
while (Sdr.Read())
{
ParentNode[count, 0] = Sdr.GetValue(Sdr.GetOrdinal("idCategorie")).ToString();
ParentNode[count++, 1] = Sdr.GetValue(Sdr.GetOrdinal("denumireCategorie")).ToString();
}
Sdr.Close();
SqlCommand SqlCmd1;
SqlCmd1 = new SqlCommand("Selecteaza subcategoriile", SqlCon);
SqlDataReader Sdr1 = SqlCmd1.ExecuteReader();
SqlCmd1.Dispose();
string[,] ChildNode = new string[100, 2];
int count1 = 0;
while (Sdr1.Read())
{
ChildNode[count1, 0] = Sdr1.GetValue(Sdr1.GetOrdinal("idSubCategorie")).ToString();
ChildNode[count1++, 1] = Sdr1.GetValue(Sdr1.GetOrdinal("denumireSubCategorie")).ToString();
}
Sdr1.Close();
string sqlString;
sqlString = "selecteaza produsele";
cmd.Connection = SqlCon;
cmd.CommandText = sqlString;
da.SelectCommand = cmd;
da.Fill(ds, "tbl");
for (int loop = 0; loop < count; loop++)
{
TreeNode root = new TreeNode();
root.Text = ParentNode[loop, 1];
root.NavigateUrl = "pagina-categorie.aspx?idCategorie="
+ ParentNode[loop, 0].ToString();
SqlCommand Module_SqlCmd;
Module_SqlCmd = new SqlCommand("Selecteaza subcategoriile
where idCategorie=" + ParentNode[loop, 0], SqlCon);
SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader();
while (Module_Sdr.Read())
{
TreeNode child = new TreeNode();
child.Text = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("Denumire")).ToString();
root.ChildNodes.Add(child);
string m = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("idSubcategorie")).ToString();
child.NavigateUrl = "pagina-subcategorie.aspx?idCategorie="
+ ParentNode[loop, 0].ToString() + "&idSubCategorie=" + m;
for (int i = 0; i < ds.Tables["tbl"].Rows.Count;
i++)
{
if (ds.Tables["tbl"].Rows[i][5].ToString()
== m)
{
TreeNode
child1 = new TreeNode();
child1.Text
= ds.Tables["tbl"].Rows[i][2].ToString();
child1.NavigateUrl
= "pagina-produs.aspx?idCategorie=" + ParentNode[loop, 0].ToString() + "&idSubCategorie="
+ m + "&idProdus=" + ds.Tables["tbl"].Rows[i][0].ToString();
child.ChildNodes.Add(child1);
}
}
}
Module_Sdr.Close();
TreeView1.Nodes.Add(root);
}
TreeView1.CollapseAll();
SqlCon.Close();
} |
in Page_Load
if (!Page.IsPostBack)
{
fillTree();
}
|
Pagina.aspx
Pur si simplu drag and drop TreeView din Toolbox/Navigation
|
|
|
|