DataTable.Select - System.Data.SyntaxErrorException

[avnrao]

Hi there,

I am getting an error when i try this code.

DataRow[] childRows = dsQueryPlan.Tables[0].Select("Parent = 1");



the error is :



System.Data.SyntaxErrorException

Syntax error in Lookup expression: Expecting keyword 'Parent' followed by a
single column argument with possible relation qualifier:
Parent[(<relation_name>)].<column_name>."


dsQueryPlan is the dataset. I have a table which has column Parent in it.
If i try with any other column, it works. It doesnt work with this column
alone.

any ideas??
ty.

 

[Jon Skeet [C# MVP]]

I am getting an error when i try this code.

DataRow[] childRows = dsQueryPlan.Tables[0].Select("Parent = 1");

the error is :

System.Data.SyntaxErrorException

Syntax error in Lookup expression: Expecting keyword 'Parent' followed by a
single column argument with possible relation qualifier:
Parent[(<relation_name>)].<column_name>."

dsQueryPlan is the dataset. I have a table which has column Parent in it.
If i try with any other column, it works. It doesnt work with this column
alone.

(In future, ADO.NET questions are better asked in the
microsoft.public.dotnet.framework.adonet newsgroup, btw.)

Parent is a reserved word, because it's used for relationships.

I suggest you try [Parent] instead.

 

[anestis]

Years afterward but....
use "[parent]" instead of "parent

From http://www.developmentnow.com/g/36_...e-Select--System-Data-SyntaxErrorException.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com