Edit this page

Binding to Table-Based DataSource

Table-based DataSource components, such as SqlDataSource and AccessDataSource can be used to bind the menu declaratively at design time. As with binding to a DataSet, DataTable, or DataView, you can use the ID-ParentID relation to establish a hierarchy among the menu items.

note

The Binding to a Data Source tutorial gives step-by-step instructions for binding RadMenu to an AccessDataSource.

To bind to a table-based DataSource component:

  1. Drag the DataSource component from the toolbox onto the same page as your RadMenu component.

  2. Configure the DataSource component to connect to the data.

  3. Set the DataSourceID property of your RadMenu to the ID of the DataSource component you added in step 1.

  4. Set the DataTextField, DataValueField, and DataNavigateUrlField properties to indicate the columns of the database table that supply values for the Text, Value, and NavigateUrl properties of menu items.

  5. Establish the menu hierarchy by setting the DataFieldID property to the key field for records, and the DataFieldParentID property to the field that gives the key field value of the parent item.

caution

The ParentID of the root items must be null ( nothing ). If for some reason the data source comes without null values for the ParentID column, use a query that returns the expected value (null). For example:
SELECT ID, Text, IF(ParentID = 0, NULL, ParentID) FROM tblDat

  1. Bind any additional properties of the menu items using the ItemDataBound event:
protected void RadMenu1_ItemDataBound(object sender, Telerik.Web.UI.RadMenuEventArgs e) 
{ 
    e.Item.ToolTip = (string)DataBinder.Eval(e.Item.DataItem, "ToolTip"); 
}
Protected Sub RadMenu1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadMenuEventArgs) Handles RadMenu1.ItemDataBound
    e.Item.ToolTip = CStr(DataBinder.Eval(e.Item.DataItem, "ToolTip"))
End Sub

The resulting declaration looks something like the following:

<telerik:RadMenu RenderMode="Lightweight" runat="server" ID="RadMenu1" DataSourceID="SqlDataSource1" DataFieldID="id"
    DataFieldParentID="parentID" DataTextField="Targetname" DataNavigatUrlField="target"
    OnItemDataBound="RadMenu1_ItemDataBound">
</telerik:RadMenu>
<asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString="Persist Security Info=False;Integrated Security=true;Initial Catalog=MyDB;server=(local)"
    ProviderName="System.Data.SqlClient" SelectCommand="SELECT id, Targetname, target, tooltip, parentId from MenuTable" />

See Also