bind rad drop down tree

[behnam]

how to bind ad drop down tree with sqldata reader

[Shinu]

Hi behnam,

Please try the following code snippet which works fine at my end.

C#:

SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
const string SQL = "SELECT * FROM [Details] ";
SqlCommand myCommand = new SqlCommand(SQL, myConnection);
myConnection.Open();
SqlDataReader myReader = myCommand.ExecuteReader();
RadDropDownTree1.DataFieldID = "id";
RadDropDownTree1.DataFieldParentID = "parentid";
RadDropDownTree1.DataTextField = "text";
RadDropDownTree1.DataSource = myReader;
RadDropDownTree1.DataBind();
myReader.Close();
myConnection.Close();

Thanks,
Shinu.