I have created a search function using a text box and button When I run it in a web form it shows nothingPlease HELP ltdivgt ltaspListView ID34ListView134 runat34server34 DataKeyNames34ProductID34 DataSourceID34SqlDataSource134 GroupItemCount34634gt ltAlternatingItemTemplategt lttd runat34server34 style3434gtProductID ltaspLabel ID34ProductIDLabe

Hi niubeeCheck this example Now please take its reference and correct your codeDatabaseFor this example I have used of Northwind database that you can download using the link given belowDownload Northwind DatabaseHTMLltaspDropDownList ID34DropDownList134 runat34server34 AppendDataBoundItems34true34 DataSourceID34SqlDataSource234 DataTextField34Country34 DataValueField34Country34gt ltaspListItem Text34Please select34 Value3434 gt ltaspDropDownListgt ltaspSqlDataSource ID34SqlDataSource234 runat34server34 ConnectionString34lt ConnectionStringsConnectionString gt34 SelectCommand34SELECT DISTINCT Country FROM Customers34gtltaspSqlDataSourcegt ltaspTextBox ID34TextBox134 runat34server34gtltaspTextBoxgt ltaspButton ID34btnSearch34 runat34server34 Text34Search34 OnClick34btnSearchClick3

Filter ListView on Button Click using SqlDataSource in ASP.Net

niubee

SOLVED CLOSED ACTIVE ANSWERED
User: niubee
Posted: on Jul 27, 2020 01:30 PM
Forum: ASP.Net Web Forms
Answer: 1
Views: 3615
Sample Code: Download

I have created a search function using a text box and button. When I run it in a web form it shows nothing.

