New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

Declarative Binding

ObjectDataSource

SqlDataSource

XmlDataSource

RadAutoCompleteBox can be bound to all ASP.NET Data Source controls:

  • AccessDataSource
  • ObjectDataSource
  • XmlDataSource
  • SqlDataSource
  • SiteMapDataSource
  • LinqDataSource

Databinding properties and methods used when binding RadAutoCompleteBox to a data source:

  • DataSource property - set to an instance of the data source.
  • DataSourceID property - set to the ID of the data source.
  • DataMember property - if the data source is a DataSet and DataMember is a set, then RadAutoCompleteBox is bound to the DataTable with the respective name in the DataSet.
  • DataTextField property - field name from the data source bound to the AutoCompleteBoxItemData's Text property.
  • DataValueField property - field name from the data source bound to the AutoCompleteBoxItemData's Value property.
  • DataBind method - must be called after the aforementioned properties are set when binding at runtime.
  • DefaultVB.aspx
  • DefaultVB.aspx.vb
  • autocomplete.xml
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="DefaultVB.aspx.vb" Inherits="AutoCompleteBox.Examples.DeclarativeDataSources.DefaultVB" %>

<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head runat="server">
    <title>Telerik ASP.NET Example</title>
</head>

<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadSkinManager ID="RadSkinManager1" runat="server" ShowChooser="true" />

    <div class="demo-container size-thin">
        <h2>ObjectDataSource</h2>
        <telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" runat="server"  Width="300" MaxResultCount="5"
            DataSourceID="ObjectDataSource1" DataTextField="Title" DataValueField="Id" EmptyMessage="Select Movies">
        </telerik:RadAutoCompleteBox>
    </div>
    <div class="demo-container size-thin">
        <h2>SqlDataSource</h2>
        <telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox2" runat="server"  Width="300" MaxResultCount="5"
            DropDownHeight="180" DataSourceID="SqlDataSource1" DataTextField="ContactName" EmptyMessage="Select Customers"
            DataValueField="CustomerID">
        </telerik:RadAutoCompleteBox>
    </div>

    <div class="demo-container size-thin">
        <h2>XmlDataSource</h2>
        <telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox3" runat="server"  Width="300" MaxResultCount="5"
            DataTextField="Text" DataValueField="Value" EmptyMessage="Select Product Families">
        </telerik:RadAutoCompleteBox>
    </div>

    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="Telerik.Web.Examples.Movie"
        SelectMethod="GetMovieList"></asp:ObjectDataSource>
    <asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
        ProviderName="System.Data.SqlClient" SelectCommand="SELECT [CustomerID], [ContactName] FROM [Customers] ORDER By ContactName"></asp:SqlDataSource>
    <asp:XmlDataSource runat="server" ID="XmlDataSource1" DataFile="autocomplete.xml"></asp:XmlDataSource>

    </form>
</body>
</html>

Support & Learning Resources

Find Assistance