or
Select Category from CategoriesPublic Shared Function GetDescription() As DataTable Dim comm As DbCommand = GenericDataAccess.CreateCommand() comm.CommandText = "GetDescriptions" Return GenericDataAccess.ExecuteSelectCommand(comm) End FunctionProtected Sub txtSearch_DataBinding(sender As Object, e As EventArgs) Handles txtSearch.DataBinding txtSearch.DataSource = GetMethods.GetDescription() End SubProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then txtSearch.DataBind() End If End Sub<telerik:RadAutoCompleteBox ID="txtSearch" DataTextField="Category" DataValueField="Category" runat="server" EmptyMessage="Please enter search term"></telerik:RadAutoCompleteBox>



Hi,
<
asp:SqlDataSource ID="getGroundGears" runat="server"
ConnectionString="<%$ ConnectionStrings:FisheriesConnectionString %>"
SelectCommand="SELECT [Name] AS GroundGearName, [Code] AS GroundGearCode FROM [vwDisGroundGearAll] ORDER BY [DisplayOrder]">
</asp:SqlDataSource>
Though I would like the datasource for the dropdown to point to the method DisGroundGearAllTableAdapter.GetDisGroundGearAll.
How can I get the datasource to point to my tableadapters?
Thanks, Ida