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">
</telerik:RadAutoCompleteBox>

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]",
        ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);

    DataTable data = new DataTable();
    adapter.Fill(data);

    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()
    adapter.Fill(data)

    Return data
End Function

See Also

• Overview