Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does dataset have a column?
Message
From
17/07/2014 22:56:41
John Baird
Coatesville, Pennsylvania, United States
 
 
To
17/07/2014 20:42:13
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:
01603991
Views:
52
>>>>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
>Your solution is elegant.
>Please don't start him again, John!

I don't know where that answer came from, since I have no knowledge of programming despite 40 years of it.. lmao..
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform