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

Binding to DataTable, DataSet, or DataView

RadAutoCompleteBox can be bound to a DataTable, DataSet, and DataView. The following example shows binding to a DataTable object.

Binding to a DataTable at runtime

The declaration of RadAutoCompleteBox in the markup includes no DataSourceID property or Items section.

<telerik:RadAutoCompleteBox RenderMode="Lightweight" ID="RadAutoCompleteBox1" InputType="Text" runat="server">

In the Page_Load event handler, create and fill the DataTable object, then bind it to RadAutoCompleteBox. The DataBind method must be called after setting the DataSource property.

protected void Page_Load(object sender, EventArgs e)
    if (Page.IsCallback)
        RadAutoCompleteBox1.DataSource = GetData();
        RadAutoCompleteBox1.DataTextField = "ProductName";
        RadAutoCompleteBox1.DataValueField = "ProductID";

private static DataTable GetData()
    SqlDataAdapter adapter = new SqlDataAdapter(@"SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], 
        [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued] FROM [Products]",

    DataTable data = new DataTable();

    return data;
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    If Page.IsCallback Then
        RadAutoCompleteBox1.DataSource = GetData()
        RadAutoCompleteBox1.DataTextField = "ProductName"
        RadAutoCompleteBox1.DataValueField = "ProductID"
    End If
End Sub

Private Shared Function GetData() As DataTable
    Dim adapter As New SqlDataAdapter("SELECT * FROM [Products]", ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString)

    Dim data As New DataTable()

    Return data
End Function

See Also

In this article