help..how to show data in dataList view on the basis of dropdown-list items

See more:

ASP.NET

SqlDataSource

C#5.0

, +

hello,

i want to show my data in data list view on the basis of selected item from drop down menu..

i have bonded the data with my data list view its showing all the data columns except the image ..

how should i display my image data from db as well .. on the basis of selected item from drop down it should respond but its not showing any response..

i didnt use any code behind this all.. i have it by the help of wizard to generate queries and bind specific data with my db, and show data to its respective controls..

if someone has done related work .. please comment out

thanks..

this is my code so far::

<span class="auto-style2">I wanna see: </span> <asp:DropDownList ID="DropDownList1" runat="server" Height="44px" Width="214px" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" CssClass="auto-style3" DataTextField="Brand" DataValueField="Brand">
            <asp:ListItem Selected="True">clothes
            <asp:ListItem>jewelry
            <asp:ListItem>shoes
        
        <asp:DataList ID="DataList1" runat="server" RepeatColumns="3" RepeatDirection="Horizontal"
   Width="99%" BorderColor="Blue" BorderStyle="Solid" BorderWidth="3px" DataSourceID="SqlDataSource1" Height="456px">
            <itemtemplate>
                Brand:
                <asp:Label ID="BrandLabel" runat="server" Text='<%# Eval("Brand") %>'>
                <br /><br />
                Image:<br />
                <br />
 <asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("Image") %>' /><br /><br />
                Price:
                <asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price") %>' />
                <br /><br />
                Description:
                <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>' />               
                <br /><br />
            </itemtemplate>
            <itemstyle horizontalalign="Center" verticalalign="Top" />        
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:loginString %>" SelectCommand="SELECT [Brand], [Price], [Image], [Description] FROM [w_product] WHERE ([Category] = @Category)">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" DefaultValue="clothes" Name="Category" PropertyName="SelectedValue" Type="String" />
            </SelectParameters>