This is a migrated thread and some comments may be shown as answers.

Unable to bind TreeList

1 Answer 44 Views
TreeList
This is a migrated thread and some comments may be shown as answers.
Sandeep
Top achievements
Rank 1
Sandeep asked on 15 May 2013, 07:03 AM
Hi All,

I am unable to bind treelist  , i am using DataKeyNames and ParentDataKeyName are in different columns. could you please help me on this.

Regards,
Sandeep Kumar

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 15 May 2013, 10:11 AM
Hi Sandeep,

Try the following code to bind treelist.

ASPX:
 <%-- simple binding--%>
 <telerik:RadTreeList runat="server" ID="RadTreeList1" AllowPaging="true" PageSize="3" DataKeyNames="EmployeeID"  ParentDataKeyNames="ReportsTo">
 </telerik:RadTreeList>
 
<br /><br />
 <%--  Advanced binding--%>
  <telerik:RadTreeList runat="server" ID="RadTreeList2" AllowPaging="true" PageSize="3" DataKeyNames="EmployeeID" ParentDataKeyNames="ReportsTo" OnNeedDataSource="RadTreeList2_NeedDataSource">
  </telerik:RadTreeList>

C#:
protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          RadTreeList1.DataSource = GetDataTable(); //simple binding
          RadTreeList1.DataBind();
      }
  }
public DataTable GetDataTable()
  {
      String ConnString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
      SqlConnection conn = new SqlConnection(ConnString);
      SqlDataAdapter adapter = new SqlDataAdapter();
      adapter.SelectCommand = new SqlCommand("SELECT EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, ReportsTo FROM Employees", conn);
      DataTable myDataTable = new DataTable();
      conn.Open();
      try
      {
          adapter.Fill(myDataTable);
      }
      finally
      {
          conn.Close();
      }
      return myDataTable;
  }
protected void RadTreeList2_NeedDataSource(object source, TreeListNeedDataSourceEventArgs e)
  {
      RadTreeList2.DataSource = GetDataTable(); //Advance binding
  }

Thanks,
Princy.
Tags
TreeList
Asked by
Sandeep
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or