A usercontrol is defined thus:
<%@ Control Language="vb" AutoEventWireup="false" CodeBehind="FundtypeDDL.ascx.vb" Inherits="netNewTIP.FundtypeDDL" %>
<asp:DropDownList ID="Fundtype_DDL"
runat="server"
Width="80px"
AppendDataBoundItems="True"
DataSourceID="Fundtype_DataSource"
DataTextField="FundType"
DataValueField="FundType" >
<asp:ListItem Text="----" Value="X" Selected="True" />
</asp:DropDownList>
<asp:SqlDataSource ID="Fundtype_DataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:TipConnectionString %>"
SelectCommand="SELECT [FundType] FROM [LookupFundTypes] ORDER BY [FundType]">
</asp:SqlDataSource>
It is used in a Gridview like this:
...
Go to the complete details ...