I'm doing a small system for registering product items.
As I came from Delphi I was looking for a way to load the products by code or by name in a Dropdownlist.
I've been searching and seen a system that was using a component like I wanted, where the user searches the code or by name and loads the information in Dropdownlist.
Could anyone give me tips on how to do this?
You can pass the parameter to your query that populate DropDrownlist:
<asp:SqlDataSource id="Prod" runat="server"
ConnectionString="<%$ ConnectionStrings:myBase %>"
SelectCommand="SELECT ColunaID, ColunaText FROM Tabela
WHERE ParametroFiltro= @ParametroFiltro">
<SelectParameters>
<asp:QueryStringParameter Name="ID" QueryStringField="ParametroFiltro" />
</SelectParameters>
</asp:SqlDataSource>