Does anybody know how I can get the underlying database type information from data I have currently in a DataSet? I can get the DataType from the Column, but that's a .Net DataType. How do I get info about hte underlying SQL datatype (even if it does require a trip back to the database)?
I know I can get the type info directly out of SQL Server and then manually map the types, but there's gotta be another way to do this since ADO.Net is doing something to get the schema information for use in the DataAdapter. Looking at the SQL it sends (via Profiler) I'm none the wiser - it appears to pull back an empty row.
Any ideas?