>Hi everybody, > >I made a few searches in StackOverflow but I haven't found a good clean solution yet. > >The problem - I need to know the SqlDbType of the column (not its .NET type). > >We have our own code which I don't like and which returns incorrect results (it returns NVarchar type (when checking String type)) but we only have Varchar type in our database. > >So, I am wondering if you have a clean bullet proof code that returns SqlDbType when you pass column name (as a String) and a table name (as a String) (in our case we don't need to pass schema as we use dbo only). > >Thanks a lot in advance. > >---------------- >The solution I looked at StackOverlow is > >http://stackoverflow.com/questions/7470258/how-to-get-the-sqltype-of-a-column-in-a-datatable (and the link from it)
Wow, a bit more googling seems to bring the answer!