Please HELP.

        <div>
            <asp:ListView ID="ListView1" runat="server" DataKeyNames="ProductID" DataSourceID="SqlDataSource1" GroupItemCount="6">
                <AlternatingItemTemplate>
                    <td runat="server" style="">ProductID:
                        <asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
                        <br />ProductName:
                        <asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>' />
                        <br />Artist:
                        <asp:Label ID="ArtistLabel" runat="server" Text='<%# Eval("Artist") %>' />
                        <br />ProductPrice:
                        <asp:Label ID="ProductPriceLabel" runat="server" Text='<%# Eval("ProductPrice") %>' />
                        <br />
                        <img src='<%# Eval("Image") %>' height="200" width="300" />
                        <br />ArtistID:
                        <asp:Label ID="ArtistIDLabel" runat="server" Text='<%# Eval("ArtistID") %>' />
                        <br />Category:
                        <asp:Label ID="CategoryLabel" runat="server" Text='<%# Eval("Category") %>' />
                        <br />Description:
                        <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>' />
                        <br /></td>
                </AlternatingItemTemplate>
                <EditItemTemplate>
                    <td runat="server" style="">ProductID:
                        <asp:Label ID="ProductIDLabel1" runat="server" Text='<%# Eval("ProductID") %>' />
                        <br />ProductName:
                        <asp:TextBox ID="ProductNameTextBox" runat="server" Text='<%# Bind("ProductName") %>' />
                        <br />Artist:
                        <asp:TextBox ID="ArtistTextBox" runat="server" Text='<%# Bind("Artist") %>' />
                        <br />ProductPrice:
                        <asp:TextBox ID="ProductPriceTextBox" runat="server" Text='<%# Bind("ProductPrice") %>' />
                        <br />Image:
                        <asp:TextBox ID="ImageTextBox" runat="server" Text='<%# Bind("Image") %>' />
                        <br />ArtistID:
                        <asp:TextBox ID="ArtistIDTextBox" runat="server" Text='<%# Bind("ArtistID") %>' />
                        <br />Category:
                        <asp:TextBox ID="CategoryTextBox" runat="server" Text='<%# Bind("Category") %>' />
                        <br />Description:
                        <asp:TextBox ID="DescriptionTextBox" runat="server" Text='<%# Bind("Description") %>' />
                        <br />
                        <asp:Button ID="UpdateButton" runat="server" CommandName="Update" Text="Update" />
                        <br />
                        <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Cancel" />
                        <br /></td>
                </EditItemTemplate>
                <EmptyDataTemplate>
                    <table runat="server" style="">
                        <tr>
                            <td>No data was returned.</td>
                        </tr>
                    </table>
                </EmptyDataTemplate>
                <EmptyItemTemplate>
                    <td runat="server" />
                </EmptyItemTemplate>
                <GroupTemplate>
                    <tr id="itemPlaceholderContainer" runat="server">
                        <td id="itemPlaceholder" runat="server"></td>
                    </tr>
                </GroupTemplate>
                <InsertItemTemplate>
                    <td runat="server" style="">ProductID:
                        <asp:TextBox ID="ProductIDTextBox" runat="server" Text='<%# Bind("ProductID") %>' />
                        <br />ProductName:
                        <asp:TextBox ID="ProductNameTextBox" runat="server" Text='<%# Bind("ProductName") %>' />
                        <br />Artist:
                        <asp:TextBox ID="ArtistTextBox" runat="server" Text='<%# Bind("Artist") %>' />
                        <br />ProductPrice:
                        <asp:TextBox ID="ProductPriceTextBox" runat="server" Text='<%# Bind("ProductPrice") %>' />
                        <br />Image:
                        <asp:TextBox ID="ImageTextBox" runat="server" Text='<%# Bind("Image") %>' />
                        <br />ArtistID:
                        <asp:TextBox ID="ArtistIDTextBox" runat="server" Text='<%# Bind("ArtistID") %>' />
                        <br />Category:
                        <asp:TextBox ID="CategoryTextBox" runat="server" Text='<%# Bind("Category") %>' />
                        <br />Description:
                        <asp:TextBox ID="DescriptionTextBox" runat="server" Text='<%# Bind("Description") %>' />
                        <br />
                        <asp:Button ID="InsertButton" runat="server" CommandName="Insert" Text="Insert" />
                        <br />
                        <asp:Button ID="CancelButton" runat="server" CommandName="Cancel" Text="Clear" />
                        <br /></td>
                </InsertItemTemplate>
                <ItemTemplate>
                    <td runat="server" style="">ProductID:
                        <asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
                        <br />ProductName:
                        <asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>' />
                        <br />Artist:
                        <asp:Label ID="ArtistLabel" runat="server" Text='<%# Eval("Artist") %>' />
                        <br />ProductPrice:
                        <asp:Label ID="ProductPriceLabel" runat="server" Text='<%# Eval("ProductPrice") %>' />
                        <br />
                        <img src='<%# Eval("Image") %>' height="200" width="300" />
                        <br />ArtistID:
                        <asp:Label ID="ArtistIDLabel" runat="server" Text='<%# Eval("ArtistID") %>' />
                        <br />Category:
                        <asp:Label ID="CategoryLabel" runat="server" Text='<%# Eval("Category") %>' />
                        <br />Description:
                        <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>' />
                        <br /></td>
                </ItemTemplate>
                <LayoutTemplate>
                    <table runat="server">
                        <tr runat="server">
                            <td runat="server">
                                <table id="groupPlaceholderContainer" runat="server" border="0" style="">
                                    <tr id="groupPlaceholder" runat="server">
                                    </tr>
                                </table>
                            </td>
                        </tr>
                        <tr runat="server">
                            <td runat="server" style="">
                                <asp:DataPager ID="DataPager1" runat="server" PageSize="12">
                                    <Fields>
                                        <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
                                        <asp:NumericPagerField />
                                        <asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
                                    </Fields>
                                </asp:DataPager>
                            </td>
                        </tr>
                    </table>
                </LayoutTemplate>
                <SelectedItemTemplate>
                    <td runat="server" style="">ProductID:
                        <asp:Label ID="ProductIDLabel" runat="server" Text='<%# Eval("ProductID") %>' />
                        <br />ProductName:
                        <asp:Label ID="ProductNameLabel" runat="server" Text='<%# Eval("ProductName") %>' />
                        <br />Artist:
                        <asp:Label ID="ArtistLabel" runat="server" Text='<%# Eval("Artist") %>' />
                        <br />ProductPrice:
                        <asp:Label ID="ProductPriceLabel" runat="server" Text='<%# Eval("ProductPrice") %>' />
                        <br />Image:
                        <asp:Label ID="ImageLabel" runat="server" Text='<%# Eval("Image") %>' />
                        <br />ArtistID:
                        <asp:Label ID="ArtistIDLabel" runat="server" Text='<%# Eval("ArtistID") %>' />
                        <br />Category:
                        <asp:Label ID="CategoryLabel" runat="server" Text='<%# Eval("Category") %>' />
                        <br />Description:
                        <asp:Label ID="DescriptionLabel" runat="server" Text='<%# Eval("Description") %>' />
                        <br /></td>
                </SelectedItemTemplate>
            </asp:ListView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [ProductList] WHERE ([ProductName] LIKE '%' + @ProductName + '%')">
                <SelectParameters>
                    <asp:ControlParameter ControlID="TextBox1" Name="ProductName" PropertyName="Text" Type="String" />
                </SelectParameters>
            </asp:SqlDataSource>
            <br />
            <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="Category" DataValueField="Category">
            </asp:DropDownList>
            <asp:Button ID="btnFind" runat="server" Text="Find" OnClick="btnFind_Click" />
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <asp:Button ID="btnSearch" runat="server" OnClick="btnSearch_Click" Text="Search" />
            <br />
            <br />
            Result:<asp:Label ID="lblResult" runat="server"></asp:Label>
            <br />
        </div>

dharmend...

0 4

Reply
ANSWER
User: dharmendr
Replied: on Jul 28, 2020 06:52 AM
Report

Hi niubee,

Check this example. Now please take its reference and correct your code.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

HTML

