>BTW, I remember I was trying to answer the same question.
>
>Take a look at this answer at StackOverflow, I think I also used it in our code.
>
>http://stackoverflow.com/questions/459572/how-do-i-get-the-sqldbtype-of-a-column-in-a-table-using-ado-net

I took a look at the page. I like the SMO approach at the end. However, this requires the library to be available. In my case, presently, they are always, but we never know.