SqlDBType size

[tshad]

I have a variable of SqlParameter type called parameter.

I need to find out what the original size is to compare it with the actual
size of my string.

parameter.size gives me the size of the string but not the size of the
varchar I originally set.

I also need to know if it was set to MAX. Is there a way to get this?

I looked at all the attributes in the debugger and can't seem to find it.

Thanks,

Tom

 

[Ignacio Machin ( .NET/ C# MVP )]

I have a variable of SqlParameter type called parameter.

I need to find out what the original size is to compare it with the actual
size of my string.

parameter.size gives me the size of the string but not the size of the
varchar I originally set.

I also need to know if it was set to MAX.  Is there a way to get this?

I looked at all the attributes in the debugger and can't seem to find it.

Thanks,

Tom

Hi,

I was under the impression that Size represent the size passed in the
constructor. It's independend of the size of the Value assigned.
Leavnig the Size empty is like saying MAX