I have a DataTable with a column named "MyColumn (Something)". When I use the
following code to select the column with a value of "abc"

string filter = "MyColumn (Something)" + "=abc";
MyDataTable.Select(filter)

It shows an error:
"The expression contains undefined function call MyColumn().".

How do I let the Select() function know the "MyColumn (Something)" is the
title of the column, not a function?

Roy,

Is the columname MyColumn(Something)

or is it

MyColumn indexed by something.

This question is never made in the Select, therefore you stated that your
columname is MyColumn(Something)

Did you really made in your database a column with that name?

Cor

"Roy" <(E-Mail Removed)> wrote in message
news:6794C97B-F200-4CE9-9ED7-(E-Mail Removed)...
>I have a DataTable with a column named "MyColumn (Something)". When I use
>the
> following code to select the column with a value of "abc"
>
> string filter = "MyColumn (Something)" + "=abc";
> MyDataTable.Select(filter)
>
> It shows an error:
> "The expression contains undefined function call MyColumn().".
>
> How do I let the Select() function know the "MyColumn (Something)" is the
> title of the column, not a function?

> Did you really made in your database a column with that name?

I am curious as well :-)

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: blog.rthand.com

Try enclosing the colum name in square brackets "[MyColumn (Something)]"
that could work
"Roy" <(E-Mail Removed)> wrote in message
news:6794C97B-F200-4CE9-9ED7-(E-Mail Removed)...
>I have a DataTable with a column named "MyColumn (Something)". When I use
>the
> following code to select the column with a value of "abc"
>
> string filter = "MyColumn (Something)" + "=abc";
> MyDataTable.Select(filter)
>
> It shows an error:
> "The expression contains undefined function call MyColumn().".
>
> How do I let the Select() function know the "MyColumn (Something)" is the
> title of the column, not a function?