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.

ASPNET

<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.

C#

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;
}	

VB

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