Below is the DDL
<p>
<asp:Label ID="Label1" runat="server" AssociatedControlID="DDLCategory" Text="Category" CssClass="Label"></asp:Label>
<asp:DropDownList ID="DDLCategory" DataSourceID="SqlDataSourceCategory" runat="server"
CssClass="DropDownList" AppendDataBoundItems="true" AutoPostBack="true" OnSelectedIndexChanged="DDLCategory_SelectedIndexChanged"
DataTextField="vCategory" DataValueField="vCategoryID">
<asp:ListItem>--Select Category--</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSourceCategory" runat="server"
ConnectionString="<%$ ConnectionS ...
Go to the complete details ...