RadPanelBar 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 RadPanelBar 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);
       RadPanelBar1.DataSource = links;
       RadPanelBar1.DataFieldID = "ID";
       RadPanelBar1.DataFieldParentID = "ParentID";
       RadPanelBar1.DataTextField = "Text";
       RadPanelBar1.DataNavigateUrlField = "URL";
       RadPanelBar1.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)
      RadPanelBar1.DataSource = links
      RadPanelBar1.DataFieldID = "ID"
      RadPanelBar1.DataFieldParentID = "ParentID"
      RadPanelBar1.DataTextField = "Text"
      RadPanelBar1.DataNavigateUrlField = "URL"
      RadPanelBar1.DataBind()
   End If
End Sub 'Page_Load

See Also