how to get the sqlDbtype ???

[N3XuS]

I'm writing a function to get the members out of an object and using them as parameter for a stored procedure. The problem being I don't know how to get the sqlDbType from the object... is there any way to do this ??

Many thx

 

[N3XuS]

way better even ... can I just get the types out of the storedProcedures ?

 

[dvannoy]

do you not have access to the server itself? or did you not create the SP?

you can write a select statment to select from the information_schema... but you need to know the table names.

If you have access to the SP you should be able to view it.

hmmmmmmm

 

[xr280xr]

If you are only expecting a few possible types, you could just cast it to each possible type inside of a few try catch blocks.