# 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](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/data-binding/binding-to-datatable), you can use the *ID-ParentID* relation to establish a hierarchy among the menu items.

> note The [Binding to a Data Source](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/getting-started/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](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/server-side-programming/itemdatabound)**:

```C#
protected void RadMenu1_ItemDataBound(object sender, Telerik.Web.UI.RadMenuEventArgs e) 
{ 
	e.Item.ToolTip = (string)DataBinder.Eval(e.Item.DataItem, "ToolTip"); 
}
```

```VB
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:

```ASP.NET
<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

* [Overview](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/data-binding/overview)

* [Using DataBindings](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/data-binding/using-databindings)

* [Binding to Hierarchical DataSource](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/data-binding/binding-to-hierarchical-datasource)

* [Binding to Object-Based Data Sources](https://www.telerik.com/products/aspnet-ajax/documentation/controls/menu/data-binding/binding-to-object-based-data-sources)
