Sqlcommand add null parameter

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. Create a free website or blog at WordPress. Saaed's Blog. Home About.

NET July 1, There for if you want to pass a null value to your database the following code will throw an exception, saying the parameterized query was expecting a value for NullableId which was not provided. NET Nothing is not the same as a database null. BeginTransaction ; command.

Clear ; command. AddWithValue " NullableId " , null ; command. ExecuteNonQuery ; trans. Dispose ; trans. Value; else param. It would make our code a lot more cleaner and more readable. Could you show us the complete SQL? I will update the question shortly. For some reason, my edit won't post. Show 3 more comments. Active Oldest Votes. Try this : command. DBNull ;.

Gaurav Gaurav 4, 6 6 gold badges 45 45 silver badges 75 75 bronze badges. What is the fix here? Value — Nick N. Add a comment. Sai Avinash Sai Avinash 4, 16 16 gold badges 54 54 silver badges 93 93 bronze badges.

It would actually be command. Value and the SqlCommand. Add method has been deprecated. I'm null coalescing because sometimes the value is not null and I don't want to always pass null.

Most of my parameters are strings and therefore nullable, but the parameters that are floats and DateTimes have been explicitly defined as nullable. AddWithValue " parameterName",Convert. RononDex 3, 20 20 silver badges 35 35 bronze badges. Collectives on Stack Overflow. Learn more. Asked 13 years, 3 months ago.

Active 8 years, 9 months ago. Viewed 32k times. Am I doing it wrong? Community Bot 1 1 1 silver badge. RodgerB RodgerB 8, 9 9 gold badges 35 35 silver badges 47 47 bronze badges. Add a comment. Active Oldest Votes. Marc Gravell Marc Gravell k gold badges silver badges bronze badges. That's a really good solution.