>>The CreateParameter method takes care of that for you. If you pass in a string it will be a string. If you pass in a zero it will be an integer. The length gets set also. I just tested and with a string of "00" the length gets set to 2.
>>Tim
>>
>
>Ok, I'm also guessing you have overloads to pass length and type explicitly, right?
>
>BTW, do you have to create parameter as IDbDataParameter or you can create it as SQLParameter (and probably cast the result of it to SQLParameter unless another method exists).
>
>Also, do you agree that the extra declaration of a parameter seems like a typo in the manual?
By the way, wouldn't this be a better fit to call a function? I think I will test that.
Tim
Timothy Bryan