Why DataTable.Select("IIF(...)") is refused !

#1

Why using an IIF in a DataTable.Select(IIF("column1=zz",
"column2","column3")); is in invalid context ?
What is the way for using an IIF in a Datatable.Select(...) ?

Thanks for help.

sam

#2

Try placing the IIF inside a CStr() function, because IIF returns an Object,
you usually need to convert it. Good Luck!
--
Nathan Sokalski
njsokalski (AT) hotmail (DOT) com
http://www.nathansokalski.com/

"sam" <none (AT) none (DOT) fr> wrote

Quote:

Why using an IIF in a DataTable.Select(IIF("column1=zz",
"column2","column3")); is in invalid context ?
What is the way for using an IIF in a Datatable.Select(...) ?

Thanks for help.

sam

#3

"Nathan Sokalski" <njsokalski (AT) hotmail (DOT) com> a écrit dans le message de news:
O4dKtzd4HHA.5984 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

Quote:

Try placing the IIF inside a CStr() function, because IIF returns an
Object, you usually need to convert it. Good Luck!
I have drop the IIF in a Convert.ToString() but the compiler says:

DataTable.Select(Convert.ToString(IIF("name_real=" +null,"name_to_use",
"")));
"The name 'identifier' does not exist in the current context "
Someone knows how using IIF in a DaTaTable.Select() ?

Sam

"Nathan Sokalski" <njsokalski (AT) hotmail (DOT) com> a écrit dans le message de news:
O4dKtzd4HHA.5984 (AT) TK2MSFTNGP04 (DOT) phx.gbl...

Quote:

Try placing the IIF inside a CStr() function, because IIF returns an
Object, you usually need to convert it. Good Luck!
--
Nathan Sokalski
njsokalski (AT) hotmail (DOT) com
http://www.nathansokalski.com/

"sam" <none (AT) none (DOT) fr> wrote in message
news:%23tV%2315c4HHA.2108 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Why using an IIF in a DataTable.Select(IIF("column1=zz",
"column2","column3")); is in invalid context ?
What is the way for using an IIF in a Datatable.Select(...) ?

Thanks for help.

sam

#4

DataTable uses a regular expression to parse your filter. It is likely that
they don't support some SQL functions.
Use a query to populate the data table with filtered results.

--
Sheng Jiang
Microsoft MVP in VC++
"sam" <none (AT) none (DOT) fr> wrote

Quote:

Why using an IIF in a DataTable.Select(IIF("column1=zz",
"column2","column3")); is in invalid context ?
What is the way for using an IIF in a Datatable.Select(...) ?

Thanks for help.

sam

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Why DataTable.Select("IIF(...)") is refused !

Dotnet Framework (ADO.net) microsoft.public.dotnet.framework.adonet

Why DataTable.Select("IIF(...)") is refused ! - 08-18-2007 , 03:31 PM

Re: Why DataTable.Select("IIF(...)") is refused ! - 08-18-2007 , 05:15 PM

Re: Why DataTable.Select("IIF(...)") is refused ! - 08-19-2007 , 02:20 AM

Re: Why DataTable.Select("IIF(...)") is refused ! - 08-20-2007 , 01:55 PM