Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select espression
Message
From
12/09/2007 06:43:01
 
 
To
11/09/2007 12:45:11
John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
01253684
Message ID:
01253882
Views:
18
>>Hi,
>>Can the exp string in the following be constructed so as to return DataRows where a specific DataColumn is DBNull?
>
>
DataRows[] drs = DataTable.Select(exp);
>
>
>This is right off the top of my head, but maybe you could do something like this:
>
>
>    DataRow[] dr = DataTable.Select("'TT' = ISNULL( " + DataTable.Columns[4].ColumnName.ToString() + ", 'TT')");
>
Works great. (I was assuming I'd somehow have to test for DBNull)
Thx,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform