Hi,
i already check on forum that this problem happened to other users, i tried solution but doesn't work...
here is from sql query:
siteid userid username sitename
here is .cs code:
So ,code is quite easy, i just don't get how to solve the problem ??
THanks
I expect something like this:
*Simon
->paris 15
->Silac
->Zonya
i already check on forum that this problem happened to other users, i tried solution but doesn't work...
here is from sql query:
siteid userid username sitename
331 | 13 | Simon | Paris 15ème |
2167 | 13 | Simon | Silac |
330 | 13 | Simon | Zonya |
here is .cs code:
private void GenerateTreeView() { OleDbConnection dbCon = new OleDbConnection("Provider=SQLOLEDB;Data Source=PC-DEV002\\SQLEXPRESS;Persist Security Info=True;Password=dcube2005*;User ID=sa;Initial Catalog=SuiviConso"); dbCon.Open(); OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT su.SiteId, u.userid, u.nomUser, s.NomSite FROM [User] AS u LEFT OUTER JOIN Rel_Site_User AS su ON su.UserId = u.UserId LEFT OUTER JOIN Sites AS s ON s.SiteID = su.SiteId WHERE (su.UserId = 13) ", dbCon); DataSet ds = new DataSet(); adapter.Fill(ds); RadTreeView1.DataFieldID = "SiteId"; RadTreeView1.DataFieldParentID = "UserId"; RadTreeView1.DataTextField = "nomUser"; RadTreeView1.DataValueField = "NomSite"; RadTreeView1.DataSource = ds; RadTreeView1.DataBind(); RadTreeView1.ExpandAllNodes(); }Here is the aspx:
<telerik:RadTreeView ID="RadTreeView1" runat="server" Width="100%" Height="250px"> <DataBindings> <telerik:RadTreeNodeBinding Expanded="true"></telerik:RadTreeNodeBinding> </DataBindings> </telerik:RadTreeView>
So ,code is quite easy, i just don't get how to solve the problem ??
THanks
I expect something like this:
*Simon
->paris 15
->Silac
->Zonya