Edit this page

Binding to ASP DataSource Components

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

  • SqlDataSource

  • XmlDataSource

  • ObjectDataSource

  • EntityDateSource

  • LinqDataSource

To bind RadSearchBox 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 or fields from the data source.

You can also set the DataKeyNames property to add additional fields from the data source that you will need in the DataItem object for your scenario.

SqlDataSource

Here is a sample that shows how to achieve binding with SqlDataSource.

<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox1" 
    DataSourceID="SqlDataSource1"
    DataValueField="ProductId"
    DataTextField="ProductName">
    <DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
    ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
    SelectCommand="SELECT * FROM [Products]">
</asp:SqlDataSource>

LinqDataSource

Here is a sample that shows how to achieve binding with LinqDataSource.

<asp:LinqDataSource runat="server" ID="LinqDataSource1" ContextTypeName="LinqToSqlReadOnly.NorthwindReadOnlyDataContext"
    OrderBy="ContactName" Select="new (ContactName, City, ContactTitle)" TableName="Customers">
</asp:LinqDataSource>

 <telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox2"  EmptyMessage="Linq"
    DataSourceID="LinqDataSource1" DataValueField="ContactName"
    DataTextField="City">
    <DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>

EntityDateSource

Here is a sample how to doe how to achieve it with EntityDateSource.

<asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=NorthwindEntities35"
    DefaultContainerName="NorthwindEntities35" EntitySetName="Customers" Select="it.[ContactName], it.[City], it.[ContactTitle]"
    AutoPage="true" OrderBy="it.[ContactName]">
</asp:EntityDataSource>
<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox3"  EmptyMessage="Entity"
    DataSourceID="EntityDataSource1" DataValueField="ContactName"
    DataTextField="City">
    <DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>

ObjectDateSource

Here is a sample that shows how to achieve binding with ObjectDateSource.

<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox4"  EmptyMessage="Object"
    DataSourceID="ObjectDataSource1" DataValueField="ID"
    DataTextField="Text">
    <DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>
<asp:ObjectDataSource ID="ObjectDataSource1" TypeName="SearchBoxDataObject" SelectMethod="GetItems"
    runat="server"></asp:ObjectDataSource>


public class SearchBoxDataObject
{
    public SearchBoxDataObject() { }
    public static List<SearchBoxDataItem> GetItems()
    {
        List<SearchBoxDataItem> itemsList = new List<SearchBoxDataItem>();
        itemsList.Add(new SearchBoxDataItem(1, "item 1"));
        itemsList.Add(new SearchBoxDataItem(2, "item 2"));
        itemsList.Add(new SearchBoxDataItem(3, "item 3"));
        return itemsList;
    }
    public class SearchBoxDataItem
    {
        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 SearchBoxDataItem(int id, string text)
        {
            _id = id;
            _text = text;
        }
    }
}


Public Class SearchBoxDataObject
    Public Sub New()
    End Sub
    Public Shared Function GetItems() As List(Of SearchBoxDataItem)
        Dim itemsList As New List(Of SearchBoxDataItem)()
        itemsList.Add(New SearchBoxDataItem(1, "item 1"))
        itemsList.Add(New SearchBoxDataItem(2, "item 2"))
        itemsList.Add(New SearchBoxDataItem(3, "item 3"))
        Return itemsList
    End Function
    Public Class SearchBoxDataItem
        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


XMLDataSource

Here is a sample that shows how to achieve binding with XMLDataSource.

<telerik:RadSearchBox RenderMode="Lightweight" runat="server" ID="RadSearchBox5"  EmptyMessage="XML"
    DataSourceID="XmlDataSource1" DataValueField="Value"
    DataTextField="Text">
    <DropDownSettings Height="400" Width="300" />
</telerik:RadSearchBox>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/ContentFile.xml"></asp:XmlDataSource>
<items>
 <Item Text="New York" Value="1" />
 <Item Text="Paris" Value="2" />
 <Item Text="London" Value="3" />
</items>