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, "[email protected]" <[email protected]> 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, "[email protected]" > > > > <[email protected]> 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, > > Pradeep- Hide quoted text - > > - Show quoted text -
