'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 |
|---|
