|
|
|
start date: Sat, 18 Aug 2007 17:23:21 +0200,
posted on: microsoft.public.dotnet.framework.adonet
back
| Thread Index |
|
1
sam
|
|
2
DaveP
|
Expression error
I use this for selecting rows that match a specific case:
DataRow[] foundRows =
dSet.Tables["MY_TABLE"].Select(IIF("column1="+DBNull.Value, "column2",
"column3"));
Compiling error, because IIF is not valid in this context ?
What is the correct syntax for using IIF in a select ?
Sam
Date:Sat, 18 Aug 2007 17:23:21 +0200
Author:
|
Re: Expression error
i haven't tried it yet....since this is a select
use a case column= ,column2 else columnxxx,end
try that
"sam" wrote in message
news:e0dy6ua4HHA.3940@TK2MSFTNGP05.phx.gbl...
>I use this for selecting rows that match a specific case:
> DataRow[] foundRows =
> dSet.Tables["MY_TABLE"].Select(IIF("column1="+DBNull.Value, "column2",
> "column3"));
> Compiling error, because IIF is not valid in this context ?
>
> What is the correct syntax for using IIF in a select ?
> Sam
>
Date:Sun, 19 Aug 2007 20:33:24 -0700
Author:
|
|
|
