What to put in for size when adding a parameter

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

When you're adding parameters to a sqlcommand, what do you put in for
the size value? I need to put in the size because this is the only
overload with sourceColumn and I need that.

This is what I have corresponding to the types

'size=10, since Int is max of 10 digits
MyCommand.Parameters.Add("@MyInt", SqlDbType.Int, 10, "MyInt")

'size=19, since BigInt is max of 19 digits
MyCommand.Parameters.Add("@MyBigInt", SqlDbType.BigInt, 19,
"MyBigInt")

'size=4, since MyString is length 4
MyCommand.Parameters.Add("@MyString", SqlDbType.Char, 4, "MyString")

Is this correct?

Thanks...
 
That probably is correct. Note that for fixed width data
types, the value of Size is ignored. So, for int, long,
etc. the Size does not matter.

Tu-Thach
 
Back
Top