datarow syntax error

See more:

VB

HI,

I am getting exception as syntax error for the below statement.

Dim partNums As DataRow()
partNums =BoxTable.Select("ORDER_ID =" + odrRow.Item("ORDER_ID").ToString +"RowNum<=1")

Run-time exception thrown : System.Data.SyntaxErrorException - Syntax error: Missing operand after 'RowNum' operator.	

There are 12 rows in that boxtable, i am trying to retrive only 1 row by adding ROWNUM<=1, but it's giving above run time exception.
wat's the error in the above code

Thanks In Adance.
Subhash G.