param7[1].Value = tbLastName.Text.Length > 0 ? tbLastName.Text : DBNull.Value;
Why is this impossible, and any suggestion what else to try? If/else for 20 parameters is just not way.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
The issue is that (as the error message indicates) the conditional expression needs either identical types on both branches, or else there needs to be an implicit conversion from one of the types to the other. In your case, there isn’t one, and so you get the error. One quick fix would be cast one of the values to (object) (which is fine, since DbParameter.Value is of type object anyway.)
So this should work for you:
param7[1].Value = tbLastName.Text.Length > 0 ? tbLastName.Text : (object)DBNull.Value;
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0