Row filter

[siaj]

Hi all,
I am having a dataset which is Reading from the XML file. The Dataset has a
table Users with Scheema (US_ID, US_Name). I am attempting to add new user to
this table. for this I want to fetch the max US_ID , increment by One and add
to table
The code is
maxID = dsUser.Tables(0).Select("US_ID=MAX(US_ID)")
The issue I am facing is that I am not getting proper maxID as US_ID is
interpreted as char while reading.
I also tried using the cast/convert expression but I m getting syntax error.

dsUser.Tables(0).Select("US_ID=(SELECT MAX (CONVERT(int,US_ID))
FROM Users)")
dsUser.Tables(0).Select("US_ID=(SELECT MAX (CAST(US_ID as int))
FROM Users)")
any suggestion will be highly appreciated...

Cheers,
siaj

[Cor Ligthert]

Siaj,

The datatable Select does not use a SQL select string however an expression.

(Which description is until now not on MSDN)

Here is a description I found hidden in another topic.

http://msdn.microsoft.com/library/de...ssiontopic.asp

I hope this helps

Cor