<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="true" DataSourceID="SqlDataSource2" DataTextField="Country" DataValueField="Country">
        <asp:ListItem Text="Please select" Value="" />
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT DISTINCT [Country] FROM [Customers]"></asp:SqlDataSource>
    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:Button ID="btnSearch" runat="server" Text="Search" OnClick="btnSearch_Click" />
    <asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1">
        <AlternatingItemTemplate>
            <td runat="server" style="">CustomerID:
                    <asp:Label runat="server" Text='<%# Eval("CustomerID") %>' />
                <br />
                ContactName:
                    <asp:Label runat="server" Text='<%# Eval("ContactName") %>' />
                <br />
                City:
                    <asp:Label runat="server" Text='<%# Eval("City") %>' />
                <br />
                Country:
                    <asp:Label runat="server" Text='<%# Eval("Country") %>' />
                <hr />
            </td>
        </AlternatingItemTemplate>
        <EditItemTemplate>
            <td runat="server" style="">CustomerID:
                    <asp:Label runat="server" Text='<%# Eval("CustomerID") %>' />
                <br />
                ContactName:
                    <asp:TextBox runat="server" Text='<%# Eval("ContactName") %>' />
                <br />
                City:
                    <asp:TextBox runat="server" Text='<%# Eval("City") %>' />
                <br />
                Country:
                    <asp:TextBox runat="server" Text='<%# Eval("Country") %>' />
                <hr />
            </td>
        </EditItemTemplate>
        <EmptyDataTemplate>
            <table runat="server" style="">
                <tr>
                    <td>No data was returned.</td>
                </tr>
            </table>
        </EmptyDataTemplate>
        <EmptyItemTemplate>
            <td runat="server" />
        </EmptyItemTemplate>
        <GroupTemplate>
            <tr id="itemPlaceholderContainer" runat="server">
                <td id="itemPlaceholder" runat="server"></td>
            </tr>
        </GroupTemplate>
        <InsertItemTemplate>
            <td runat="server" style="">CustomerID:
                    <asp:Label runat="server" Text='<%# Eval("CustomerID") %>' />
                <br />
                ContactName:
                    <asp:TextBox runat="server" Text='<%# Eval("ContactName") %>' />
                <br />
                City:
                    <asp:TextBox runat="server" Text='<%# Eval("City") %>' />
                <br />
                Country:
                    <asp:TextBox runat="server" Text='<%# Eval("Country") %>' />
                <hr />
            </td>
        </InsertItemTemplate>
        <ItemTemplate>
            <td runat="server" style="">CustomerID:
                    <asp:Label runat="server" Text='<%# Eval("CustomerID") %>' />
                <br />
                ContactName:
                    <asp:Label runat="server" Text='<%# Eval("ContactName") %>' />
                <br />
                City:
                    <asp:Label runat="server" Text='<%# Eval("City") %>' />
                <br />
                Country:
                    <asp:Label runat="server" Text='<%# Eval("Country") %>' />
                <hr />
            </td>
        </ItemTemplate>
        <LayoutTemplate>
            <table runat="server">
                <tr runat="server">
                    <td runat="server">
                        <table id="groupPlaceholderContainer" runat="server" border="0" style="">
                            <tr id="groupPlaceholder" runat="server">
                            </tr>
                        </table>
                    </td>
                </tr>
                <tr runat="server">
                    <td runat="server" style="">
                        <asp:DataPager ID="DataPager1" runat="server" PageSize="12">
                            <Fields>
                                <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
                                <asp:NumericPagerField />
                                <asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" />
                            </Fields>
                        </asp:DataPager>
                    </td>
                </tr>
            </table>
        </LayoutTemplate>
        <SelectedItemTemplate>
            <td runat="server" style="">CustomerID:
                    <asp:Label runat="server" Text='<%# Eval("CustomerID") %>' />
                <br />
                ContactName:
                    <asp:Label runat="server" Text='<%# Eval("ContactName") %>' />
                <br />
                City:
                    <asp:Label runat="server" Text='<%# Eval("City") %>' />
                <br />
                Country:
                    <asp:Label runat="server" Text='<%# Eval("Country") %>' />
                <hr />
            </td>
        </SelectedItemTemplate>
    </asp:ListView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        SelectCommand="SELECT [CustomerID], [ContactName], [City], [Country] FROM [Customers] WHERE ([ContactName] LIKE '%' + @ContactName + '%') AND (Country = @Country OR ISNULL(@Country,'') = '')">
        <SelectParameters>
            <asp:ControlParameter ControlID="TextBox1" Name="ContactName" PropertyName="Text" Type="String" ConvertEmptyStringToNull="false" />
            <asp:ControlParameter ControlID="DropDownList1" Name="Country" PropertyName="SelectedValue" Type="String" ConvertEmptyStringToNull="false" />
        </SelectParameters>
    </asp:SqlDataSource>

Screenshot

Filter ListView on Button Click using SqlDataSource in ASP.Net

Company

Explore

Follow us

Contact Us