Dataview.Rowfilter help

hey guys

I am tring to implement a filter in a datagrid. I am using a datatable
which is the datasource for the grid.
I need to filter set of rows. i.e. from row 1 to row count. i need to
keep my row 0 intact, which is an option to add a new person.

textbox key up code looks like this:

string strRowFilter = String.Concat("Name LIKE '%", txtName.Text,
"%'");
dv.RowFilter = strRowFilter;
grdNames.DataSource = dv;

plz help

sunny

Kevin
Tue Oct 17 18:57:39 CDT 2006

It's a bit hard to find the documentation for this, but here it is:

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx

Scroll down a bit.

--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Shooter
http://unclechutney.blogspot.com

A man, a plan, a canal, a palindrome that has.. oh, never mind.

<s26f84@gmail.com> wrote in message
news:1161111157.014719.291820@e3g2000cwe.googlegroups.com...
> hey guys
>
> I am tring to implement a filter in a datagrid. I am using a datatable
> which is the datasource for the grid.
> I need to filter set of rows. i.e. from row 1 to row count. i need to
> keep my row 0 intact, which is an option to add a new person.
>
> textbox key up code looks like this:
>
> string strRowFilter = String.Concat("Name LIKE '%", txtName.Text,
> "%'");
> dv.RowFilter = strRowFilter;
> grdNames.DataSource = dv;
>
> plz help
>
> sunny
>

s26f84
Tue Oct 17 19:53:41 CDT 2006


hey Kevin
thanks for the reply... but still not able to geeet how to do there is
stuff but nothing about how to make a fixed or always visible row in
dataview... The expression one helps in calculations and stuff... thts
kool, might help me in future but my problem still exists...

a fixed row in a filtered dataview.. :(


Kevin Spencer wrote:
> It's a bit hard to find the documentation for this, but here it is:
>
> http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx
>
> Scroll down a bit.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> Chicken Salad Shooter
> http://unclechutney.blogspot.com
>
> A man, a plan, a canal, a palindrome that has.. oh, never mind.
>
> <s26f84@gmail.com> wrote in message
> news:1161111157.014719.291820@e3g2000cwe.googlegroups.com...
> > hey guys
> >
> > I am tring to implement a filter in a datagrid. I am using a datatable
> > which is the datasource for the grid.
> > I need to filter set of rows. i.e. from row 1 to row count. i need to
> > keep my row 0 intact, which is an option to add a new person.
> >
> > textbox key up code looks like this:
> >
> > string strRowFilter = String.Concat("Name LIKE '%", txtName.Text,
> > "%'");
> > dv.RowFilter = strRowFilter;
> > grdNames.DataSource = dv;
> >
> > plz help
> >
> > sunny
> >