Special characters in DataView.RowFilter

[k.pradee...@googlemail.com]

Hi all,

Suppose if I have the data like below.
SqlServer Table Emp:

EmpName Empno
--------------------------------------------------------
Kumar's p 123
bharat 124
pradeep'k kumar 125


I need to retrive only the 'kumar's p' related rows based on only
ename And needs to bind to the grid.
I am using dataview.rowfilter = "ename = 'kumar's p' . I am getting
the exception.

Please let me know how can I check this condition.

Thank you in advance.

Regards,
Pradeep

[k.pradee...@googlemail.com]

I am getting the following exception
----SynataxErrorException was unhandled by usercode
----Syntax error: Missing operand after 's' operator.


On Feb 24, 2:26 pm, "k.pradeep.kuma...@googlemail.com"

[The_Fruitman]

Look at the statement:

dataview.rowfilter = "ename = 'kumar's p'

Count the number of single quotes. What you're sending sending in the
program is reading as ename=kumar with extra information after kumar
that is causing the error. Try setting a variable to the value
kurmar's p and pass it in instead.



On Feb 24, 2:36 am, "k.pradeep.kuma...@googlemail.com"

> > Pradeep- Hide quoted text -
>
> - Show quoted text -

[Cerebrus]

Funny! Good catch, Fruitman ;-)

[Raghupathi Kamuni]

Good link for DataView.RowFilter expressions

http://aspdotnetcodebook.blogspot.com/2008/07/short-tutorial-on-dataview-rowfilter.html

[k.pradee...@googlemail.com]

Thank you very much to all....

I was handle that by considering it as two substrings....

Thank you very much

On Feb 25, 6:26 pm, Raghupathi Kamuni <raghukam...@gmail.com> wrote:
> Good link for DataView.RowFilter expressions
>

> http://aspdotnetcodebook.blogspot.com/2008/07/short-tutorial-on-datav...
>
> On Tue, Feb 24, 2009 at 3:06 PM, k.pradeep.kuma...@googlemail.com <

>
>
>
> k.pradeep.kuma...@googlemail.com> wrote:
>
> > I am getting the following exception
> > ----SynataxErrorException was unhandled by usercode
> > ----Syntax error: Missing operand after 's' operator.
>
> > On Feb 24, 2:26 pm, "k.pradeep.kuma...@googlemail.com"
> >  <k.pradeep.kuma...@googlemail.com> wrote:
> > > Hi all,
>
> > > Suppose if I have the data like below.
> > > SqlServer Table Emp:
>
> > >  EmpName                            Empno
> > > --------------------------------------------------------
> > >  Kumar's p                             123
> > >  bharat                                   124
> > >  pradeep'k kumar                    125
>
> > > I need to retrive only the 'kumar's p' related rows based on only
> > > ename And needs to bind to the grid.
> > > I am using dataview.rowfilter = "ename = 'kumar's p' . I am getting
> > > the exception.
>
> > > Please let me know how can I check this condition.
>
> > > Thank you in advance.
>
> > > Regards,