Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Does dataset have a column?
Message
De
17/07/2014 20:44:36
 
 
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01603979
Message ID:
01603983
Vues:
36
J'aime (1)
>Hi,
>
>What is the fastest (or an efficient) method to find out if a dataset (not strongly typed) has a column; by name. For example; I have a dataset MyDataSet (created by loading an XML file) and I want to find out if the dataset has column MyColumn.
>
>TIA

You can try Table.Columns.Contains(columnnameToTest), which returns a Boolean.

Here's an example....the first one returns true, the second one false
DataTable dt = new DataTable();
dt.Columns.Add("Column1", typeof(System.String));

MessageBox.Show( dt.Columns.Contains("Column1").ToString());
MessageBox.Show(dt.Columns.Contains("Column2").ToString());  
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform