How's this Double.Parse statement work?!

Anna Hawks

I'm updating an old program (written in VS2003 and updating in VS2005) and found the following statement:

sql.Parameters.AddWithValue("@acheck", Double.Parse(txtAmtCheck.Text == "" ? "0.0" : txtAmtCheck.Text));

I'm assuming the intention was to substitute a zero if the textbox was blank -- based on the fact that I get the error that it can't enter a null into that field -- but it doesn't
work now. I know I can say, "If tb == ""....", but I was just curious if anyone had seen anything like this before?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

18y ago
Worse case scenario youll just have to break it down and see if that works:

SqlParameter param = new SqlParameter();
param.ParameterName = "@aCheck";
param.Value = Double.Parse(String.IsNullOrEmpty(txtAmtCheck.Txt) ? "0.0" : txtAmtCheck.Text);

sql.Parameters.Add(param);

Its weird, because the type double is a struct, it doesnt like null values. Just keep breaking it down and checking the variables, maybe a null is being inserted into the parameter through the Double.Parse() method.

Man... the text formatting on this forum is WEIRD...
0
Anna Hawks18y ago
Yes, I'm getting a null value, but not consistently. I'll try your suggestion -- thanks!
0
18y ago
I dont see why it wouldnt work, thats just weird. Basically it just says "If txtAmtCheck.Text is empty, then parse 0.0, else parse the text in the txtAmtCheck.Text property".

What error is it giving you? Is it saying that your attempting to insert a null value into the parameter? If thats the case, try this:

sql.Parameters.AddWithValue("@acheck", Double.Parse(String.IsNullOrEmpty(txtAmtCheck.Text) ? "0.0" : txtAmtCheck.Text));
0