Binding to ASP DataSource components

RadAutoCompleteBox supports binding to all ASP.NET 2.0 DataSource components, including:

• AccessDataSource

• SqlDataSource

• XmlDataSource

• ObjectDataSource

• SiteMapDataSource

• LinqDataSource

To bind RadAutoCompleteBox to a DataSource component, you need to set its DataSourceID property to the ID of the DataSource component. You should also set its DataTextField and DataValueField properties to map the Text and Value properties of the items to the respective columns / fields from the data source.

AccessDataSource

<telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" runat="server" DataSourceID="AccessDataSource1"
        DataTextField="ProductName" DataValueField="ProductID">
</telerik:RadAutoCompleteBox>

<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Nwind.mdb"
        SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], 
        [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued] FROM [Products]">
</asp:AccessDataSource>

SqlDataSource

<telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" runat="server" DataSourceID="SqlDataSource1"
        DataTextField="ProductName" DataValueField="ProductID">
</telerik:RadAutoCompleteBox>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
        ProviderName="<%$ ConnectionStrings:NorthwindConnectionString.ProviderName %>"
        SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], 
        [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued] FROM [Products]">
</asp:SqlDataSource>    

XmlDataSource

<telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" runat="server" DataSourceID="Xmldatasource1"
    DataTextField="Text" DataValueField="Value">
</telerik:RadAutoCompleteBox>

<asp:XmlDataSource ID="Xmldatasource1" runat="server" DataFile="~/App_Data/RadAutoCompleteBox.xml" XPath="/Items/Item" />

When using an XmlDataSource, the XML file should have the format shown below:

<Items>
  <Item Text="Barcelona" Value="14" />
  <Item Text="Bonn" Value="18" />
  <Item Text="Boston" Value="9" />
  <Item Text="Brussels" Value="17" />
</Items>

ObjectDataSource

<telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" runat="server" DataSourceID="ObjectDataSource1"
    DataTextField="Text" DataValueField="ID">
</telerik:RadAutoCompleteBox>

<asp:ObjectDataSource ID="ObjectDataSource1" TypeName="RadAutoCompleteBoxObjectData" SelectMethod="GetItems"
runat="server"></asp:ObjectDataSource>

public class RadAutoCompleteBoxObjectData
{
    public RadAutoCompleteBoxObjectData()
    {
    }

    public static List<AutoCompleteBoxDataItem> GetItems()
    {
        List<AutoCompleteBoxDataItem> itemsList = new List<AutoCompleteBoxDataItem>(); 
        itemsList.Add(new AutoCompleteBoxDataItem(1, "New York")); 
        itemsList.Add(new AutoCompleteBoxDataItem(2, "Rome")); 
        itemsList.Add(new AutoCompleteBoxDataItem(3, "Paris"));
        return itemsList;
    }
    public class AutoCompleteBoxDataItem
    {
        private string _text; 
        private int _id;
        public string Text 
        { 
            get 
            { 
                return _text; 
            } 
            set 
            { 
                _text = value; 
            } 
        }
        public int ID 
        { 
            get 
            { 
                return _id; 
            } 
            set 
            { 
                _id = value; 
            } 
        }
        public AutoCompleteBoxDataItem(int id, string text) 
        {
            _id = id; 
            _text = text; 
        }
    }
}

Public Class RadAutoCompleteBoxObjectData
    Public Sub New()
    End Sub

    Public Shared Function GetItems() As List(Of AutoCompleteBoxDataItem)
        Dim itemsList As New List(Of AutoCompleteBoxDataItem)()
        itemsList.Add(New AutoCompleteBoxDataItem(1, "New York"))
        itemsList.Add(New AutoCompleteBoxDataItem(2, "Rome"))
        itemsList.Add(New AutoCompleteBoxDataItem(3, "Paris"))
        Return itemsList
    End Function
    Public Class AutoCompleteBoxDataItem
        Private _text As String
        Private _id As Integer
        Public Property Text() As String
            Get
                Return _text
            End Get
            Set(value As String)
                _text = value
            End Set
        End Property
        Public Property ID() As Integer
            Get
                Return _id
            End Get
            Set(value As Integer)
                _id = value
            End Set
        End Property
        Public Sub New(id As Integer, text As String)
            _id = id
            _text = text
        End Sub
    End Class
End Class

See Also

• Overview