Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obtain Table Field List
Message
From
29/03/2007 14:11:32
John Baird
Coatesville, Pennsylvania, United States
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01209930
Message ID:
01209978
Views:
26
I don't think there is a direct equivalent. If you're using datasets:

dataset.datatable.Columns is the object array of all defined columns.

you can test a column exists: dataset.datatable[0].Columns.Contains("ColumnName")
you can get type: dataset.datatable[0].Columns["ColumnName"].DataType
you can get col position: dataset.datatable[0].Columns["ColumnName"].Ordinal

etc... so using the above, you could create your own sqlcolumns equivalent...



Is this what you wanted?




>Having a little problem here:
>
>What is the .NET equivalent to SQLColumns() in VFP?
>
>Alternatively, what is the SQLClient equivalent to ODBC's SQLColumns()?
>
>TIA
>Richard
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform