RadMenu for ASP.NET
Contents
Access database and OleDbDataAdapter Send comments on this topic.
See Also
Data Binding > Access database and OleDbDataAdapter

Glossary Item Box

Knowing how to databind to DataTable, DataSet or DataView, we can use this knowledge and bind Telerik RadMenu to a table from an Access database.

C# Copy Code
protected void Page_Load(object sender, EventArgs e)
{
   if (!Page.IsPostBack)
   {
       OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM Table1",
           "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
           + Server.MapPath("~/App_Data/db1.mdb"));

       DataSet links = new DataSet();
       adapter.Fill(links);

       RadMenu1.DataSource = links;
       RadMenu1.DataFieldID = "ID";
       RadMenu1.DataFieldParentID = "ParentID";
       RadMenu1.DataTextField = "Text";
       RadMenu1.DataNavigateUrlField = "URL";
       RadMenu1.DataBind();
   }
}
        
VB.NET Copy Code
Protected Sub Page_Load(sender As Object, e As EventArgs)
   If Not Page.IsPostBack Then
      Dim adapter As New OleDbDataAdapter("SELECT * FROM Table1", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
      + Server.MapPath("~/App_Data/db1.mdb"))

      Dim links As New DataSet()
      adapter.Fill(links)

      RadMenu1.DataSource = links
      RadMenu1.DataFieldID = "ID"
      RadMenu1.DataFieldParentID = "ParentID"
      RadMenu1.DataTextField = "Text"
      RadMenu1.DataNavigateUrlField = "URL"
      RadMenu1.DataBind()
   End If
End Sub 'Page_Load

See Also