The oleDBdatareader provides a GetSchemaTable() method that returns a
dataTable.
Consider the following statement for a datatable called dTable constucted
through GetSchemaTable():
dTable.Rows(0).Item(dTable.Columns("ProviderType")).ToString()
This statement would return a value of "202" if the first column was
datatype nvarchar in the sql server database.
How can I, using a dataset instead of a datareader, return this ProviderType
value (202) for a nvarchar SQL server column?
I don't want to have to resort to some mapping solution, e.g.,
"string"=>202.
Thanks in advance.
|