SQL Data type validation

[jonhbt]

I need to create a method that accepts a string as a parameter and checks whether this parameter is a valid SQL Server datatype or not. Can someone help please? thanks

[himanshu2561]

Hi, Change the method parameter from String to SqlDbType.

himanshu

[PIEBALDconsult]

How about System.Enum.Parse ( typeof(System.Data.SqlDbType) , "datetime" , true ) ?

[jonhbt]

thanks it worked fine for my application

[PIEBALDconsult]

Glad to be of service.