Sqlparameter and null

The total number of digits to the left and right of the decimal point to which Value is resolved. The total number of decimal places to which Value is resolved.

One of the DataRowVersion values. The Size and Precision are inferred from the value of the dbType parameter if they are not explicitly set in the size and precision parameters. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Sql Parameter Constructors Reference Is this page helpful? Is Nullable Property Reference Is this page helpful? Please rate your experience Yes No.

Any additional feedback? Namespace: System. SqlClient Assembly: System. If not, it adds the parameter and sets the value. Eliminates the loop issue discussed in the previous comments. I might give that a try one of these days. Re: A performance hit has been been brought to my attention by t Your "Set" method is a great idea though, but that could be a big performance hit looking up the parameter name, unless SqlParameterCollection uses a nice hash table or something.

Shout if you need help with it. Re: My opinion is that specifying the type for a Parameter is us My opinion is that specifying the type for a Parameter is useless and limiting.

That's all well and good, but don't keep clearing and recrea That's all well and good, but don't keep clearing and recreating the parameters. Create the parameters once, before the loop, then set the Values within loop.

I never use AddWithValue anyway. Re: Thanks, that was really a very quick and dirty piece I used Thanks, that was really a very quick and dirty piece I used as an example.

I have removed the loop so as to prevent noobs using it like that in loops. You're right. I was using the wrong terminology. Also, I think that if statement obstructs the intention of the code which is simply to add a parameter. It gives the appearance of something more complicated happening. But you're right, it's not very generic and doesn't provide any advantage over 3. The content you requested has been removed.

Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Architecture for ASP.

NET application designs. Sign in to vote. User posted An exception will eventually be caused by the following line if clientID is null. I can think of four ways to get around this: 1. Wrap the statement in an approriate if-else statement checking if clientID is null.

Value if the parameter is null: cmd.