'How to filter listview data to a textbox search [duplicate]

I want to filter my listview data to a search. I bind the data from my database to the listview but now I don't know how to filter that data.

this is my listview code:

<ListView Margin="5"
          Background="Transparent"
          BorderBrush="Transparent"
          x:Name="dishitems"
          ItemsSource="{Binding listdata}">

            <ListView.View>
                <GridView>
                    <GridViewColumn DisplayMemberBinding="{Binding Path=DishName}" Header="Name" Width="100"/>
                    <GridViewColumn DisplayMemberBinding="{Binding Path=Portion}" Header="Portion" Width="100"/>
                    <GridViewColumn DisplayMemberBinding="{Binding Path=UnitPrice}" Header="Price" Width="100"/>
                    <GridViewColumn DisplayMemberBinding="{Binding Path=Status}" Header="Status" Width="100"/>
                </GridView>
            </ListView.View>

        </ListView>

and this is my viewmodel class:

public class CashierViewModel
{
    public string ConnectionString = "Data Source=localhost;Initial Catalog=Route450;Integrated Security=True";
    private string querySearch = "SELECT DishName, Portion, UnitPrice, Status FROM Dishes";
    private string filtertext;

    public void setID(string ID)
    {
        this.filtertext = ID;
    }
    public string getID()
    {
        return filtertext;
    }

    public DataView listdata
    {
        get
        {
            DataTable dt = new DataTable();
            SqlConnection connection = new SqlConnection(ConnectionString);
            connection.Open();
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(querySearch, connection);
            adapter.Fill(dt);
            connection.Close();
            return dt.DefaultView;
        }
    }
}

Thank you!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source