Error "Missing operand after 'Bannon' operator" - what 'Bannon' operator is?

Question

Working on a C# console app, I have a line:

rowsFound = tempUsers.Select("EmailAddress = '" + userData[2].ToString() + "'");

rowsFound is a DataRow[], tempUsers is a DataTable, and userData is a SqlDataReader. I had the wrong index for userData (it was 1) and I got this error:

System.Data.SyntaxErrorException was unhandled
   Message=Syntax error: Missing operand after 'Bannon' operator.
   Source=System.Data
StackTrace:
   at System.Data.ExpressionParser.Parse()
   at System.Data.DataExpression..ctor(DataTable table, String expression, Type type)
   at System.Data.Select..ctor(DataTable table, String filterExpression, String sort, DataViewRowState recordStates)
   at System.Data.DataTable.Select(String filterExpression)

When I inserted the correct index (2), the error went away.

Any ideas on what a "Bannon operator" is?

Is `userdata[1]` the user's last name? Is his name "O'Bannon"? — David Yaw, Jul 14 '11 at 14:01
Ok, i'm an idiot. `userData[1]` is a name, `userData[2]` is an email address. corrected. — Greg Bair, Jul 14 '11 at 14:16

score 25 · Accepted Answer · edited May 23 '17 at 12:22

25

That guy was probably called O'Bannon (= userData[1]), resulting in the following string:

EmailAddress = 'O'Bannon'

The following Stackoverflow question contains a guide on how to properly escape data used in DataTable.Select:

Correct way to escape characters in a DataTable Filter Expression

With respect to single quotes, you just need to duplicate them: ' -> ''.

edited May 23 '17 at 12:22

Community

1
1

answered Jul 14 '11 at 14:00

Heinzi

167,459
57
363
519

@ J. Steen: IMHO, SLaks deserve this great comment :) – naveen Jul 14 '11 at 14:11

SLaks · Answer 2 · 2011-07-14T14:07:02.597

8

userData[1].ToString() was probably something like Bobby' Bannon

edited Jul 14 '11 at 14:07

answered Jul 14 '11 at 14:00

SLaks

868,454
176
1,908
1,964

Ah yes, the infamous Bobby Tables... (added for comic relief, on request ;) – J. Steen Jul 18 '11 at 07:46

score 1 · Answer 3 · answered Jul 14 '11 at 14:03

1

Please see this link. Bannon comes from the either UserData[2].ToString()

answered Jul 14 '11 at 14:03

Jethro

5,896
3
23
24

Error "Missing operand after 'Bannon' operator" - what 'Bannon' operator is?

3 Answers3