Dropdown menu+select+Delete+Asp.net+vb

<asp:DropDownList ID="ddlDelete" runat="server" DataSourceID="SqlDataSource2" DataTextField="id" DataValueField="id">

            

</asp:DropDownList>



<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  DataKeyNames="id"

        DataSourceID="SqlDataSource1">

    <Columns>

                                  

        <asp:CommandField ShowDeleteButton="True" />

                                  

        <asp:BoundField DataField="link" HeaderText="link" SortExpression="link" />

        <asp:BoundField DataField="img" HeaderText="img" SortExpression="img" />

    </Columns>

</asp:GridView>



    <asp:SqlDataSource ID="SqlDataSource1" runat="server"

        ConnectionString="<%$ ConnectionStrings:mytest1ConnectionString %>" 

        SelectCommand="SELECT [id], [link], [img] FROM [images]" 

        DeleteCommand="Delete FROM [images] WHERE id=@id" >

    

        <DeleteParameters> <asp:ControlParameter ControlID="ddlDelete" Name="id" PropertyName="SelectedValue" Type="Int32" />    

        </DeleteParameters>

    </asp:SqlDataSource>





    <asp:SqlDataSource ID="SqlDataSource2" runat="server"

        ConnectionString="<%$ ConnectionStrings:mytest1ConnectionString %>" 

        SelectCommand="SELECT [id] FROM [images]" >      

    </asp:SqlDataSource>

Thanks
Karthik
www.f5Debug.net

Thanks
Karthik
www.f5Debug.net