我想在listview上的textchange事件上过滤数据,所以我使用dataview来过滤数据。下面的代码中的问题是,我在每个内部使用dataview,以便它仅检查一个条件,该条件仅是最后一个值,我想用dataview检查 s1 中的值,而剩余值应与listview绑定(bind)。
例如:如果我在文本框中输入和,则它应列出所有项目值,以anandha kumar,anna ect之类的值开头。假设我将值anandha kumar和anna保留在数组s1中。我应该列出所有其他值,期望数组值像antony ect ...在listview中。
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
dvProducts = (DataView)Session["ListViewItems"];
string serachText = EscapeLikeValue(TextBox1.Text);
string lvValues = hdRetailCustomerGroup.Value;
string trim = lvValues.Replace(" ", "");
trim = trim.Replace("\r", "");
trim = trim.Replace("\n", "");
trim = trim.Replace("\t", "");
string str = trim;
string[] list = str.Split('|');
foreach (string s1 in list)
{
if (s1 != string.Empty)
{
dvProducts.RowFilter = "(CODE like '" + serachText + "*') AND (CODE <> '" + s1 + "')";
Session["ListViewItems"] = dvProducts;
}
}
ListView1.DataSource = dvProducts;
ListView1.DataBind();
}
最佳答案
DataView view = new DataView();
view.Table = DataSet1.Tables["Suppliers"];
view.RowFilter = "City = 'Berlin'";
view.RowStateFilter = DataViewRowState.ModifiedCurrent;
view.Sort = "CompanyName DESC";
// Simple-bind to a TextBox control
Text1.DataBindings.Add("Text", view, "CompanyName");
引用:
http://www.csharp-examples.net/dataview-rowfilter/
http://msdn.microsoft.com/en-us/library/system.data.dataview.rowfilter.aspx