>tradotto in DATASET una cosa simile
>
>nome campo | tipo
>data_1 | datetime
>nome azienda | varchar
>spesa | decimal
Ciao Andrea,
Per leggere i metadati, SQL Server 2000 offre le INFORMATION_SCHEMA views.
Nel tuo caso puoi usare la INFORMATION_SCHEMA view COLUMNS:
USE Northwind;
GO
SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = N'dbo'
AND TABLE_NAME = N'Customers';
GO
/* Output:
COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH
-------------- ----------- ------------------------
CustomerID nchar 5
CompanyName nvarchar 40
ContactName nvarchar 30
ContactTitle nvarchar 30
Address nvarchar 60
City nvarchar 15
Region nvarchar 15
PostalCode nvarchar 10
Country nvarchar 15
Phone nvarchar 24
Fax nvarchar 24
(11 row(s) affected)
*/
Per ulteriori informazioni leggi i seguenti paragrafi sui Books Online:
"Information Schema Views"
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ia-iz_4pbn.asp
"COLUMNS"
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ia-iz_87w3.asp
>GRAZIE 1000 E SCUSATE
Prego.
Ciao!
--
Lorenzo Benaglia
Microsoft MVP - SQL Server
http://blogs.dotnethell.it/lorenzo/
http://italy.mvps.org