Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does dataset have a column?
Message
From
17/07/2014 20:36:58
John Baird
Coatesville, Pennsylvania, United States
 
 
To
17/07/2014 19:47:20
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01603979
Message ID:
01603981
Views:
53
>>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
>
>I think that you might want to look at the datatable, rather than the dataset.
>The datatable has a columns collection that contains the names of the columns in the table.
>You can search the collection or loop through it looking for the column you have in mind.

MyDataSet.MyDataTable.Columns("my column") != null

But hopefully, they're not typed data sets... LOL
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform