How's this Double.Parse statement work?!

Question

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?

Brandon Lewis · Answer

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...

Anna Hawks · Answer

Yes I'm getting a null value but not consistently. I'll try your suggestion -- thanks!

Brandon Lewis · Answer

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));