Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select espression
Message
De
12/09/2007 06:43:01
 
 
À
11/09/2007 12:45:11
John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
01253684
Message ID:
01253882
Vues:
19
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform