27 January 2009

Filtering from dataset

public void LoadItems()
{
dsItems = InventoryManager.ListItems();
if (dsItems.Tables[0].Rows.Count.Equals(0))
{
DataRow drNew = dsItems.Tables[0].NewRow();
dsItems.Tables[0].Rows.Add(drNew);
GridView1.DataSource=dsItems;
GridView1.DataBind();
grvItem.Rows[0].Visible = false;
}
else
{
DataView dv;
if (ViewState["sortExpr"] != null)
{
dv = new DataView(dsItems.Tables[0]);
dv.Sort = (string)ViewState["sortExpr"];

}
else
{
dv = new DataView(dsItems.Tables[0]);
}
dv.RowFilter = "Name like '%" + txtSearch.Text + "%'";
GridView1.DataSource=dv;
GridView1.DataBind();
}
}

No comments: